Forum Discussion
Robert Sun
Mar 22, 2018Copper Contributor
Customize keyboard shortcuts - excel 2016 Microsoft
Hi Guys,
Tearing my hair out - how can i customize my keyboard shortcuts in Excel 2016 - microsoft version,
so i can quick print by using the usual ctl+p keyboard shortcut ??!
- Mar 22, 2018
Robert, to my knowledge keyboard shortcuts are not customisable in Excel, the only is to add icon to Quick Access toolbar and use Alt+number on that icon.
Jamil
Mar 22, 2018Bronze Contributor
The default keyboard shortcut for Excel is Control +p
and when you press it, it should pop the interface for print. if it does not do that then you may need to examine your Application whether any other macro or add-in is not using that keystroke.
and when you press it, it should pop the interface for print. if it does not do that then you may need to examine your Application whether any other macro or add-in is not using that keystroke.
- Robert SunMar 22, 2018Copper Contributor
hi jamil,
I may have not explained my problem good enough.
When i click ctl+p, it opens print + preview but i rather have it quick print, like in the old version in excel.
You see, when i have many sheets that need printing, not having quick print, makes printing them a very tiresome exercise
- JamilMar 22, 2018Bronze ContributorI know this might not be exact solution, but I personally use the Quickprint and I added the Quick-print into my quick access tool bar in excel which prints without showing the preview.
- SergeiBaklanMar 22, 2018Diamond Contributor
Hi Robert,
Ctrl+P and Enter could be some workaround
- Robert SunMar 22, 2018Copper ContributorHi Sergei,
Clearly this makes me able to print without the use of the mouse but i'm looking for a solution similar to the way I'm able to customize keyboard shortcuts in microsoft word, via options, customize ribbon and then customize keyboard.