Microsoft KB Archive/24729

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 12:51, 21 July 2020 by X010 (talk | contribs) (Text replacement - """ to """)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Excel: Returning to the First Column of the Next Row



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:


  1. Select the columns into which information will be entered.
  2. After each entry, press TAB to go to the next cell.
  3. 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:


  1. Enter the following information into a macro sheet.


A1: FirstColumn
A2: =SELECT(OFFSET(ACTIVE.CELL(),0,1))
A3: =RETURN()

  1. Select cell A1.
  2. From the Formula menu, choose Define Name.
  3. Under Macro, select Command.
  4. 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.
  5. Choose the OK button.
  6. 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.

Additional query words:

Keywords :
Version :
Platform :
Issue type :
Technology :


Last Reviewed: March 11, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.