HOW DO I FORMAT AN ENTIRE WORKBOOK ALL AT ONCE?

[katie]

ok i have a 21 pg workbook that all nedds to be formatted the same. Can I do
it all at once or am I going to have to go sheet by sheet?

 

[Adrian M]

You can perform the same action on all sheets within a workbook by holding
CTRL down and clicking the sheet names (see how to do it on
http://www.auditexcel.co.za/tips and tricks.html ). Just be very careful
to switch it off again as any change you make will be reflected on all the
sheets e.g. changing a formula.