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

How to keep a large data set on one sheet that prints out multiple pages?

I am using an Excel workbook to track business earnings and expenses for my gig work. Mileage logs for quarters 1 and 2 all fit on one page with room to spare, but Quarter 3 is in excess of the 65 rows I have available in my print area.

I have opted to create an additional sheet for the latter part of quarter 3, but I have run into a slight inconvenience in keeping all references updated to "Sheet 2 of 2" after using "Sheet 1 of 2" to update the quarter 3 grand total on "Sheet 2 of 2". Is there a good way to fit about 102 rows on one sheet that prints out into two separate pages without a lot of manipulation?

I think stacking two 51-row sections over one another using View > Page Layout to guide me may work, but I don't want to mess anything up. Is there a better way I could do this? I could also back track and just make every mileage sheet contain 2 parts, as I could very well run into this issue in the future when I plan to reuse this sheet.

I can't share any great screenshots because every sheet contains personal information, but here is a portion of my sheet list.

Version: Microsoft® Excel® for Microsoft 365 MSO (Version 2607 Build 16.0.20228.20190) 64-bit

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

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com
#Excel
#workbook
#print area
#multiple pages
#sheet
#rows
#references
#grand total
#Page Layout
#mileage logs
#business earnings
#expenses
#gig work
#Microsoft 365
#version control
#data set
#manipulation
#printing
#sheet references