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 ??!

Excel 2016

SergeiBaklan
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

Silver Contributor

Mar 22, 2018

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

Copper Contributor

Mar 22, 2018

wow - this is definitely beyond my capabilities but thanks for the effort.
Maybe it can work for others.

Forum Discussion

Customize keyboard shortcuts - excel 2016 Microsoft

Share

Resources