I have set the page breaks in a spreadsheet and for some reason I cannot now drag and move them. I have tried resetting which does not solve the problem, but when I tried to remove the breaks that does not work either. I can extend the thick blue lines on the edges but not the internal blue dotted ones.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Page breaks in Excel
- Thread starter Chris559
- Start date
SkipVought
Programmer
Hi,
The fitted ones are auto breaks. You must drag them UP, not down.
Skip,
[sub]
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
Just traded in my OLD subtlety...
for a NUance!![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
[/sub]
The fitted ones are auto breaks. You must drag them UP, not down.
Skip,
[sub]
Just traded in my OLD subtlety...for a NUance!
[/sub]- Thread starter
- #3
SkipVought
Programmer
Same principle: you can drag a vertical automatic less wide but not more wide.
Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
Skip,
[sub]
Just traded in my OLD subtlety...for a NUance!
[/sub]SkipVought
Programmer
You must work methodically: top to bottom; left to right; shortening any auto break (you cannot lengthen an auto break, down or right).
Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
Skip,
[sub]
Just traded in my OLD subtlety...for a NUance!
[/sub]What is your problem? Automatic (dotted blue lines) or manual (solid blue lines) page breaks are visible in page breaks view. With one click you can remove all manual page breaks in this view - right-click any cell and from the context menu choose this option. The page setup can change scaling of printed page, the distance of page breaks will follow this setting.
If you don't like to see page breaks in normal view, untick page breaks view in window view option, otherwise they become permanently visible after first print, print preview or switching to page breaks view.
combo
If you don't like to see page breaks in normal view, untick page breaks view in window view option, otherwise they become permanently visible after first print, print preview or switching to page breaks view.
combo
- Thread starter
- #7
SkipVought
Programmer
When you say "expand" that tells me that you are trying to move an auto break down or to the right.
You cannot make a page bigger than the page margins!
Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
You cannot make a page bigger than the page margins!
Skip,
[sub]
Just traded in my OLD subtlety...for a NUance!
[/sub]Maybe a conflict with "fit to pages wide" settings. You can only set manual breaks if you haven't told excel to work it out for you!. You may want to "Fit to x pages wide", Make a note of the percent zoom. Then remove the fit to settings and manually apply the zoom % before fiddling with the column breaks
Gavin
Gavin
- Status
