General discussion

Locked

Wrapping print in Excel

By winberry.doyce ·
I have a question for Microsoft Excel. Suppose I have a spreadsheet with
only 5 rows but many columns. By default when I print this spreadsheet
Excel will print it on two or more pages. Is there a way to make Excel
"wrap" the additional columns and print it all on one page?

Thanks for any help you can give.

Doyce Winberry
Road Systems, Inc.

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Wrapping print in Excel

by DKlippert In reply to Wrapping print in Excel

There are a couple of solutions depending on the number of columns represented by "many".
You can choose Format>Cells and choose Wrap Text on the Alignment tab.
You can force the text to wrap by using Alt+Enter to break the line in a cell.
Youcan go to File>Page Setup and choose Scaling Fit to 1 page wide by however pages long and Excel will "Shrink to fit"

Collapse -

Wrapping print in Excel

by winberry.doyce In reply to Wrapping print in Excel

I'm not talking about wrapping text within a cell. For example a spreadsheet with 5 rows and 50 columns that would normally print the 5 rows on the top of 3 pages and leave 3/4 of each page blank. I would like for it to print what would be on page2 below the rows on page 1 and the data from page 3 below the data from page 2. The only way I know to do this is manually cutting and pasting the data on the spreadsheet. I would like to be able to do this automatically. Shrink to fit does not work because it makes the print too small.

Collapse -

Wrapping print in Excel

by DKlippert In reply to Wrapping print in Excel

This is a little difficult in Excel. You can set up a consolidation sheet that refers to the data using reference formulas (=Sheet1!$A$1 etc.).
You can also set up a consolidation/printimg sheet using the camera tool (Tools>Customize and scroll down the Tools list on the Commands tab). This allows you to select an area and then "snap a picture" and place the result elswhere. The snapshot is dynamic.

Collapse -

Wrapping print in Excel

by winberry.doyce In reply to Wrapping print in Excel

Poster rated this answer

Collapse -

Wrapping print in Excel

by jpt In reply to Wrapping print in Excel

Have you tried going to Page Setup and then choosing options. There you will find an area that will allow you to print multiple pages on one page. Unfortunately it scales down each page.

I hope this helps.

Collapse -

Wrapping print in Excel

by winberry.doyce In reply to Wrapping print in Excel

Poster rated this answer

Collapse -

Wrapping print in Excel

by winberry.doyce In reply to Wrapping print in Excel

This question was closed by the author

Back to Software Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums