ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   FORMAT EXCEL WORKBOOK (PAGE SETUP) ALL AT ONCE INSTEAD OF BY PAGE (https://www.excelbanter.com/excel-discussion-misc-queries/198389-format-excel-workbook-page-setup-all-once-instead-page.html)

Fred

FORMAT EXCEL WORKBOOK (PAGE SETUP) ALL AT ONCE INSTEAD OF BY PAGE
 
how can i format an excel workbook all at once instead of by each page
separately (landscape, header, footer)?

Peo Sjoblom[_2_]

FORMAT EXCEL WORKBOOK (PAGE SETUP) ALL AT ONCE INSTEAD OF BY PAGE
 
Before you do any changes select all sheets (click the first, hold down
shift and click the last), do the changes and then right click any sheet and
select ungroup sheets

--


Regards,


Peo Sjoblom

"fred" wrote in message
...
how can i format an excel workbook all at once instead of by each page
separately (landscape, header, footer)?





All times are GMT +1. The time now is 04:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com