how do I remove dotted page break lines from my workbook pages?

M

marcusaurelius

I have been maintaining an excel workbook for years - it is a log - that
never gets printed. Suddenly, out of the blue, I have page break dotted lines
on the pages/sheets. How do I get rid of them?
 
B

Barb Reinhardt

I'm guessing you have it set to view the page break preview. Try VIEW ->
NORMAL.

HTH,
Barb Reinhardt
 
R

Ragdyer

I just close and re-open the WB.

If you're in the middle of something, and don't want to do that, change
something in <Page Set-Up>
I click on "Fit To 1 Page Wide & Tall".

That usually clears it.
 
D

Debra Dalgleish

Or choose Tools>Options, and on the View tab, under Window Options,
remove the check mark from Page Breaks.
 
R

Ragdyer

I never used, or thought about that before!<bg>

Every time I'm in that window, it's unchecked by default.

I guess I never went back to check after I perhaps set the print area.
 
C

challa prabhu

Hi,

Do the following;

1. On the Tools menu, Click Options, The Options dialog is displayed.
2. Click the View tab.
3. Under the Windows option section, clear Page breaks.
4. Click Ok to return to the worksheet.

Challa Prabhu
 

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