SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    Headed Home! KM Richards's Avatar
    Join Date
    Feb 2007
    Location
    I'm right Here!
    Posts
    707
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question 'bout printing Excel Worksheet

    I have an Excel (2003 Professional) worksheet with 44 tabs (pages) showing down at the bottom and I'd like to print all 44 pages at once.

    Right now, all I can figure out is how to print one at a time which is time consuming.

    How can all 44 pages be printed all at once?

  2. #2
    Headed Home! KM Richards's Avatar
    Join Date
    Feb 2007
    Location
    I'm right Here!
    Posts
    707
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I tried printing with Open Office and it keeps on cutting off the right side of each page but at least I can print all 44 pages at once.

    There doesn't seem to be a way of getting the program to print the page wider than how it's printing now.

    Anybody know how to do this in Open Office Calc?

  3. #3
    SitePoint Member titanscomputer's Avatar
    Join Date
    Nov 2010
    Location
    Pakistan
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Thumbs up

    You can do this setting your PRINT AREA, following are the step you follow to print all these pages at once:


    1) select all the cells you want to print
    2) Goto File > ... > Set Print Area (I forgetted where this option, because I'm using Excel 2007)
    3) Goto File > Print


    Hope this help You,

    Thanks,

    Muhammad Tayyab Rana

  4. #4
    Headed Home! KM Richards's Avatar
    Join Date
    Feb 2007
    Location
    I'm right Here!
    Posts
    707
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    OK, thanks. When I do statements next month, I'll sit down and see if I can make this work. Thanks for the tips!


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
  •