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%20and%20tricks.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.

"katie" wrote:

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?