Remove page breaks

C

Carole O

Excel 2003

I sorted a spreadsheet, and when I resorted it, page breaks appear after
every row starting with row 30. If I change the sort to another column, the
same thing happens - every row after row 30 has a page break. Drag and drop
is checked, page breaks is unchecked in Tools/Options.

TIA
CaroleO
 
J

Jacob Skaria

If Tools>Options>Page break is unchecked...are you sure this is a page break
or a dotted line border..Select the range and press Ctrl + Shift + _ to
remove the borders...

If this post helps click Yes
 
C

Carole O

It was a hiccup!! When I opened the file this morning, everything was fine.
But - to answer your question, when I did a print preview, I had 187 pages -
anything after row 30 was its own page.
 

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