How to print multiple pages of a single (but very wide) spreadsheet in what would otherwise be empty/wasted whitespace?
Our take
Apologies in advance that I am not going to describe this very well... I've used Excel (at a very low level, lol) for ~20 years, so I am not what you would call/consider a 'power user'.
I have no idea how to describe this properly, so maybe I should start off with what I'm not wanting to do.
I am not trying to get multiple different sheets within a multi-sheet workbook to print on one page...
This is also not something that can be solved (at least not completely) by scaling (e.g. 'Fit Sheet on One Page').
I have just one sheet. It is a very wide spreadsheet that is not very tall (13 rows tall: 1 header row + 12 data rows). But it's so wide that it's currently going to print on 4-6 pages (6 pgs in Excel; 4 in Google Sheets).
But there is (frustratingly) still a lot of wasted whitespace below the workbook/print area on all 4-6 pages.
So what I'm trying to do is to take advantage of all that whitespace and have subsequent pages print below. I could probably get the first three 'pages worth' of the spreadsheet to print on the actual [printed] page 1, and the rest of the spreadsheet to print on page 2.
In Microsoft Word and in Adobe Acrobat, I can print multiple pages per sheet. In Microsoft Powerpoint, I can print multiple slides per page. But I don't seem to be able to do the equivalent in Excel.
I can't attach a copy of my Excel file, but I copied it into Google Sheets, in case actually seeing the file is easier than me telling you about it:
https://docs.google.com/spreadsheets/d/1Jn7m9wT6j1elE4_ikA-FZpXum93DdXEi1uP9UNTOwnU/edit?usp=sharing
If you click 'Print' on this (in Google Sheets), you will have a good idea what I mean in Excel.
I can also save some room by hiding one of the two time-related fields, and probably also the 'Email' and 'Name' fields... but it's still too wide, and I have the same problem.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Excel to PDF and keep formatting!Mostly I’m talking about Row Heights. This excel file is letter summaries. (I have five or eight such gules to do.) I have only two rows - date, and as stated, a summary of the letter. I have tried export, I have tried print to PDF, I have tried save as PDF. None of the options keep my formatting. Some summaries are one, two, or three lines, some summaries are as many as 10, 11, or 12 lines. The column is formatted for wrap text. In the first file I’m working with it’s about 33 pages. On my screen each line looks exactly as I want it to look. Uniform space above and below the letter summary. Which means almost no space, I don’t need any space above and below. My rows are separated with top and bottom borders. No matter what I do, when I turn the file into a PDF, it adds a lot of space above and below the text on the letter summary. This often results in a large portion of the page sometimes remaining empty. I have tried outputting with the default formatting, - meaning I undid wrap text, set the row to adjust to the default height of my font, then re-clicked wrap text so that the height of the row was now determined by how many rows of text in the cell. (I’m sorry if this sounds confusing I’m trying to be very clear. ) Looked great but still had poor formatting when it reached PDF with lots of space in each cell below and above the words of the summary. So I tried tried manually adjusting row heights so that there is very little space above and below the words. Same output. All my googling tells me this is a common occurrence. I am doing this for a client family archives. It needs to look good as a PDF when printed or when viewed on a monitor. The amount of space it’s giving me is a terrible look and not clean or consistent in any way. This might not be the route to go to get the look I need. Can anybody help me with some advice to turn this clean Excel sheet into a clean looking PDF with appropriate formatting? submitted by /u/JvaGoddess [link] [comments]
- Excel in page layout - How to remove pages without any content?My spreadsheet behaves somewhat strangely. The pages without content aren't all greyed out. At the same time the cell grid on those pages is shown cropped. Printing the sheet results in two pages. One with all my content and one that's blank. How do I remove this blank page? Selecting the columns AD to AS and deleting them doesn't solve the issue. On the contrary, it just makes it worse. Now there would be five blank pages when printed. https://preview.redd.it/toybdete030h1.png?width=2473&format=png&auto=webp&s=ec611af7dccf21ccf8806340c93e2efd86392014 Win 11 with Office 2024 submitted by /u/Wild-Sir8868 [link] [comments]
- How to ENLARGE a spreadsheet to fit a page?This is the exact question I have: https://www.reddit.com/r/excel/comments/1kyt0dv/how_to_enlarge_the_content_to_fit_the_page/ that's a year ago with no answer. Wonder if anyone knows a better solution other than manually trying the zoom and keep increasing it till it's too big for 1 page, then back off a little. Seems LOOOOWWWW tech. FYI - anyone saying to click the Fit sheet to one page, fit all columns or fit all rows, that works for BIG sheets. It only shrinks the page. https://preview.redd.it/3tsrk658lqzg1.png?width=263&format=png&auto=webp&s=d6754edbb7cc3eda4457bd4e1b86e9400a645e73 Seems for this decades? old program, there's still room for more features? Again, seems the only work around is to click on custom scaling options and manually try numbers over 100%?? https://preview.redd.it/qkji3uzhlqzg1.png?width=543&format=png&auto=webp&s=9ba8a5e9b462eed3560ad9972d8a56be741f7bc6 submitted by /u/Kangaloosh [link] [comments]