Tech Support Guy banner
Status
Not open for further replies.

Enlarging spreadsheet to fill page

91K views 6 replies 5 participants last post by  XL Guru 
#1 ·
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!
 
#5 ·
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.
 
#7 ·
>> 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
 
Status
Not open for further replies.
You have insufficient privileges to reply here.
Top