Options: Edit

In the Edit tab of the Options dialog box, you can set items related to editing in a worksheet.

Steps

To set the editing environment

  1. Click File > Options.
  2. In the Options dialog box, select the Edit tab.
  3. In Settings, select Move to Next Cell After Pressing <ENTER>, and then select Right in Direction.
  4. Click Set.
  5. Press ENTER in A1. You will move to B1 on the right of A1, instead of A2 under A1.

More Information

Edit Tab of Options Dialog Box

Set worksheet edit options. The options selected in the Edit tab will apply to all worksheets of the workbook.

Recent Document

Settings

See Also