Microsoft KB Archive/24729: Difference between revisions

From BetaArchive Wiki
(importing KB archive)
 
m (Text replacement - """ to """)
 
Line 42: Line 42:
# From the Formula menu, choose Define Name.
# From the Formula menu, choose Define Name.
# Under Macro, select Command.
# 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.
# 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.
# 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).
# 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).

Latest revision as of 12:51, 21 July 2020

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.