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:

Toggle Absolute / Relative Cell Reference ($A$1):

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.

Practice a formula shortcut on a small sample sheet

The reference primarily describes desktop Excel on Windows. Excel for Mac, Excel for the web, and Google Sheets differ in several commands. Browser shortcuts can also intercept keys in a web spreadsheet.

In a blank worksheet, enter 10, 20, and 30 in A1 through A3.
Select A4 and use Alt + = in Excel for Windows. Inspect the suggested range before accepting it.
The expected total is 60. If it differs, inspect the cells and formula rather than trusting the shortcut.
Use a separate sample formula to practice F4 while editing a cell reference. Observe the dollar signs as the reference changes.

Selection changes the result

Fill Down copies from the top cell of the selected range. Selecting only the destination, selecting the entire column, and selecting a short range can produce different outcomes. Practice on copied data first. AutoSum can select an unexpected range when blank cells divide your data.

F4 also has a different meaning outside formula editing. Laptop function-key settings may require Fn. A shortcut speeds up an action; it does not validate the underlying data or calculation.

Reference: Microsoft: Excel keyboard shortcuts.

Guidance revised 22 October 2026.