HOW DO I FORMAT AN ENTIRE WORKBOOK ALL AT ONCE?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
You must log in or register to reply here.

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

Conditional formatting of entire workbook 3
WorkBook Update 3
Excel Highlighting duplicates 0
Collapsing all groups 0
Referencing text in merged cells 1
Adding like cells from different workbooks 1
Method of viewing/naming columns or conversions for same 3
All sheets in workbook have same rows to repeat at top 1

Back
Top