dashes around cells

L

lsg

working w/sprdsht w/363 lines; when I go to print it says 174 pages, even
after setting print area. From lines 59-363 the cells have dashes around
them, but lines 1-58 do not have dashes. I did go into to format cells and
tried to fix the cells with the border format, but it is a "no go". I am not
sure what happened; can anyone help to get the dashes from around the cells?
Thx.
 
D

Dave Peterson

Have you tried selecting all the cells, then removing page breaks.

In xl2003 menus:
Insert|Reset all page breaks
 
L

lsg

I did try that but it did not work...Thanks.

However, I found the error: it was in the Page Setup, Rows to repeat at top
that made the worksheet have so many pages. Once the rows to repeat was
cleared, the worksheet reduced to seven pages!

Thank you for your reponse Dave...
 
D

Dave Peterson

Thanks for posting back with your solution.

I would have never guessed that.
 

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