MS Excel Tip: How to Paste Column Widths

I know if you work with spreadsheets and particularly Microsoft Excel, you must be annoyed with the column widths according to your liking. To copy paste cells, you can use Ctrl+C and Ctrl+V. But the problem is, that doesn’t paste column widths that can accommodate the data. So what happens is you literally get to see an incomplete story. So what should you do to avoid this? Here is a guide to avoid this in 1 minute.

• Use the normal Paste option to paste in the data and cell formats
• Right click on the new range of data you have pasted
• Click the Paste Special, and select the Column Widths radio button.

You may want to read 10 Hacks for MS Word 2007 and 10 Hacks for MS Excel 2007 and try them. Trust me, they will do wonders. You can also bookmark these pages.