2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How to print multiple pages of a single (but very wide) spreadsheet in what would otherwise be empty/wasted whitespace?

Our take

Printing a wide spreadsheet can be challenging, especially when faced with excessive whitespace on multiple pages. If you have a single, wide sheet with limited rows, you may want to creatively utilize that empty space to consolidate your printout. This guide will walk you through effective strategies to maximize your printed output, ensuring that subsequent pages leverage the whitespace instead of wasting it. By employing these techniques, you can enhance your printing efficiency and achieve a more streamlined presentation of your data.

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.

submitted by /u/jakesyma
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article

Related Articles

Tagged with

#google sheets#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#rows.com#enterprise-level spreadsheet solutions#modern spreadsheet innovations#machine learning in spreadsheet applications#digital transformation in spreadsheet software#collaborative spreadsheet tools#AI-driven spreadsheet solutions#cloud-based spreadsheet applications#automation in spreadsheet workflows#no-code spreadsheet solutions#AI-powered spreadsheet#spreadsheet API integration#natural language processing for spreadsheets#big data management in spreadsheets#financial modeling with spreadsheets#generative AI for data analysis