Excel - Deactivate F1 Key For Excel Help - Episode 1213
1,378 views · Published 27 July 2010 · 2:21 · Indexed 10 November 2026
Channel: MrExcel.com · 2010 · Education
Microsoft Excel Tutorial: Deactivate F1 Key For Excel Help - Episode Welcome back to the MrExcel netcast! In this episode, we're tackling a common Excel frustration - accidentally pressing the F1 key instead of F2 and having the Excel help window pop up. But fear not, we have some solutions for you. This issue was first brought up in episode 1209, when a viewer asked if there was a way to make the F1 key automatically do what the F2 key does. We received some great responses from our viewers, and today we'll be sharing two of the most helpful ones. The first solution comes from Hamid, who pointed out a handy keyboard shortcut that can close the Excel help window - Alt + F4. Simply hold down the Alt key and press F4 to close the window. This is a quick and easy fix for those accidental F1 presses. The second solution was sent in by Revon, who shared a clever macro that can be used to make the F1 key act like the F2 key. This macro, which can be added to your personal macro workbook, will automatically switch the F1 key to the F2 key when pressed. This means that instead of opening the Excel help window, the F1 key will put the cell in edit mode. No more accidental help windows! We hope these solutions will help make your Excel experience smoother and more efficient. Thank you for tuning in to the MrExcel netcast, and we'll see you next time for more Excel tips and tricks. Don't forget to check out our sponsor, MrExcel.com, for even more Excel resources. Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Question about F1 and F2 (00:17) Accidentally pressing F1 instead of F2 pops up help (00:27) Solutions to automatically press F2 instead of F1 (00:37) First solution: Windows keyboard shortcut (00:47) Second solution: Macro (01:42) Personal macro workbook recommendation (02:04) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: disable f1 key for excel help stop f1 from opening excel help prevent f1 key shortcut in excel deactivate f1 key for excel help Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152901/ An answer to the question from Podcast 1209; how do you prevent the F1 key from opening Excel help. This episode shows two to assign the F1 key to Edit.
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920