|
"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.
- Select a range of cells from the original worksheet that include the columns you want to copy
- Choose Edit, Copy.
- Switch to the new sheet and click in any cell in the column where you want the copied widths to begin.
- 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)
|
|