LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Harry Gordon
 
Posts: n/a
Default Extra Row in Defined Print Area

I am working with Excel 2000. I have a spreadsheet that has some 1000 rows
in it. I want to set the print area for rows 850 - 950 and that works fine
EXCEPT that row 504 also gets included in the print area definition. I have
cleared the print area repeatedly, I have set the print area repeated and in
every case regardless of what rows/columns I include in a newly defined
print area, row 504 gets included as the very first row of the print.

If I don't define a print area, row 504 does not get printed. But as soon as
I set a print area regardless of where it is in the spreadsheet, row 504
takes its prominent place at the head of the line :-(. If I delete row 504,
then the set print area works fine. What setting would be forcing row 504 to
be included?

Any suggestions on how to get rid of that row from the defined print area
would be greatly appreciated.

Thank you.

Harry Gordon


 
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
Can't Clear Print Area GeorgeF Excel Discussion (Misc queries) 2 August 5th 05 06:10 PM
Volatile print area stevepain Excel Discussion (Misc queries) 6 July 20th 05 05:46 PM
set the print area print multiple tabs veng Excel Discussion (Misc queries) 5 February 12th 05 07:01 PM
Printing - Have to set print area 1 column further than necessary STUART BISSET Excel Discussion (Misc queries) 0 January 24th 05 07:59 PM
Changing print area Aaron Excel Discussion (Misc queries) 2 January 9th 05 05:58 PM


All times are GMT +1. The time now is 03:56 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"