The information in this article applies to:
- Microsoft Excel for the Macintosh, versions 1.x, 2.2, 3.0, 4.0
SUMMARY
Microsoft Excel has no built-in key command that will allow you to
return to the start of the next row when entering data into a
Microsoft Excel worksheet (for example, a command that will allow you
to enter information in a spreadsheet and press the RETURN key at the
end of a row to go to the first cell in the next row without using the
ARROW keys). However, there are two ways to simulate this action.
To use the TAB key to move through a selection:
- Select the columns into which information will be entered.
- After each entry, press TAB to go to the next cell.
- When the last column is reached, press TAB to move the cursor to
the first cell in the next row of your selection.
To use a command macro to move to the first column in the next row:
- Enter the following information into a macro sheet.
A1: FirstColumn
A2: =SELECT(OFFSET(ACTIVE.CELL(),0,1))
A3: =RETURN()
- Select cell A1.
- From the Formula menu, choose Define Name.
- Under Macro, select Command.
- Enter a key in the OPTION+COMMAND Key box, to be used to run the
macro from the keyboard. For example, type an "a" (without
quotation marks) in the OPTION+COMMAND box.
- Choose the OK button.
- To move to the beginning of the next column when the end of a row
is reached, press RETURN to enter the value into the cell and then
press OPTION+COMMAND+key (for example, OPTION+COMMAND+A).
NOTE: Whenever the command macro is to be used, the macro sheet must
be open.
|