Page Formatting

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

Guest

In Excel, is there a way to format all of the pages within a workbook the
same without having to each sheet individually?
 
If you group the sheets (I assume you mean sheets when you say pages) by
clicking the first sheet tab, hold down shift and click the last sheet tab,
do your formatting and then right click one sheet tab and select ungroup

Regards,

Peo Sjoblom
 
Thank you - that will save time!

Peo Sjoblom said:
If you group the sheets (I assume you mean sheets when you say pages) by
clicking the first sheet tab, hold down shift and click the last sheet tab,
do your formatting and then right click one sheet tab and select ungroup

Regards,

Peo Sjoblom
Click to expand...
 
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

How do I fit to 1 page on entire workbook 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
PROTECT MULTIPLE SHEETS IN EXCEL WORKBOOK SIMULTANEOUSLY? 1
Printing Sheets in a Workbook 3
Apply Conditional Format to all sheets in same workbook 4
can I change page layout in an entire existing Excel workbook? 2
Copy formatting (headers, margins, etc) to another sheet? 3
running number sequences 1

Back
Top