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.
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:
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
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
Copyright © 1997 - 2004, F. David McRitchie, All Rights Reserved