View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Remove page breaks

If ToolsOptionsPage 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
---------------
Jacob Skaria


"Carole O" wrote:

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