SOLVED

Customize keyboard shortcuts - excel 2016 Microsoft

Copper Contributor

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

8 Replies
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.

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 

Hi Robert,

 

Ctrl+P and Enter could be some workaround

Hi 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.
I 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.
best response confirmed by Robert Sun (Copper Contributor)
Solution

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.

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

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

Accepted Solutions
best response confirmed by Robert Sun (Copper Contributor)
Solution

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.

View solution in original post