Customize keyboard shortcuts - excel 2016 Microsoft

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

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.