Excel Printing Problem
Thread Starter
Join Date: Apr 2010
Location: uk
Posts: 246
Likes: 0
Received 0 Likes
on
0 Posts
Excel Printing Problem
Under an old version of Excel (2007??) I used to be able to print A5 size. Since I installed Excel 2019 I have been unable to do this. I cannot find A5 as a printing option - in fact from what I remember of the old version there were many more options than in the current version.
Does anyone know of a way around this?
Does anyone know of a way around this?
Join Date: Nov 2015
Location: Mordor
Posts: 1,315
Likes: 0
Received 0 Likes
on
0 Posts
The printer options offered (paper size, colours, staples, double sided etc) are determined by the currently selected printer. If your selected printer doesn't offer A5 printing it won't be in the list. What printer do you have selected at the moment?
PDR
PDR
Thread Starter
Join Date: Apr 2010
Location: uk
Posts: 246
Likes: 0
Received 0 Likes
on
0 Posts
I am using an Epson XP-900 which has A5 paper in it and the setting is confirmed as A5.
What I cannot do, which I could on the old version of Excel, is select the print area as A5. Under "Page Layout" I used to be able to select A5 and it would outline the pages with dotted lines. I can highlight what I want to print, and it does show the dotted lines even though A5 is not an option under "Page Layout - Size".
When I print this selection it misses out most of Column A.
What I cannot do, which I could on the old version of Excel, is select the print area as A5. Under "Page Layout" I used to be able to select A5 and it would outline the pages with dotted lines. I can highlight what I want to print, and it does show the dotted lines even though A5 is not an option under "Page Layout - Size".
When I print this selection it misses out most of Column A.
I just had a look at my Excel version, but the only place I can select a paper size is in the Print dialog, and this is linked to the printer driver as PDR1 already mentioned. The dialogs for Page Setup and Set Print Area and such are from Excel, the Print dialog is mostly dependant on the printer driver.
One thing that may have happened, apart from your switch to a newer Excel version, is a Windows update. Did you perhaps also change the Windows environment to a newer version? Even though the printer may be the same, a change to another Windows version may have driven a change to another printer driver in the background.
Can you select A5 paper when you print from a native Windows application? You could try opening your browser (use Internet Explorer or Edge) and printing a page from that.
One thing that may have happened, apart from your switch to a newer Excel version, is a Windows update. Did you perhaps also change the Windows environment to a newer version? Even though the printer may be the same, a change to another Windows version may have driven a change to another printer driver in the background.
Can you select A5 paper when you print from a native Windows application? You could try opening your browser (use Internet Explorer or Edge) and printing a page from that.
Join Date: Jun 2001
Location: Wherever someone will pay me to do fun stuff
Posts: 1
Likes: 0
Received 0 Likes
on
0 Posts
Under an old version of Excel (2007??) I used to be able to print A5 size. Since I installed Excel 2019 I have been unable to do this. I cannot find A5 as a printing option - in fact from what I remember of the old version there were many more options than in the current version.
Does anyone know of a way around this?
Does anyone know of a way around this?
Are you using Office 365 - iI have no experience of it and it may be different?
Administrator
Not having Office 2019 (just Office 2016) I can't reproduce your problem. My Excel 2016 and 2010 both allow me to select A5 paper size (with any of several printer drivers), plus a very large selection besides.
I wonder if you have got a combination of scaling and margins set that prevents A5 being presented as a legitimate / possible size in Excel.
Can you select A5 with a different printer driver - e.g. CutePDF?
I wonder if you have got a combination of scaling and margins set that prevents A5 being presented as a legitimate / possible size in Excel.
Can you select A5 with a different printer driver - e.g. CutePDF?
Thread Starter
Join Date: Apr 2010
Location: uk
Posts: 246
Likes: 0
Received 0 Likes
on
0 Posts
I am not using Office 365 - but Excel 2019 from Office.
The dialogues you describe are what I was familiar with on my old version of Excel. The current one shows only Letter, A4, 4" x 6", 3.5" x 5" and Postcard.
I will try CutePDF tomorrow.
Thank you for the answers and suggestions.
The dialogues you describe are what I was familiar with on my old version of Excel. The current one shows only Letter, A4, 4" x 6", 3.5" x 5" and Postcard.
I will try CutePDF tomorrow.
Thank you for the answers and suggestions.
Join Date: Nov 2015
Location: Mordor
Posts: 1,315
Likes: 0
Received 0 Likes
on
0 Posts
Join Date: Jun 2009
Location: Bedford, UK
Age: 70
Posts: 1,328
Likes: 0
Received 0 Likes
on
0 Posts
Sounds odd. I have 2019 so just went to look. Under the 'size' tab it offers A5.
Edit: if you change your default printer to one of the soft print options, does that change anything?
Edit: if you change your default printer to one of the soft print options, does that change anything?
Thread Starter
Join Date: Apr 2010
Location: uk
Posts: 246
Likes: 0
Received 0 Likes
on
0 Posts
OK here are some answers to the questions.
It is exactly the same in Excel and Word - I haven't used Powerpoint in this version.
CutePDF initially offers A5 as an option, but it disappears when I actually try to print.
Mr Optimistic - what do you mean by soft print options? If you mean the other options below my default printer, such as "Microsoft Print to PDF", then the answer is No none of them have A5 as an option.
It is exactly the same in Excel and Word - I haven't used Powerpoint in this version.
CutePDF initially offers A5 as an option, but it disappears when I actually try to print.
Mr Optimistic - what do you mean by soft print options? If you mean the other options below my default printer, such as "Microsoft Print to PDF", then the answer is No none of them have A5 as an option.
Join Date: Jun 2009
Location: Bedford, UK
Age: 70
Posts: 1,328
Likes: 0
Received 0 Likes
on
0 Posts
Yep, that is what I wondered. Uninstall and reinstall the printer perhaps? A5 was an option here on print to PDF. If you look at printer properties in word does everything look ok? You haven't got fit to A4 or something set ?
I use Office 365 and have the ability to select A5 on my printer at home too. How many printers have you actually got installed (see Settings>Devices>printers & scanners)? The reason I ask is that I found this on a Microsoft forum
I guess another thing to check is which driver are you actually using, the OEM driver or Microsoft's own generic driver, better to use the OEM driver if you have it IMHO.
I guess another thing to check is which driver are you actually using, the OEM driver or Microsoft's own generic driver, better to use the OEM driver if you have it IMHO.
Last edited by golfbananajam; 24th Apr 2020 at 15:34. Reason: added last sentence
Thread Starter
Join Date: Apr 2010
Location: uk
Posts: 246
Likes: 0
Received 0 Likes
on
0 Posts
The problem seems to have gone away, but I am not exactly sure how! I deleted the printer using "Remove Device" under Settings. I was then able to select A5 in Excel.
I went back to Settings and the printer was still there. Maybe it was there twice with only one showing?? Anyway it is now happily printing A5.
Thank you for all the suggestions.
I went back to Settings and the printer was still there. Maybe it was there twice with only one showing?? Anyway it is now happily printing A5.
Thank you for all the suggestions.
To save me opening a new thread:
I have an Excel worksheet for personal banking. The copy of Excel I use has been going for ten years. For some reason it will not now go past £9999.99. When I calculate to a sum more than that it comes up with #####. It used to calculate with five figures so why not now?
I have an Excel worksheet for personal banking. The copy of Excel I use has been going for ten years. For some reason it will not now go past £9999.99. When I calculate to a sum more than that it comes up with #####. It used to calculate with five figures so why not now?
