Microsoft Excel & Google Sheets Shortcuts Guide (2026)

Q: What is the keyboard shortcut for AutoSum in Excel?

Press Alt + = in Excel to automatically insert a =SUM() formula.

Q: How do I lock a formula cell reference with dollar signs ($A$1)?

Highlight the reference inside the formula and press F4 to cycle through absolute cell reference modes.

Q: How do I insert a new row or column in Excel using keys?

Select the row or column and press Ctrl + Shift + Plus (+).

Why Excel Shortcuts Are Essential for Financial & Data Professionals

In financial modeling, data analysis, and accounting, using the mouse reduces speed and causes errors. Mastering keyboard navigation in Microsoft Excel 365 and Google Sheets allows you to jump across 100,000+ data rows instantly (Ctrl + Arrow Keys), auto-sum numeric columns (Alt + =), and toggle absolute cell references (F4) without leaving your home row.

Below is our complete categorized reference guide for Windows and macOS users.

Cell & Range Selection Shortcuts

Select Entire Column:
Ctrl + Space
Select Entire Row:
Shift + Space
Select Entire Data Region / Spreadsheet:
Ctrl + A
Jump to Edge of Data Block:
Ctrl + Arrow Keys
Select Data Range to Edge of Block:
Ctrl + Shift + Arrow Keys
Jump back to Cell A1:
Ctrl + Home

Formula Building & Cell Editing Shortcuts

Edit Active Cell:
F2
Toggle Absolute / Relative Cell Reference ($A$1):
F4
Insert AutoSum Formula (=SUM):
Alt + =
Fill Down from Cell Above:
Ctrl + D
Trigger Flash Fill (Auto-Detect Patterns):
Ctrl + E
Insert Static Current Date:
Ctrl + ;

Formatting & Row / Column Controls

Format Cells Dialog Window:
Ctrl + 1
Format as Currency ($#,##0.00):
Ctrl + Shift + $
Format as Percentage (0.00%):
Ctrl + Shift + %
Insert Selected Row / Column:
Ctrl + Shift + +
Delete Selected Row / Column:
Ctrl + -

Frequently Asked Questions (FAQs)

What is the keyboard shortcut for AutoSum in Excel?

Press Alt + = in Windows (or ⌘ + Shift + T in Google Sheets) to instantly insert an automatic =SUM() formula for the adjacent cell range.

How do I lock a formula cell reference with dollar signs ($A$1)?

Select the cell reference inside your formula bar and press F4. Pressing F4 repeatedly cycles through absolute ($A$1), row lock (A$1), column lock ($A1), and relative (A1).

How do I insert a new row or column in Excel using keys?

First select an entire row with Shift + Space (or column with Ctrl + Space), then press Ctrl + Shift + Plus (+) to insert a new row or column.

Why Excel Shortcuts Are Essential for Financial & Data Professionals

Cell & Range Selection Shortcuts

Formula Building & Cell Editing Shortcuts

Formatting & Row / Column Controls

Frequently Asked Questions (FAQs)

Explore Related Guides & Tools