Dec 07 2018 07:41 AM
Quite frequently, I press F1 instead of F2.
How can I close the Excel Help Task Pane without my hands leaving the keyboard?
Thanks.
Dec 07 2018 08:53 AM - edited Dec 07 2018 08:56 AM
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
Oct 16 2019 01:04 PM
@jslabarge CTRL + spacebar + C should do it (I'm using Excel 2016)
Mar 08 2024 12:34 AM
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