Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Printing / November 2005

Tip: Looking for answers? Try searching our database.

Global Print Specs

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Steve Williams - 21 Nov 2005 21:41 GMT
I have a series of 114 workbooks with 22 worksheets each.  They are setup
for A4 printing.  Is there a way to print all worksheets in each workbook on
8½x11 with row and column headings without specifying it on each worksheet
individually?  I am using Excell 2000.

Steve Williams
Capt Jim Cook - 30 Nov 2005 20:36 GMT
You can do it once for each workbook.  

1) Select the first worksheet tab, then scroll over and hold the <Shift> key
while clicking the last tab.  This will select all worksheets in that
workbook.
2) Define your paper sizes, headings, etc and they will be applied to all
worksheets.

There may be some way to change your system settings, then go to each
workbook and apply default settings, but that is beyond me.  Maybe you can
create a general macro to do it then start each workbook running that macro.
Hopefully, someone else can help with that.

Good Luck,
Jim

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.