Printing Two Worksheets on a Single Page

"One more thing" (a quote from Lt. Columbo):

Alternatively, you can print your two page hardcopy to a pdf, then use your pdf reader to print that file to your printer using two pages per sheet.

Another complication I noticed was that if each page was set-up to landscape orientation, the two-pages per sheet output would be a portrait page with two landscape half pages one above the other, not exactly what Brian wanted. On the other hand, if each page was set-up to portrait the result would be a landscape page with two parts of the spreadsheet side by side, fulfilling what Brian originally wanted. However, when I tried it with the content of each page squeezed to fit the margins (set to narrow), the two-per-page printout cut off the right-hand side columns, unless I feed a legal page into my printer.(i did not needto set the printer paper size to legal). The reason seems to be that two side-by-side letter-size pages scaled to fit 8 1/2" on a single letter-size page extend beyond the 11 inches available. This may be specific to my printer EPSON WF-7510.

All this weirdness just indicates to me, that although you may get what you want from just your Excel with proper printer settings and a lot of tweaking, you don't have full control of what's going on. Hence using other tricks suggested in the comments or in the older tip (see the link at the end of Allen's tip) is probably better. I feel that creating a "printing worksheet", especially using Excel camera facility, gives the user most control and flexibility over the final result, other than maybe using a third party software.

As a follow-up to Ron S's comment, not only you can have the same printer installed with different drivers, but you can also have multiple virtual printers installed in Windows 10, all using the same printer driver and the same port, but each of them can have different settings, including Pages-per-sheet. See https://www.howtogeek.com/362957/how-to-install-the-same-printer-twice-with-different-settings-on-windows/

Once you have done this and set the desired setting for each printer (this has to be done in Windows, not in Excel) you can select the desired printer at the print time within Excel. When you do this, the default printer preferences are applied to all pages to be printed, even if the content originates from different worksheets. This is the way I mentioned in my yesterday's comment to overcome the idiosyncrasy of Excel.

It works dependably when you switch in Excel from one printer to another, and not always when you use the same printer as previously, so if in doubt switch to a different printer then back to the desired one.

Another convenient use for having the same physical printer set up as two different virtual printers is for single and double sided output.

The Camera tool (see Mike J's comment below) is described in these articles:
https://excelchamps.com/blog/camera-tool/
https://trumpexcel.com/excel-camera-tool/
https://excelribbon.tips.net/T008189_Multiple_Print_Areas_on_a_Single_Printed_Page.html
For an equivalent of the Camera tool, copy (Ctrl+C) a region of the active sheet, then select another cell on any sheet and pick Home > Paste > Linked Picture (Alt+H+V+I).
My Excel Toolbox's DynamicImage macro is similar to the Camera tool. It copies a range of cells and pastes it as a dynamic image in any sheet of any workbook. The image includes cell values plus visible portions of shapes or charts from the copied range. Any changes in the copied range will be reproduced in the dynamic image. The result is a simple dashboard.
See https://sites.google.com/view/MyExcelToolbox/

I am another huge fan of Fineprint which, as Willy says, does much more than just multiple pages reduced to one page. However, I'm amazed that the only mention of the Camera facility is a brief reference in the linked page at the bottom of the tip.

The advantage that this facility is that the separate pages don't even have to be the same size, so you could have one worksheet which uses say 2/3 of the sheet and the other, the remaining 1/3.

Another huge advantage is that you can rotate and scale camera images allowing, for example, automatic portrait and landscape being printed double-sided.

Printing in Windows is more complex than you think. As Allen indicated the application formats the document according to it's own rules. The rules that the application use include limitations and features offered by the specific "Printer Driver", aka "Printer" in Windows, that you select. You can have multiple printer drivers installed that all send to the same physical printer. A common Limitation applied by the printer driver is the minimum margins, a reflection of the physical printer hardware limits. A common feature enabled in the driver is "Duplex" / 2 sided printing. You could have a printer driver installed, that works with the printer hardware, but the printer driver is not aware that the hardware supports 2 sided printing, so the feature is not offered.

Updating the printer driver is not likely to work. The newer version would likely continue to work the same way.
.
You can have multiple "printer drivers" installed in Windows. Then when you are printing you can select which specific "Printer" you want to use
.
On the other hand, go to the printer maker website and see if they have any other printer drivers that will work on your printer. For example, my older HP printer had separate printer drivers to work using HP PCL (Printer Control Language) and PostScript (another PCL) that the printer hardware supported. As well they had a "Universal" printer driver that replaces hardware specific drivers with a single driver for most of their printers. So I could have all 3 printer drivers installed in Windows, showing up in the print dialog as different "Printers" that all work with the same printer hardware.
.
If that doesn't work, try VARIOUS "PDF" printer drivers, including the Windows PDF printer. There are several free ones you can get. You may be able to print to PDF (file) then print to paper to get the feature to work (but probably not in this case).

There is one more idiosyncrasy for Excel/printer properties that may explain Brian's inability to get two pages on one sheet, at least in my MS365/Win10.

Excel seems to set printer properties per worksheet, so if two print ranges come from two different sheets, pages per sheet may be set to 2 for one range and to 1 for another. To check this, go to page preview and check printer properties for each page to be printed. Use navigation buttons on the bottom to switch pages. On my system, switching it for one previewed page affected only pages originating from the same sheet and did not communicate to other sheets! It is really hidden from the user.

There is another workaround for this, but i am running out of time now, will post another comment later.

When all else fails, there is a nifty utility called FinePrint (https://fineprint.com) that does the job very nicely. I've used it for years with several different programs and printers and it's been a lifesaver for me (not to mention a paper saver).

If you have to do it often then an easy solution for such situations is to buy a printer application such as "Fine Print" (www.fineprint.com). You print to Fine Print and it gives you a preview of what you want to print and then gives you the opportunity to manipulate it, such as print 2, 4 or 8 pages/worksheets on one page, repeat pages, add a letterhead, make a "booklet" and much more...

I use this program for many many years now and coun't do without it.