Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 1st 2 rows of wksht show up @ top of each page of the wksht

In a worksheet, when in print preview or when worksheet is printed, I find
that the first two rows of a category of an accounting appear at the top of
each page of the worksheet (unwanted). The numerical entries don't add into
the total of each category, but the rows appear as if they're a part of that
category, again, at the top of each page of that worksheet. help. I've
checked to see if they're a header, but they aren't.

I'm new at Excel, obviously. Please enlighten me. LT
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 154
Default 1st 2 rows of wksht show up @ top of each page of the wksht

Remote Paralegal,

If you go to FilePage SetupSheetRows to repeat at the top
If something is in there, it will repeat at the top of every printed page.
Just delete that if you wish.

--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''''Yes'''' below.


"Remote Paralegal" wrote:

In a worksheet, when in print preview or when worksheet is printed, I find
that the first two rows of a category of an accounting appear at the top of
each page of the worksheet (unwanted). The numerical entries don't add into
the total of each category, but the rows appear as if they're a part of that
category, again, at the top of each page of that worksheet. help. I've
checked to see if they're a header, but they aren't.

I'm new at Excel, obviously. Please enlighten me. LT

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,696
Default 1st 2 rows of wksht show up @ top of each page of the wksht

Just a small FYI. You can only edite the rows to repeat at top when you
access Page Setup from worksheet view. If you go to Print Preview, you will
not be able to change this option.

"Thomas [PBD]" wrote:

Remote Paralegal,

If you go to FilePage SetupSheetRows to repeat at the top
If something is in there, it will repeat at the top of every printed page.
Just delete that if you wish.

--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''''Yes'''' below.


"Remote Paralegal" wrote:

In a worksheet, when in print preview or when worksheet is printed, I find
that the first two rows of a category of an accounting appear at the top of
each page of the worksheet (unwanted). The numerical entries don't add into
the total of each category, but the rows appear as if they're a part of that
category, again, at the top of each page of that worksheet. help. I've
checked to see if they're a header, but they aren't.

I'm new at Excel, obviously. Please enlighten me. LT

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
Printing multiple page wksht w/pictures B-mia Excel Discussion (Misc queries) 1 July 31st 08 02:56 PM
Can I copy page set ups in Excel 2003 from one wksht to another MHacct Excel Worksheet Functions 1 August 9th 07 05:40 PM
How do I Change Column Width for only some rows in an Xcel WkSht cherokee Excel Discussion (Misc queries) 1 July 30th 06 01:22 AM
Adding a collection to a wksht CLamar Excel Discussion (Misc queries) 1 June 23rd 06 04:31 PM
Need macro to remove duplicate rows in a wksht with same order# G2 in AUS Excel Discussion (Misc queries) 2 December 16th 05 05:44 PM


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