1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Enlarging spreadsheet to fill page

Discussion in 'Business Applications' started by kingocouch, May 5, 2005.

Thread Status:
Not open for further replies.
Advertisement
  1. kingocouch

    kingocouch Thread Starter

    Joined:
    Jul 23, 2003
    Messages:
    76
    Hi all,

    I have created a small Excel spreadsheet that fills roughly half of an 8.5x11 page in landscape. I want it to fill the entire page, ie larger cells. The only way I found to do this is to manually set the cell height and width. "Fit to page" seems to be useful only to shrink, not enlarge. Is there an easier way to do this? Thanks!
     
  2. WhitPhil

    WhitPhil Gone but never forgotten Trusted Advisor

    Joined:
    Oct 4, 2000
    Messages:
    8,684
    Is this on the screen, or when you print that you wish to enlarge it?
     
  3. kingocouch

    kingocouch Thread Starter

    Joined:
    Jul 23, 2003
    Messages:
    76
    I would like the printed result to fill the page. Thanks for the help.
     
  4. Bob Cerelli

    Bob Cerelli

    Joined:
    Nov 2, 2002
    Messages:
    22,468
    When you go to print, try:

    File / Page Setup
    Check "Fit to"
    Then have it be 1 pages wide by 1 tall (the default)

    Also, WhitPhil, would have given the same answer. I just happened to get to it before he did.
     
  5. WhitPhil

    WhitPhil Gone but never forgotten Trusted Advisor

    Joined:
    Oct 4, 2000
    Messages:
    8,684
    Well, I "thought" that might be the answer, but it really doesn't do what is desired.

    If you create the 1/2 page spreadsheet and print with that option, you get a 1/2 page spreadsheet.
    If you set the Adjust to option to a number greater than 100, it enlarges the sheet, but unfortunately does it in all directions. IE If you manage to fill the vertical page, you will find that the columns have overflowed to the right, resulting in more pages being printed.

    Or have I missed something obvious?

    kingocouch
    Are you aware of the Format Painter icon? The paintbrush on the tool bar.

    Use it as follows:
    Resize one of the rows to be twice it's normal height.
    Then, select the row, click on the paintbrush, and select all of the rest of the rows.

    The remaining rows will then be the same height as the first one.

    You want to do this resize before applying any other attributes such as lines, bolding, centering, etc. Otherwise these will potentially be carried down.

    And, if you weren't aware, you can resize the rows and columns by clicking on the line in between and then dragging it to the appropriate size.
     
  6. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,447
    Also, to center on page ..

    File | Page Setup | Margins (tab) , check both Horizontally and Vertically at the bottom.

    Note that you may have to enlarge your data to get it to stretch to one page if it is too small (annoying quirk).
     
  7. XL Guru

    XL Guru

    Joined:
    Aug 30, 2003
    Messages:
    2,702
    >> The only way I found to do this is ... manually
    >> Is there an easier way to do this?

    That depends how you're doing it currently (there's no automatic way). Just in case you don't know, there are some shortcuts.

    1. To widen column B, hover over the line between "B" & "C" (the "column headers") at the top. When you're in position, the cursor should change to a thin black cross, with arrowheads on the horizontal bar. Then you can click & drag column B out (or in).

    2. To widen several columns at once, e.g. B, C & D ; click on "B" and drag across to "D". With all 3 selected, drag the line between "D" & "E".

    The same principles apply to rows.

    HTH,
    Andy
     
  8. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/359623