Entering and Editing Data


Excel provides the following keyboard shortcuts for entering data in your worksheets and editing the existing entries in cells . To start entering data in a blank cell, simply select the cell and type the entry.

Shortcuts for Entering and Editing Data

Enter the entry in the cell and select the next cell

[Enter]

By default, when you press [Enter] , Excel selects the next cell below the active cell. You can change the direction of the next cell (up, down, left, or right), or turn off the movement, by using the Move Selection After Enter check box and Direction drop-down list on the Edit tab of the Options dialog box (Tools Options).

Cancel editing in the active cell

[Esc]

Canceling editing loses any changes you ve made to the cell s contents.

Enter the entry in the cell and select the next cell in the opposite direction

[Shift] - [Enter]

Press [Shift] - [Enter] to select the cell in the opposite direction from that specified in the Direction drop-down list on the Edit tab of the Options dialog box.

Enter the entry in the cell and select the next cell to the right

[Tab]

Enter the entry in the cell and select the next cell to the left

[Shift] - [Tab]

Fill the selected range with the entry

[Ctrl] - [Enter]

Select the range of cells you want to affect, type the entry, and press [Ctrl] - [Enter] to enter it in all the cells simultaneously .

Enter the time in the active cell

[Ctrl] - [Shift] - [:]

Enter the date in the active cell

[Ctrl] - [;]

Display the Define Name dialog box

[Ctrl] - [F3]

Use the Define Name dialog box (shown here) to add and delete range names .

click to expand

Display the Create Names dialog box

[Ctrl] - [Shift] - [F3]

Use the Create Names dialog box (shown here) to create names from row labels and column labels.

Display the AutoComplete drop-down list

[Alt] - [ ]

The AutoComplete drop-down list shows the entries in the column available for reuse.

Switch the active cell into Edit mode

[F2]

To edit the existing contents of a cell, select it and press [F2] . Excel places the insertion point at the end of the cell s existing contents.

Note

If the Edit Directly in Cell check box on the Edit tab of the Options dialog box is cleared, pressing [F ] activates the Formula bar instead.

Insert a new comment or edit the existing comment

[Shift] - [F2]

If the active cell has a comment attached to it, Excel opens the comment for editing. If the active cell has no comment, Excel creates a new comment.

Delete the contents of the active cell

[Backspace]

Pressing [Backspace] deletes the contents of the active cell when the cell is not in Edit mode.

Delete from the insertion point to the end of the cell s contents

[Ctrl] - [Delete]

Press [F2] to switch the cell to Edit mode, position the insertion point after the last character you want to keep, and then press this shortcut to delete the rest.

Begin a new line within the active cell

[Alt] - [Enter]

Use this shortcut when you need to break text to a new line within a cell.

Undo the most recent AutoCorrect

[Ctrl] - [Shift] - [Z]

This shortcut works only when Excel is displaying the AutoCorrect Smart Tag.

Excel 2000 Excel 2000 doesn t support Smart Tags, so it doesn t offer this shortcut.

Cycle object display, placeholder display, and hiding

[Ctrl] - [6]

Press [Ctrl] - [6] to cycle between displaying objects, displaying placeholders for objects, and hiding objects.




Windows XP and Office 2003 Keyboard Shortcuts
Windows XP and Office 2003 Keyboard Shortcuts
ISBN: 0072255005
EAN: 2147483647
Year: 2003
Pages: 117

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net