Excel Help Task Pane - Hotkey to close

Copper Contributor

Quite frequently, I press F1 instead of F2.

 

How can I close the Excel Help Task Pane without my hands leaving the keyboard?

 

Thanks.

5 Replies

Escape?

Hi,

 

The only effective way I found to do so is to use this macro:

Sub CloseHelpPane()
    Application.CommandBars("Help").Visible = False
End Sub

It's recommended to insert this macro into the Personal Macro Workbook.

 

Then add this macro to the Quick Access Toolbar so you can fire it using an Alt key shortcut.

 

Hope that helps

 

@jslabarge CTRL + spacebar + C should do it (I'm using Excel 2016)

thanks for this

Hi @jslabarge ,

 

I had the same problem and posted my solution here: Keyboard shortcuts for moving between application and Task Panes in - Microsoft Community

 

tl;dr CTRL+SPACE