Forum Discussion
Prugone
Feb 17, 2020Copper Contributor
Printing on Excel
I'm working on an Excel spreadsheet which runs to two sheets however when I try and print the sheets only the first one comes out. At the bottom of the page I've tried hitting 'Sheet 2' but that's blank. How do I get both printed? I moved back to Office late last year when I bought a new laptop having switched to Office Libre some years ago when Windows started annual charging. I miss the old Office for it's ease of use and I have to say I've found this version of Office over complicated and difficult to use. For example for a print preview I have to hit several buttons to find it and it's not in a natural place!
7 Replies
Sort By
Print Preview is only in two clicks File->Print, or one shortcut Ctrl+F2. Here you may select from drop-down menu what to print - current sheet (or sheets of you selected few) or entire workbook.
- PrugoneCopper Contributor
Sergei, many thanks for taking the time to reply, I'm afraid I've tried 'File'>'Print' and there is no option to select 'Print preview'. The only way I've found it is 'Page Layout'>'Margins'>'Custom Margins'>'Print preview' and that's a lot of faffing about for a simple command. As for my query re printing, again I've tried the options you suggest without success. When I come to print the page the view of the page only says one sheet? When I typed the page I carried on down onto what should have been a second sheet but it's not coming up on the print options
On which version of Excel you are?
On more or less modern with File->Print you are on print preview page. By default it show active sheet (one page from one)
If I select Entire workbook, it'll be two pages to print (I have 2 sheets in the workbook)