Column Width-Apply to whole workbook

J

Jenny

I would like the custom column width I have applied to the first sheet in a
workbook to apply to all following sheets. I have tried the format painter
option, but that doesn't apply/change the column widths. I am on Excel 2004
for Mac. Thanks!
 
A

Anne Troy

You should be able to Group your worksheets first. On Windows, I would
right-click the sheet tab and choose Select All Sheets. Then select your
columns and set the width, then right-click the sheet tab again and choose
Ungroup sheets.
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge Directory Conditional Page Break 0
VBA - (re-) Set a Table Style 2
Table Preferred width is changed when pasting 1
MS Project Center-Autolink column fields 0
Problem with MS Word paragraph and character styles: format getting messed up 2
How to modify and updte specific styles for specific paragraphs across the document 0
Loop through pages and insert header image 0
Table Column Widths Fixing Size in Word 2010 4

Top