LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default Selecting Pages to Print

You can define your print area to be something other than a rectangular block
(in your example, A1:BG100)--or even discontinuous ranges--by using the CTRL
key.

First hightlight A1:M100. Then hold the control key while you highlight
N1:BG25. Then set your print area.

"JBoyer" wrote:

In my worksheet Column A:M (which fit on one page) go down around 100 rows,
then from N:BG (which is three pages) only use about 25 rows

So basically if I would hit print It would print 12 pages, 6 of which would
be blank. I would like to set it up so that it only prints the pages with
data, and preferably save it that way so I will not have to make the changes
everytime I print. Hope someone can understand this and can help.

 
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
My excel spreadsheet won't print or print preview all the pages? whirlybird Excel Worksheet Functions 2 April 4th 23 10:50 AM
Can't print 3 pages of a workbook,it will only print one PeterM Excel Discussion (Misc queries) 2 July 23rd 07 07:18 PM
Print Area ranges print on separate pages? Lyndon Excel Discussion (Misc queries) 1 December 29th 06 05:22 PM
need a print macro to print only a certain number of pages Tonso Excel Discussion (Misc queries) 2 July 26th 06 06:03 PM
How to print odd pages and even pages seperately in Excel. DILNAVAS Excel Discussion (Misc queries) 1 June 14th 06 11:45 AM


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

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

About Us

"It's about Microsoft Excel"