Free Excel Tips & Tricks

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

Sunday, June 24, 2018

DATA SELECTION EXCEL SHORTCUT KEYS

DATA SELECTION EXCEL SHORTCUT KEYS

SHIFT +SPACE
Purpose:Use this excel shortcut key to Select the entire row.

CTRL +SPACE
Purpose:Use this excel shortcut key to Select the entire column.

CTRL +SHIFT +* (ASTERISK)
Purpose:Use this excel shortcut key to Select the current region around the active cell.

CTRL +A
Purpose:Use this excel shortcut key to Select the entire worksheet or the data-containing area. Pressing ctrl+a a second time then selects entire worksheet. Display Formula Window after typing formula name.

CTRL +SHIFT +PAGE UP
Purpose:Use this excel shortcut key to Select the current and previous sheet in a workbook.

CTRL +SHIFT +O
Purpose:Use this excel shortcut key to Select all cells with comments.

SHIFT +ARROW KEYS
Purpose:Use this excel shortcut key to Extend the selection by one cell.

CTRL +SHIFT +ARROW KEY
Purpose:Use this excel shortcut key to Extend the selection to the last cell with content in row or column.

SHIFT +PAGE DOWN /SHIFT +PAGE UP
Purpose:Use this excel shortcut key to Extend the selection down one screen /up one screen.

SHIFT +HOME
Purpose:Use this excel shortcut key to Extend the selection to the beginning of the row.

CTRL +SHIFT +HOME
Purpose:Use this excel shortcut key to Extend the selection to the beginning of the worksheet.

CTRL +SHIFT +END
Purpose:Use this excel shortcut key to Extend the selection to the last used cell on the worksheet (lower-right corner).

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