Forum Discussion
Printing on Excel
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)
Sergei, you're right re the print preview, the page does come up on the Print page. I was thinking of the 'print preview' which allows you to alter the page. With reference your copies of the print page I think the problem is that at the bottom of my screen it's only showing 'Page 1 of 1' so I don't know where the rest of the page has gone.
My Excel version shows as 16.0.12430.20264
Are you sure you have any data on second page to print and it's not empty?
Sergei, There is definitely further pages but I've tried to think back on what buttons I've pressed in my attempts to find the second page. One of those was 'Page Layout'>'Set Print Area' I've gone back and reversed it and the second page now appears on the Print preview so hopefully problem solved. I'm not a 'tech' person so perhaps shouldn't touch buttons I don't understand which is why I find Office not always easy to use and I'll probably go back to Libre when my subs run out. Anyway, I do appreciate your time and help with my queries, many thanks
