I'm a lifestyle journalist and I've been writing about office productivity software for a long time. Here you'll find handy hints, tips, tricks, techniques and tutorials on using software as diverse as Excel, Word, PowerPoint, Outlook, Access and Publisher from Microsoft and other applications that I love. My publishing credits include PC Magazine, Windows XP mag, CNet, PC User mag, SmallbusinessComputing.com, Winplanet and Sydney Morning Herald.
Copy and paste a range in Excel and you get everything except the column widths. They get left behind and sometimes that’s a big nuisance. When you need to paste column widths too, paste your cells and don’t move. Choose Edit, Paste Special and click Column widths and the column widths of the new cells adjust to match the source.
Easy when you know how…
Labels: column widths., Excel tip
Labels:Uncategorized
Please feel free to add your comment here. Thank you!
Thanks so much for posting this tip regarding pasting Excel column widths. This has been driving me nuts for a long time!! Your article is the only one I’ve found that is concise and helpful.
Thank you so much. I have been trying to solve this problem for quite a while!