HOW DO I FORMAT AN ENTIRE WORKBOOK ALL AT ONCE?
 

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?

Answer: HOW DO I FORMAT AN ENTIRE WORKBOOK ALL AT ONCE?
 

Yes, you can format an entire workbook all at once using the "Format Painter" tool in Excel. Here are the steps to follow:

1. Open the workbook that you want to format.
2. Go to the first sheet in the workbook and format it the way you want it to look.
3. Select a cell or range of cells that have the formatting you want to copy.
4. Click on the "Format Painter" button in the "Clipboard" group on the "Home" tab.
5. The cursor will change to a paintbrush icon. Click and drag the paintbrush over the cells you want to apply the formatting to.
6. Release the mouse button to apply the formatting to the selected cells.

Repeat steps 3-6 for each sheet in the workbook that you want to format. This will save you a lot of time compared to formatting each sheet individually.

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?