Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
BFB@keystone
 
Posts: n/a
Default How do I copy print formatting to multiple sheets in a workbook?

I have a large Excel Workbook (96 worksheets) and I need to set ALL sheets to
the same print formatting (margins, page breaks, footers, etc).
Any ideas????
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default How do I copy print formatting to multiple sheets in a workbook?

Lots of settings can be changed all at once if you group the sheets (select the
first and ctrl-click (or shift-click to select subsequent.

Then when all of the sheets are grouped, try file|page setup and see if you can
change all the settings you want.

Make sure you ungroup the sheets when you're done--almost any change you make to
one of the grouped sheets, you make to the others.

ps. You may want to try it on a few grouped sheets. If it works, then group
all 96.

BFB@keystone wrote:

I have a large Excel Workbook (96 worksheets) and I need to set ALL sheets to
the same print formatting (margins, page breaks, footers, etc).
Any ideas????


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default How do I copy print formatting to multiple sheets in a workbook?

ps. And if they are all the sheets in the workbook, you can rightclick on any
worksheet tab and choose "select all sheets"

BFB@keystone wrote:

I have a large Excel Workbook (96 worksheets) and I need to set ALL sheets to
the same print formatting (margins, page breaks, footers, etc).
Any ideas????


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print all charts in a workbook (multiple worksheets) aewsaws Charts and Charting in Excel 4 May 12th 23 03:45 AM
Use the same name on multiple sheets in same workbook Reds Excel Discussion (Misc queries) 3 January 2nd 06 10:58 PM
In Excel, how do I print the workbook sheets to 2sided paper? workfirst Excel Discussion (Misc queries) 6 July 19th 05 08:33 PM
How do I copy formatting from 1 sheet to next in same workbook? Marlene K. Excel Worksheet Functions 1 July 8th 05 04:15 PM
There is no way to view multiple sheets from one workbook kstub Excel Discussion (Misc queries) 3 December 17th 04 09:55 PM


All times are GMT +1. The time now is 03:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"