- Select whole column
CTRL + SPACE
- Select whole row
SHIFT + SPACE
- Select table
SHIFT + CTRL + SPACE bar
- Save
CTRL + s
- Select visible cells only
ALT + ;
- Select entire region
CTRL + A
- Select range from start cell to far left
SHIFT + Home
- Select range from start cell to end in direction of arrow
SHIFT + End + arrow
- Select a continuous range of data (e.g. pivot), no matter where your cursor is.
CTRL + *
- Select blank cells
F5 + ALT + S + K + ENTER
- Select all cells with comments
CTRL + SHIFT + O
- Select all cells that are directly or indirectly referred to by formulas in the selection
CTRL + SHIFT + {
- Select all cells with formulas that refer directly or indirectly to the active cell
CTRL + SHIFT + }
- Selects all the way to a1 from cursor position
CTRL + SHIFT + HOME
- Select cells in the direction of arrow
CTRL + SHIFT + Arrow
- Previous sheet
CTRL + Page Up
- Next sheet
CTRL + Page Down
- Launch GO TO Dialog (from here you can select special or jump to a cell or range)
F5
- Go to top left (will go to top left of freezed pane if set)
CTRL + Home
- Go to last non-blank cell
CTRL + end
- Go to previous sheet
CTRL + PgUp
- Go to next sheet
CTRL + PgDn
CTRL + p
- Toggle between workbooks in a given session of excel.
CTRL + TAB
- Change the type of cell reference from relative to absolute or semi-absolute
F4
- Repeat whatever you did last
F4
- Debug portions of a formula (select and press)
F9
- Sum range
ALT + =
- Enter array formula
CTRL + SHIFT + Enter
- Select array formula range
CTRL + /
- Display range names (can be used when typing formulas)
F3
- Evaluate formulas. (its easy to remember when working with some “tuf” formulas!)
ALT + TUF
- Copy a formula from above cell and edit
CTRL + '
- Display the formula palette after you type a valid function name in a formula
CTRL + A (while writing a formula)
- Alternate between displaying cell values and displaying cell formulas
CTRL + ` (Single Left Quotation Mark)
- Calculate formulas
F9
- Select all precedent cells
CTRL + [
- Select all dependent cells
CTRL + ]
- Format Selection (cells, objects, charts)
CTRL + 1
- Bold a cell’s content
CTRL + B
Shift + Space– Select the entire row.
CTRL + Space– Select the entire column.
CTRL + Shift + * (asterisk)– Select the current region around the active cell.
CTRL + A (or CTRL + Shift + spacebar)– Select the entire worksheet or the data-containing area. Press CTRL + A twice to select entire worksheet.
CTRL + Shift + Page Up – Select the current and previous sheet in a workbook.
CTRL + Shift + O– Select all cells with comments
Shift + Arrow Keys– Extend the selection by one cell.
CTRL + Shift + Arrow Key- Extend the selection to the last cell with content in row or column.
Shift + Page Down- Extend the selection one screen down.
Shift + Page Up- Extend the selection one screen up.
Shift + Home- Select to the beginning of the row.
CTRL + Shift + Home- Select to the beginning of the worksheet
CTRL + Shift + End- Select till the last used cell on the worksheet (lower-right corner).