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.
Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!
Need a quick memory jog when entering a worksheet function? Here's a shortcut that will be invaluable.
Discover MoreDo you need to concatenate the contents of a range of cells in the same column? Here's a formula and a handy macro to ...
Discover MoreTired of the Find and Replace dialog box blocking the view of your worksheet when you are searching for information? Do ...
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 © 2020 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