Free Excel Tips & Tricks

Subscribe to Get Daily Excel Tips & Tricks to your Inbox for Free!

Friday, July 27, 2018

EDITING CELLS USING EXCEL SHORTCUT KEYS

EDITING CELLS USING EXCEL SHORTCUT KEYS

F2
Purpose:Use this excel shortcut key to Edit the active cell with cursor at end of the line.

ALT +ENTER
Purpose:Use this excel shortcut key to Start a new line in the same cell.

ENTER
Purpose:Use this excel shortcut key to Complete a cell entry and move down in the selection. With multiple cells selected: fill cell range with current cell.

SHIFT +ENTER
Purpose:Use this excel shortcut key to Complete a cell entry and move up in the selection.

ESC
Purpose:Use this excel shortcut key to Cancel a cell entry.

BACKSPACE
Purpose:Use this excel shortcut key to Delete the character to the left of the insertion point, or delete the selection.

DELETE
Purpose:Use this excel shortcut key to Delete the character to the right of the insertion point, or delete the selection.

CTRL +DELETE
Purpose:Use this excel shortcut key to Delete text to the end of the line.

CTRL +; (SEMICOLON)
Purpose:Use this excel shortcut key to Insert current date.

CTRL +SHIFT +: (COLON)
Purpose:Use this excel shortcut key to Insert current time.

CTRL +T
Purpose:Use this excel shortcut key to Show all content as standard numbers. (So 14:15 becomes 14.25 etc for the entire file) To undo press ctrl + t again

No comments:

Post a Comment

EDITING CELLS USING EXCEL SHORTCUT KEYS

F2 Purpose: Use this excel shortcut key to Edit the active cell with cursor at end of the line. ALT +ENTER Purpose: Use this exc...