+ Reply to Thread
Results 1 to 2 of 2

Change number of pages printed

  1. #1
    Registered User
    Join Date
    07-20-2007
    Posts
    4

    Change number of pages printed

    I have a multi-page spreadsheet. I want to print all columns on one sheet (1 page wide) and I want to change the number of pages printed (4, 5, or 6 pages tall). I went to Page Setup and I set 1 page wide and 6 pages tall but the spreadsheet still prints 1 page wide and 4 pages tall. It is very difficult to read this spreadsheet when printed 4 pages tall. How can I change the number of pages tall the spreadsheet prints?

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Change number of pages printed

    Good afternoon MilusC

    Delete all of your page breaks.
    Page breaks will over-rule what you use in the pages tall box.

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Need a macro that will change a po. number it is printed
    By Alpinegp in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-04-2014, 04:44 PM
  2. Replies: 1
    Last Post: 12-05-2012, 05:30 AM
  3. Replies: 3
    Last Post: 12-14-2011, 08:04 PM
  4. Number of pages to be printed
    By jonhfl in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-07-2011, 06:28 PM
  5. two pages printed on one
    By John_G in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-04-2008, 01:50 PM
  6. Replies: 3
    Last Post: 12-21-2006, 05:07 AM
  7. Excel 2003 - Determine the number of printed pages
    By SMORGS in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-05-2005, 07:00 PM
  8. [SOLVED] Get number of pages to be printed - before print
    By Les Stout in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-27-2005, 01:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1