How to print multiple pages of a single (but very wide) spreadsheet in what would otherwise be empty/wasted whitespace?
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]
Want to read more?
Check out the full article on the original site