Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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


  #2   Report Post  
Bryan Hessey
 
Posts: n/a
Default Extra Row in Defined Print Area


If you are in File, Page Setup, and select the Sheet tab does the row
504 show in the 'Area' or the 'repeat at top'.

If you select your area from the Area dropdown can you 'OK' the otions,
and re-select File, Page Setup, Sheet again. Does the 504 row show at
this point?

If you then print and re-visit the 'Sheet' options is the Area setting
changed?

Can you determine at what point the corruption occurs?

Are there any macros or VB code connected with this Workbook that might
affect print selection?
(Tools, Macro, Macros for Macros, or Press Alt & F11 to see VB code)


Harry Gordon Wrote:
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



--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=484602

  #3   Report Post  
Harry Gordon
 
Posts: n/a
Default Extra Row in Defined Print Area

Bryan, thank you for your reply. Because of a timing situation, I went ahead
and just re-entered the information in another row and deleted the affending
row and now everything is working fine. Fortunately, the data was straight
forward without a lot of formulas or cell references.

Thanks again,

Harry

"Bryan Hessey"
wrote in message
news:Bryan.Hessey.1yfbmq_1131865830.9736@excelforu m-nospam.com...

If you are in File, Page Setup, and select the Sheet tab does the row
504 show in the 'Area' or the 'repeat at top'.

If you select your area from the Area dropdown can you 'OK' the otions,
and re-select File, Page Setup, Sheet again. Does the 504 row show at
this point?

If you then print and re-visit the 'Sheet' options is the Area setting
changed?

Can you determine at what point the corruption occurs?

Are there any macros or VB code connected with this Workbook that might
affect print selection?
(Tools, Macro, Macros for Macros, or Press Alt & F11 to see VB code)


Harry Gordon Wrote:
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



--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:

http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=484602



  #4   Report Post  
Bryan Hessey
 
Posts: n/a
Default Extra Row in Defined Print Area


Thanks Harry.

Harry Gordon Wrote:
Bryan, thank you for your reply. Because of a timing situation, I went
ahead
and just re-entered the information in another row and deleted the
affending
row and now everything is working fine. Fortunately, the data was
straight
forward without a lot of formulas or cell references.

Thanks again,

Harry



--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=484602

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
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 08:44 AM.

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

About Us

"It's about Microsoft Excel"