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.
Haytham Amairah
Mar 22, 2018Silver Contributor
Hello Robert,
The only solution is to use some lines of code as below:
Sub QuickPrintByUsingCtrl_P() ' Keyboard Shortcut: Ctrl+P On Error GoTo QPrint If ActiveSheet.Range(ActiveSheet.UsedRange.Address).Value = "" Then MsgBox "We didn't find anything to print!", vbExclamation Else ActiveWindow.SelectedSheets.PrintOut _ Copies:=1, _ Collate:=True, _ IgnorePrintAreas:=False End If Exit Sub QPrint: ActiveWindow.SelectedSheets.PrintOut _ Copies:=1, _ Collate:=True, _ IgnorePrintAreas:=False End Sub
But you have to copy the above code, save it in the Personal Macro Workbook, and then assign Ctrl+P keyboard shortcut to it.
I hope that helps
Haytham
Robert Sun
Mar 22, 2018Copper Contributor
wow - this is definitely beyond my capabilities but thanks for the effort.
Maybe it can work for others.
Maybe it can work for others.