Formatting colums continued

  • Thread starter Thread starter SUE
  • Start date Start date
S

SUE

Thanks guys, for the formulas... they both work
great...except for one thing. I'm trying to cut down on
key strokes so I need to be able to just tab over to the
next column and have it automatically fill in. With the
formulas you gave me I still have to take the cursor up to
the cell above the one I want to fill in and drag it
down. I need the cell to automatically fill in the
correct info when I hit the tab button.

In other words... type "1" in cell A1, tab to B1,
and "cats" should automatically fill in, tab to C1 and
type, etc. The when I go to A2 and type in a "3", and tab
to B2, dogs should automatically appear so I can tab to C2.
 
Sue, the way to approach this is to set up your worksheet in advance.
Combining Michael's and RagDyer's formulas from the earlier thread, you can
enter a formula like this one in B1:

=IF(A1<>0,CHOOSE(A1,"cat","dog","rat","bat"),"")

Estimate how many rows you are likely to need for this worksheet and copy
the formula that far down. Do the same for Column D.

To cut down on keystrokes (and protect the formulas as well), you can
protect the worksheet. First select the cells to be left unprotected.
Assuming you will use, say, twenty rows, you would select A1:A20 and C1:C20,
then right-click them and Format Cells > Protection > uncheck Locked > OK.
Then protect the worksheet: Tools > Protection > Protect Sheet. How does
this save keystrokes? Note that when you select A1 and enter a value, you
can hit TAB and that will take you directly to C1, skipping B1 altogether
(and, of course, entering the formula in B1).
 
Back
Top