Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Easily Entering Dispersed Data.
I needed to enter information into many rows of widely dispersed columns, like A, Q, BD, BJ, CF, etc. (I'm sure you get the idea.) I was right-arrowing along and I was thinking: if I were in Word I'd just set some tabs or bookmarks to move around quickly. What is the equivalent in Excel? A little delving into the Help files let me know that it's done like this:
Figure 1. The Protection tab of the Format Cells dialog box.
Figure 2. The Protect Sheet dialog box.
That's it! Excel will only let you go to cells that are still editable, and those are the ones for which you cleared the Lock property before you protected the sheet. Enjoy tabbing to the places on your worksheet that you need to.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3027) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Easily Entering Dispersed Data.
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!
Need to make sure that information entered in a worksheet is always in a given unit of measurement? It's not as easy of a ...
Discover MoreEnter information into a cell, and Excel needs to figure out what type of information it is. Here's how Excel interprets ...
Discover MoreWhen editing worksheets, it is important to know how to add rows and columns. Excel provides a couple of quick ways you can ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2014-02-11 11:34:31
Michael (Micky) Avidan
It is far more important to understand that no one needs to repeat steps 2 through 6 for each column - especially when many columns are involved.
Step 2 should read:
MULTI Highlight/Select the columnS involved.
In order to Select multiple columns - one should hold the CTRL key while clicking on the Columns letter.
Michael (Micky) Avidan
“Microsoft® Answers" - Wiki author & Forums Moderator
“Microsoft®” MVP – Excel (2009-2014)
ISRAEL
2014-02-10 14:42:36
Kelly Runyon
This is really picky of me, but I think you should say "select" rather than "highlight" in step 2 above.
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.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2017 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: 
Comments