skipping over certain cells in Excel 97
skipping over certain cells in Excel 97
(OP)
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
RE: skipping over certain cells in Excel 97
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.
Once you have them all selected, go to Insert - Name - Define. Make up a name for this area.
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.
Tom Thaden
thadents@usano.ksc.nasa.gov
RE: skipping over certain cells in Excel 97
Al