1st 2 rows of wksht show up @ top of each page of the wksht

  • Thread starter Remote Paralegal
  • Start date

R

Remote Paralegal

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
 
Ad

Advertisements

T

Thomas [PBD]

Remote Paralegal,

If you go to File>Page Setup>Sheet>Rows 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.
 
Ad

Advertisements

S

Sean Timmons

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 said:
Remote Paralegal,

If you go to File>Page Setup>Sheet>Rows 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 said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top