Page Breaks

Location: http://www.mvps.org/dmcritchie/excel/pagebreaks.htm Home page: http://www.mvps.org/dmcritchie/excel/excel.htm [View without Frames]

Help topic: What to do before you print

Preparing to print Microsoft Excel provides lots of optional settings that let you adjust the final appearance of the printed page to suit your needs. To make sure you've checked everything likely to affect your printout, follow the steps that are listed to the left in the order shown.

Viewing how your worksheet will print Microsoft Excel provides three ways to see and adjust how the worksheet will look.

Normal view The default. It's best for on-screen viewing and working.

Print preview Shows you the printed page and lets you easily adjust columns and margins.

Page break preview Shows you what data will go on each page and lets you quickly adjust the print area and page breaks. As you make settings that affect how your worksheet will print, you can switch between the different views to see the effects before you send the data to the printer.

See "What to do before you print" in Help for an overview of: Format the sheet onscreen; Add Headers and Footers; Repeat titles on every page; Change the layout; Preview and adjust margins; Check page breaks.

Additional onsite Information: headers/footers, Repeating column and row heading information.

Once you print a page or use Print Preview, Excel figures out the page breaks and you will see them as bold dashed lines on your sheet. This may slow down your use of Excel considerably depending on what print drivers you are using, for instance. They can really slow down macros to the point that you may want to turn off Display Page Breaks in some macros. Examples such as when you change the page layout by hiding/deleting/inserting rows/columns so that Excel has to recalculate page breaks with each change.

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

Unsplitting Groups of Rows that should not be split apart:
To remove manual page breaks within a group and set a page break at the beginning of the group. See HELP topic "HPageBreaks Property Example" or newsgroup thread.

Testing for and Removing Manual Page breaks in Excel 95 (prior to Excel 97), John Green, programming, 1997-08-13

Logo at top (logoshd) of first page only or entire report.
Page Breaks and Page Breaks, and Inserting Blank Rows
Pathname in Headers, Footers, and cells
Q199505 macro may take several minutes if page breaks are visible.
Repeating column and row heading information (headcols) in printed report (page setup) or on screen (Window/Freeze Panes).
Slow Response, particularly topic: Page Setup and speed.

You are one of many distinguished visitors who have visited my site here or in a previous location Since created June 23, 2001.

Visit [my Excel home page] [Index page] [Excel Onsite Search] [top of this page]

Please send your comments concerning this web page to: David McRitchie send email comments

Page Breaks

Related