I am using Excel 97 as crude drawing tool for telephone rack and card layout. I want all unused / blank cells located in various rows and column areas to be "merged" in a blank white area and so when I use the "tab" key it only goes to the unprotected editable cells but not in any other blank areas/cells
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
skipping over certain cells in Excel 97
- Thread starter Zaborny
- Start date
Sounds like the areas you want to edit are non-contiguous. To select non-contiguous areas:<br>
<br>
Drag through the first block to highlight the area. Then hold down your Control key and highlight another area. Keep using the Control key to highlight as many areas as you want.<br>
<br>
Once you have them all selected, go to Insert - Name - Define. Make up a name for this area.<br>
<br>
Now whenever you want to do editing in these non-contiguous blocks, do a Ctrl-G (Go to) and choose the name you defined. Excel will once again highlight these blocks and tabbing will stay within these blocks... it will not go outside them. <p>Tom Thaden<br><a href=mailto:thadents@usano.ksc.nasa.gov>thadents@usano.ksc.nasa.gov</a><br><a href= > </a><br>
<br>
Drag through the first block to highlight the area. Then hold down your Control key and highlight another area. Keep using the Control key to highlight as many areas as you want.<br>
<br>
Once you have them all selected, go to Insert - Name - Define. Make up a name for this area.<br>
<br>
Now whenever you want to do editing in these non-contiguous blocks, do a Ctrl-G (Go to) and choose the name you defined. Excel will once again highlight these blocks and tabbing will stay within these blocks... it will not go outside them. <p>Tom Thaden<br><a href=mailto:thadents@usano.ksc.nasa.gov>thadents@usano.ksc.nasa.gov</a><br><a href= > </a><br>
- Status
Similar threads
