A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How do I copy print formatting to multiple sheets in a workbook?



 
 
Thread Tools Display Modes
  #1  
Old March 28th 06, 11:06 PM posted to microsoft.public.excel.misc
external usenet poster
 
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????
Ads
  #2  
Old March 29th 06, 01:33 AM posted to microsoft.public.excel.misc
external usenet poster
 
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  
Old March 29th 06, 01:34 AM posted to microsoft.public.excel.misc
external usenet poster
 
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
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Use the same name on multiple sheets in same workbook Reds Excel Discussion (Misc queries) 3 January 2nd 06 09: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
Print all charts in a workbook (multiple worksheets) aewsaws Charts and Charting in Excel 3 December 31st 04 10:31 AM
There is no way to view multiple sheets from one workbook kstub Excel Discussion (Misc queries) 3 December 17th 04 08:55 PM


All times are GMT +1. The time now is 11:05 AM.


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