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.
 
Top