"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Excel Users Become Local Spreadsheet Experts"

Copy Column Widths To Another Sheet

Anytime you create a new worksheet and find that you need column widths the same as those in an existing sheet, there is an easy way to duplicate them.

  1. Select a range of cells from the original worksheet that include the columns you want to copy
  2. Choose Edit, Copy.
  3. Switch to the new sheet and click in any cell in the column where you want the copied widths to begin.
  4. Now click Edit, Paste Special, choose the Column Widths option and click OK.
Now, isn't that much easier?

Why not print (CTRL+P) this tip and share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright 2003 All Rights Reserved by Francis Hayes (The Excel Addict)

If you came to this page from my Excel Mini-Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.