Pagesetup, Margins, Presentation

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

page breaks

To hide the page breaks
       Tools,  Options,  View (tab),  uncheck  Page Breaks

To change your automatic page breaks, you can move your
       margins  and column boundaries,  which you can do from  
       Print Preview,  Margins 
You can switch between Portrait and Landscape with
       File,  Page Setup,  Page  -- choose  Portrait or Landscape
  another choice would be to change the  Print xx pages wide,  and/or
      Print xx pages high.    Changing the Font size,  or alignment options
      would also change your presentation.  

Another interpretation.   You are in Page Break Preview, where you
see numbers superimposed on your worksheet    from
the View menu  and you would find the 
   Tools, Options, View,  Page breaks
is grayed out.     To get back to the normal view use
   View (menu),  Normal  (as in normal view) 

Still another interpretation  involving actual changes to the
page breaks rather than seeing them..    

To remove all inserted manual page breaks.
     Select all cells (ctrl+A)
     Insert (menu),  Replace ALL Page Breaks

To remove a specific page break on a column
     Select the column after the page break.
     Insert (menu),  Remove Page Break

Similar action to remove page breaks before  row(s).

Automatic page breaks will be changed as required based on
any addition or removal of manual page breaks. 

You can insert a manual page breaks before a selection use 
         Insert (menu),  Page Break.
   A page break will be inserted before the selection.

   If  you select a column the break will be inserted before the column.
  
   If you select a row, the page break will be inserted before the row.

   If you choose a cell say at   D48  or a range like D48:G54,
   a page break will be inserted before row 48 and a page break
   will be inserted before column D.

Choose correct orientation (#orientation)

Choose an orientation that fits the data best -- Vertical or Horizontal, under file, page setup, General (tab).

Headings for Columns, and Page Numbering, Repeating column and row heading information (headcols) in printed report (page setup) or on screen (Window/Freeze Panes).
Logo at top (logoshd) of first page only or entire report. (on first page only, is different you might be interested in the following page placing a logo on the first page (at the top).
Freeze Panes for view and Repeat descriptive row/col headings for printing
Page Breaks and Page Breaks, and Inserting Blank Rows
Pathname in Headers and Footers
Repeating column and row heading information (headcols) in printed report (page setup) or on screen (Window/Freeze Panes).
Slow Response (#pagesetup), aspects of pagesetup than slow things down, such as display of page breaks after a Print Preview.

Excel questions not directly concerning my web pages are best directed to newsgroups
such as news://msnews.microsoft.com/microsoft.public.excel.misc where Excel users all around the clock from at least 6 continents ask and answer Excel questions. Posting suggestions and netiquette. More information on newsgroups and searching newsgroups. Google Groups (Usenet) Advanced Search Excel newsgroups (or search any newsgroup).

This page was introduced on October 18, 2003.

[My Excel Pages -- home] [INDEX to my site and the off-site pages I reference]
[Site Search -- Excel] [Go Back] [Return to TOP]

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

Pagesetup, Margins, Presentation

page breaks

Choose correct orientation (#orientation)

Related (#related)