Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PAGE BREAK PREVIEW
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
PAGE BREAK PREVIEW
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. "F. Lawrence Kulchar" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I do page breaks when view menu doesnt page break preview | Excel Discussion (Misc queries) | |||
Remove big gray page number on Page Break Preview??? | Excel Discussion (Misc queries) | |||
change page number watermark in page break preview | Excel Discussion (Misc queries) | |||
change and/or remove page number watermark in page break preview | Excel Discussion (Misc queries) | |||
print preview v page break preview | Excel Discussion (Misc queries) |