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
- Click File > Options.
- In the Options dialog box, select the Edit tab.
- In Settings, select Move to Next Cell After Pressing <ENTER>, and then select Right in Direction.
- Click Set.
- 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
- Show Recent Documents in File Menu
A list of recent files is displayed under the File menu so that you can open files quickly. Type the number of files to display in the edit box.
- Show Internet Temp Files in Recent File List
Specify whether to display documents from the temporary folder on the recent documents list or not.
If you do not select this option and type a number that is 1 or bigger in a cell in the percent format, the value of the number multiplied by 100 will be displayed with a percent symbol.
Settings
- Edit Directly from Cell
You can edit the content of a cell by double-clicking the cell. The formula bar is not the only option.
- Use Auto Percent
If you type a number smaller than 1 in a cell in the percent format, the value of the number multiplied by 100 will be displayed with a percent symbol.
If you do not select this option and type a number that is 1 or bigger in a cell in the percent format, the value of the number multiplied by 100 will be displayed with a percent symbol.
- Enable Drag and Place Cell
You can move and copy a cell and its data by dragging. If you select this option, you can copy data by dragging the fill handle and fill adjacent cells with a series of data.
- Warn Before Overwrite: Display a message when you place a cell on top of a cell with data.
- Move to Next Cell After Pressing <ENTER>
If you press ENTER in the current cell, an adjacent cell becomes the next active cell. In Direction, select an adjacent cell that will be the next active cell.
- Direction: If you press ENTER in the current cell, an adjacent cell becomes the next active cell. In the direction box, select an adjacent cell that will be the next active cell.
- Enable Cell AutoComplete
Automatically complete text when you type data in a column. If a first few characters you type match previously typed content, the rest of the text will be automatically entered.
- Use <ENTER> to Break Line in Merged Cell
Use the <Enter> key on the keyboard to break line in the merged cell.
See Also
Options, Options: Display, Options: Formula, Options: Custom List, Options: File, Options: Fonts, Options: Others