Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bella
 
Posts: n/a
Default How do I set my workbook up to print only first 2 pages?

I have a workbook with 4 sheets. I want to set my print default to print
only the first 2 pages of the workbook whenever I click on the printer icon.
I do not want to have to do it manually every time I print these pages.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme
 
Posts: n/a
Default How do I set my workbook up to print only first 2 pages?

Set the Print Area.
Select what is to be printer; use command File | Print Area | set Print area
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Bella" wrote in message
...
I have a workbook with 4 sheets. I want to set my print default to print
only the first 2 pages of the workbook whenever I click on the printer
icon.
I do not want to have to do it manually every time I print these pages.



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
Protect Workbook vs Worksheet?? Dan B Excel Worksheet Functions 3 November 7th 05 09:02 PM
Set print area on several pages at once in Excell Workbook? willow Excel Discussion (Misc queries) 2 August 23rd 05 01:31 AM
changing print area in an entire workbook lschuh Excel Worksheet Functions 7 August 4th 05 02:52 PM
How do I print an entire workbook w/diff orientatns to Adobe PDF? Sus Excel Discussion (Misc queries) 0 June 21st 05 06:05 PM


All times are GMT +1. The time now is 03:48 AM.

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"