Free Excel Tips & Tricks

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

Monday, June 25, 2018

EXCEL SHORTCUT KEYS TO EDIT ACTIVE OR SELECTED CELLS

EXCEL SHORTCUT KEYS TO EDIT ACTIVE OR SELECTED CELLS

CTRL +D
Purpose:Use this excel shortcut key to Fill complete cell down (Copy above cell).

CTRL +R
Purpose:Use this excel shortcut key to Fill complete cell to the right (Copy cell from the left).

CTRL +"
Purpose:Use this excel shortcut key to Fill cell values down and edit (Copy above cell values).

CTRL +' (APOSTROPHE)
Purpose:Use this excel shortcut key to Fill cell formulas down and edit (Copy above cell formulas).

CTRL +L
Purpose:Use this excel shortcut key to Insert a table (display Create Table dialog box).

CTRL +-
Purpose:Use this excel shortcut key to Delete Cell/Row/Column Menu

CTRL +- WITH ROW / COLUMN SELECTED
Purpose:Use this excel shortcut key to Delete row / delete column.

CTRL +SHIFT + + WITH ROW / COLUMN SELECTED
Purpose:Use this excel shortcut key to Insert row/ insert column.

SHIFT +F2
Purpose:Use this excel shortcut key to Insert / Edit a cell comment.

SHIFT +F10 , THEN M
Purpose:Use this excel shortcut key to Delete comment from cells.

ALT +F1
Purpose:Use this excel shortcut key to Create and insert chart with data in current range as embedded Chart Object.

F11
Purpose:Use this excel shortcut key to Create and insert chart with data in current range in a separate Chart sheet.

CTRL +K
Purpose:Use this excel shortcut key to Insert a hyperlink to a cell.

ENTER (IN A CELL WITH A HYPERLINK)
Purpose:Use this excel shortcut key to Activate a hyperlink.

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...