universal formatting of all cells in all worksheets

J

jeremyrod

I have 140 sheets in an excel document. In column AF I
want the width to be set to 15.86.
Instead of going to every sheet and making the change, is
there a way that I can set the width for that column in
all of the sheets
 
D

Don Guillett

right click on a sheet tab>select all sheets>set whatever on the sheet you
are on>select any One sheet.
 

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

Format column widths from one table to a separate table on same page 1
Cell data entering slow! 0
"cannot shift objects off sheet" error 8
Table Preferred width is changed when pasting 1
Excel does not accept text format! 0
Can we use outlook calendar as an universal place post work schedules for all the users? 0
Dealing with a Pivot Table (when I don't want to) 0
VBA - (re-) Set a Table Style 2

Top