Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Printing multiple page wksht w/pictures | Excel Discussion (Misc queries) | |||
Can I copy page set ups in Excel 2003 from one wksht to another | Excel Worksheet Functions | |||
How do I Change Column Width for only some rows in an Xcel WkSht | Excel Discussion (Misc queries) | |||
Adding a collection to a wksht | Excel Discussion (Misc queries) | |||
Need macro to remove duplicate rows in a wksht with same order# | Excel Discussion (Misc queries) |