March 21, 2026•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Printing with continuous pages for sheets

Our take

Printing spreadsheets without page breaks can be frustrating, especially when your data fits within fewer pages than the printer allocates. If you've already adjusted various settings without success, it may be worth revisiting the print layout and scaling options in your software. Ensure that the "Fit to Page" or similar settings are correctly configured to avoid excess pagination. Additionally, check for any margins or header/footer settings that could be pushing content to new pages.

Hi there, I've been trying to make this work for the past hour or so, and nothing I find anywhere is doing what I actually want it to, so hoping someone here can help:

I have a workbook with 4 sheets that I want to print with no page breaks (so, say sheet 1 fits on half a normal page, I want sheet 2 to start being printed on the latter half of page 1, rather than the print only doing that first sheet on page 1 and starting sheet 2 on page 2), but literally everything I try does nothing. I know that the data in the workbook fits in only 3 pages, but it's being forced to print in 5, which is really annoying and a waste. I've changed probably every single setting I can see, but nothing has made the print continuous. What am I doing wrong?

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

Read on the original site

Open the publisher's page for the full experience

View original article →

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. submitted by /u/jakesyma [link] [comments]

Tagged with

#Excel alternatives for data analysis#generative AI for data analysis#financial modeling with spreadsheets#natural language processing for spreadsheets#google sheets#rows.com#big data management in spreadsheets#conversational data analysis#Excel compatibility#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#Excel alternatives#data analysis tools#data cleaning solutions#printing#sheets#workbook

Printing with continuous pages for sheets

Related Articles

Tagged with