How can I get rid of these dotted lines in excel? Simply going to the menu for "remove page break" doesn't do it.
2007-08-24 11:41:13 · 5 answers · asked by twiggy 2 in Computers & Internet ➔ Programming & Design
To turn off the Display of Page Break lines once you've been in Print Preview:
turn off manually: Tools --> Options --> View --> (uncheck) Page Breaks,
turn off in VBA: ActiveSheet.DisplayPageBreaks = False
Page Break lines will appear again and this box will get checked when you print or use print preview.
To turn on or off page break preview which has a large page number in the middle of pages, which you might run across when messing around with these things or setting your zoom to less than .
View, "Page Break Preview" to turn on preview and see large page number
View, "Normal" instead of "Page Break Preview" to turn off page break preview
Manually Remove All User set Page Breaks:
Select all cells (Ctrl+A)
Insert menu --> Reset all Page Breaks
Using VBA to Remove All User set Page Breaks:
ActiveSheet.ResetAllPageBreaks
or remove separately
activesheet.Rows.PageBreak = xlNone
activesheet.Columns.PageBreak = xlNone
2007-08-24 11:46:42 · answer #1 · answered by Dirty Randy 6 · 0⤊ 0⤋
just drag the blue line(page break) whenever you want to resize pages or add more pages on it. If not copy the file and transfer to another... that will help you to get rid of the silly lines ;)
2007-08-24 11:47:18 · answer #2 · answered by A 1 · 0⤊ 0⤋
In the VIEW - PAGE BREAK PREVIEW it will display the page breaks as dotted blue lines. You can click and drag them to where you want them placed.
2007-08-24 11:46:31 · answer #3 · answered by Jeremie I 4 · 0⤊ 1⤋
That is visual. The menu is for added page breaks. The only way to move them is to change the page size or change the size of text, rows and columns.
2007-08-24 11:47:51 · answer #4 · answered by Mike1942f 7 · 0⤊ 1⤋
Press Ctrl Z if that doesnt work i dont know what else will. Sorry
2007-08-24 11:46:17 · answer #5 · answered by deathndoom 3 · 0⤊ 0⤋