by Allen Wyatt
(last updated April 2, 2016)
Dave admits he is an inaccurate typist, and he often hits the Insert key when he doesn't mean to. He wonders if there is a way to disable the Insert key in Excel, short of using a screwdriver to pry it off.
There are a number of things you could try. If you don't need to use the Insert key in any program (not just Excel), you can disable the Insert key in Windows by editing the Registry. This page indicates how you can accomplish the task:
Another option, without the necessity of modifying the Registry, is to use a third-party program to change how each key on your system behaves. Here is a candidate you can check out:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (5599) applies to Microsoft Excel 97, 2000, 2002, and 2003.
Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!
Tired of shared workbooks opening at some strange zoom factor that makes viewing your data difficult? Here's how to make ...Discover More
Working on a computer system that has multiple monitors can help increase your productivity. If you want to work with ...Discover More
Dialog boxes are designed to be limited in scope, so that they cover only a portion of your screen. What if a dialog box ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.