PAGE BREAK PREVIEW

  • Thread starter F. Lawrence Kulchar
  • Start date
F

F. Lawrence Kulchar

I don't know what I did, But all of a sudden, my spread sheet (17 sheets) is
filled with dotted lines labeled Page 1, Page 2, Page 4.....etc. down to Pge
12>

It is showing the page breaks that will occur if I hit "PRINT" which I do
NOT want to do.

How do I get rid of these dotted line? and get my spread sheet back to
normal...---there are not even any cells outside the dotted lines!

Please help.

Thanks,

FLKulchar
 
S

Sean Timmons

Just go to View - Normal.

Also, if you still see dotted lines in Normal View, go to Tool - Options and
remove View Page Breaks checkmark.

If page break preview is highlighting pages that don't have any data, you
can highlight all rows/coluns below and to the right of your data, Edit -
Delete. Go back to cell A1 and save.
 

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

Similar Threads

how do I remove dotted page break lines from my workbook pages? 7
First page of Excel sheerepeats in print layout or print preview 1
Dotted Linestyle is not seen in Print of the excel 1
don't show the page breaks on the worksheet 2
To remove dotted lines in Microsoft Excel ? 2
Dotted lines 3
How to remove dashed page lines after using print preview 1
Page Break 1

Top