Article

Excel Keyboard Shortcuts

Excel keyboard shortcuts the senior uses every day - navigation selection formula entry formatting and the hidden shortcuts that save minutes per hour.

excel shortcuts
ctrl shift excel
excel hotkeys
excel productivity

Published August 22, 20263 min readBy Jigar Savani

Keyboard shortcuts are the single most under-trained skill in Excel. The senior who knows 50 shortcuts builds a dashboard in two days; the junior who knows 5 builds the same dashboard in two weeks. The 40 shortcuts below are the ones we teach on every engagement. The list is sorted by the four most common use cases: navigation, formula entry, formatting, and data manipulation.

Navigation (10 shortcuts)

Ctrl + ArrowJump to the edge of the data in any direction
Ctrl + Shift + ArrowSelect to the edge of the data
Ctrl + HomeJump to A1
Ctrl + EndJump to the last used cell
Ctrl + G or F5Open Go To dialog (named ranges, cells, special)
Ctrl + Page Up/DownSwitch between worksheets
Alt + Page Up/DownScroll left/right by one screen
Ctrl + FFind
Ctrl + HFind and Replace
Ctrl + TabSwitch between open workbooks

The ten navigation shortcuts that move you through a workbook in seconds.

Formulas (10 shortcuts)

F2Edit the active cell
F4Cycle reference types (A1 → $A$1 → A$1 → $A1)
Ctrl + `Toggle formula display across the workbook
Alt + =AutoSum the selected range
Ctrl + ;Insert today's date
Ctrl + Shift + :Insert the current time
Ctrl + Shift + EnterEnter as array formula (legacy Excel)
Ctrl + EnterEnter the same formula in all selected cells
=Start a formula in the active cell
Ctrl + Shift + UExpand/collapse the formula bar

The ten formula shortcuts that speed up every calculation.

Formatting (10 shortcuts)

Ctrl + 1Open Format Cells dialog
Ctrl + BBold
Ctrl + IItalic
Ctrl + UUnderline
Ctrl + Shift + $Currency format
Ctrl + Shift + %Percentage format
Ctrl + Shift + #Date format
Ctrl + Shift + @Time format
Ctrl + Shift + ~General format
Alt + H + O + IAuto-fit column width

The ten formatting shortcuts that replace the Format Cells dialog.

Data manipulation (10 shortcuts)

Ctrl + TConvert range to Table
Ctrl + Shift + LToggle AutoFilter on/off
Alt + A + S + SSort dialog
Alt + A + S + VSort left to right (by column)
Ctrl + Shift + +Insert cells/rows/columns
Ctrl + -Delete cells/rows/columns
Ctrl + DFill down (copy from cell above)
Ctrl + RFill right (copy from cell to the left)
Ctrl + Shift + LToggle AutoFilter
Alt + N + VInsert Pivot Table

The ten data manipulation shortcuts that replace the menu clicks.

How to learn them

Pick three shortcuts a week. Practice them on a real workbook for the week. Add three more the following week. The senior who knows 50 shortcuts built the muscle memory over six months, not six days. The shortcuts that pay back the fastest in the first week: Ctrl+1 (Format Cells), F4 (Reference cycle), Ctrl+T (Table), Ctrl+` (Show formulas), Ctrl+Arrow (Jump to edge). These five alone will save 30 minutes a day for any Excel user.

Free · 10 minutes · No obligation

Send us the workbook your CFO reads. We will tell you which checks fail.

We run the same seven mechanical checks on every workbook we audit. No judgement calls, no scope creep - just a written list of which numbers you should stop trusting and why. Free, in a written reply within a working day.

Hard-coded totals
Hidden rows in SUM ranges
Headline trace to source
Hard-coded assumptions
Correct data types
Reconciliation to source
Fresh refresh timestamp

Request the free audit Call for the audit How the audit worksReply within a working day

Want an answer right now? Run the free Workbook X-ray on your file. It checks it in your browser in seconds.

checks.xlsx

Auto-runs on refresh

01No hard-coded totalsPass
02Hidden rows in SUM rangesFail
03Headline traces to sourcePass
04No hard-coded assumptionsFail
05Correct data typesPass
06Reconciled to sourcePass
07Fresh refresh timestampPass

Checks tab · 7/7Runs on every refresh

Written by

Jigar Savani

Founder & Principal Consultant · FormulaSurge · 10+ years of hands-on Excel work

Senior Excel practitioner with 10+ years across Power Query, Power Pivot, VBA and financial modeling. The patterns on this page are the same ones I build into client workbooks - fixed scope, fixed price, named owner. Read the full author bio. Stuck on a formula? Get a free fix.

Free tool · 10 sec · runs in your browser

Formula Explainer

Paste any formula and read it in plain English, step by step in the order Excel calculates it.

Open the tool

Related service

Need this built for your team?

See Spreadsheet Audit & Repair - fixed price in writing, built end-to-end. Not sure of the scope? A Scoping Sprint ($99 / ₹4,999) gives you an exact quote first.

10+ years in ExcelNamed senior ownerNDA signedFixed price, in writing30-day support

Frequently asked

Questions readers ask most.

What are the most useful Excel keyboard shortcuts?

Fifty shortcuts. The top 10: Ctrl+1 (Format Cells), Ctrl+T (Table), Ctrl+Shift+L (Toggle Filters), Ctrl+` (Show Formulas), F2 (Edit Cell), F4 (Cycle Reference), Ctrl+Arrow (Jump to Edge), Ctrl+Shift+Arrow (Select to Edge), Alt+= (AutoSum), Ctrl+; (Today). The senior uses 30-50 of these in a normal day.

How do I navigate large spreadsheets quickly?

Ctrl+Arrow jumps to the edge of the data in any direction. Ctrl+Shift+Arrow selects to the edge. Ctrl+Home goes to A1. Ctrl+End goes to the last used cell. Ctrl+G or F5 opens Go To. The senior uses these to navigate a 100K-row dataset in seconds.

What is the shortcut to enter a formula in all selected cells?

Select the range, type the formula, press Ctrl+Enter. The formula is entered in every selected cell with relative references adjusted. The senior uses this pattern for filling a formula down a column or across a row without dragging the fill handle.

How do I quickly format a number as currency, percentage, or date?

Ctrl+Shift+$ (Currency), Ctrl+Shift+% (Percentage), Ctrl+Shift+# (Date). The senior uses these instead of right-click → Format Cells. The shortcuts are muscle memory after a week of use.

What is the shortcut to toggle formula display?

Ctrl+` (the backtick key, top-left of the keyboard, below Escape). The shortcut shows every formula in the workbook. Press again to toggle back. The senior uses this to audit a workbook for hard-coded numbers and buried assumptions.

How do I copy a formula with absolute references?

Type the formula, press F4 to cycle the reference types (A1 → $A$1 → A$1 → $A1 → A1). The senior locks the rows and columns that should not move when the formula is copied. The most common pattern is $A$1 (lock both) for the assumption cell and A1 (lock neither) for the row reference.

Get a Free Quote

Want this built for your team?

We deliver this kind of work for clients every week. Send your requirements, sample workbook or screenshot - we'll respond with a written scope and fixed price within one working day.

Written scope and fixed price before any build work starts
Live workbook reviews - you see progress from week one
Documented walkthrough and 30-day support at handover
Mutual NDA available

Replies within one working day, usually the same day

Call WhatsApp Email

Calls scheduled in your timezone (UK, EU, US, UAE, APAC) · How a project works

Built for teams in

Industries and cities this work is set up for

Industries

Cities

Self-Serve Diagnostics

Free Self-Serve Excel Tools

Interactive in-browser calculators and diagnostics. No sign-up, no email required.

View all 15 free tools

File Compare20 sec

Workbook Compare

Drop two versions of a file and see every changed cell and formula, inserted rows, and formulas someone typed over.

Launch tool free

Visual Map10 sec

Workbook Map

See how your sheets feed each other as a diagram, with links to other files, hidden feeders and circular links flagged.

Launch tool free

Explainer10 sec

Formula Explainer

Paste any formula and read it in plain English, step by step in the order Excel calculates it.

Launch tool free

Related Industries

See all

For Finance Teams

Excel for finance teams - build dashboards close faster models and pipelines the team you already have. 7 reports every CFO opens on Monday. From ₹6K fixed scope.

For Sales Operations

Excel for sales operations - pipeline coverage quota attainment and forecast accuracy in one Excel refresh. 5 KPIs the VP Sales opens every Monday. Senior-led fixed scope from ₹6K.

For Professional Services

Excel for professional services firms - utilisation project margins and WIP in one Excel place without buying a new platform. 5 KPIs the partner opens monthly. Senior-led fixed scope from ₹6K.

For E-commerce & D2C Brands

Excel for e-commerce and D2C brands - daily sales inventory and marketing attribution across Shopify and Amazon in one refresh. 6 KPIs the founder opens every Monday. Senior-led from ₹6K.

Article

10 Excel Functions Every Analyst Should Know

Master these ten functions and 80% of your daily analysis gets faster

Jul 5, 2026Read

Article

Pivot Tables: From Raw Data to Insights

Turn thousands of raw Excel rows into a clear answer in under five minutes

Jul 5, 2026Read

Article

Automate Monthly Reports with Excel Macros

Automate monthly Excel reports with Power Query and VBA - from recurring exports and refreshes to PDF delivery. See how to make the workflow reliable, then explore our fixed-scope automation service.

Oct 17, 2026Read

Article

Excel Charts That Tell a Story

Choose the right chart and your data explains itself

Jul 5, 2026Read

Article

Power Query: Stop Copy-Pasting From Your Inbox

Replace hours of manual copy-paste with one click - Power Query is the most underrated feature in Excel

Jul 6, 2026Read

Article

VLOOKUP vs XLOOKUP: 7 Differences + 4 Migration Steps (2026)

What is the difference between VLOOKUP and XLOOKUP? Side-by-side comparison with 7 concrete differences 4 migration steps 5 real examples and the one reason VLOOKUP is still useful. Updated 2026.

Excel Keyboard Shortcuts

Navigation (10 shortcuts)

Formulas (10 shortcuts)

Formatting (10 shortcuts)

Data manipulation (10 shortcuts)

How to learn them

Send us the workbook your CFO reads. We will tell you which checks fail.

Formula Explainer

Need this built for your team?

Questions readers ask most.

Want this built for your team?

Industries and cities this work is set up for

Free Self-Serve Excel Tools

Workbook Compare

Workbook Map

Formula Explainer

Related Industries

Keep reading

10 Excel Functions Every Analyst Should Know

Pivot Tables: From Raw Data to Insights

Automate Monthly Reports with Excel Macros

Excel Charts That Tell a Story

Power Query: Stop Copy-Pasting From Your Inbox

VLOOKUP vs XLOOKUP: 7 Differences + 4 Migration Steps (2026)

Conditional Formatting That Actually Highlights What Matters

Data Validation: Save Rules and Stop Bad Data at the Door

Dynamic Arrays: The Excel Feature You Didn't Know You Had

Designing a KPI Dashboard That People Actually Open

Excel for CFOs: 7 Reports Every Finance Team Actually Uses

SUMPRODUCT: 5 Jobs It Does Better Than SUMIFS (2026)

How to Audit a Spreadsheet in 10 Minutes (2026)

What-If Analysis in Excel: 3 Tools + 5 Examples (2026)

Excel File Too Slow? 7 Fixes Before You Buy a New Tool

Power Pivot for People Who Hate Power Pivot

Excel for CA Firms: 5 Automation Wins

Excel Dashboard for Manufacturing Plant India

Power Query Tutorial for Indian Finance Teams

Excel Month-End Close: How Indian SMEs Do It Faster

Hire a Remote Excel Consultant from India

Offshore Excel Freelancer: Fixed Price vs Hourly

How to Work with a Remote Excel Expert

Excel Consultant for Small Business (US UK AU)

Excel Financial Model Freelancer Remote

Excel SUMIFS: The Formula That Runs Finance

INDEX MATCH vs VLOOKUP

Excel LET and LAMBDA Functions

Excel Named Ranges Best Practices

Excel Tables Deep Dive

Excel IFS and SWITCH

Excel TEXTJOIN and CONCAT

Excel ABC Inventory Analysis

Excel RFM Customer Analysis

Excel Cohort Analysis for SaaS

Excel Sensitivity Analysis

Excel for Accountants

Excel for HR and Payroll

Excel for Sales Pipeline

Excel vs Google Sheets

Excel vs Power BI

Excel IRR NPV PMT

Excel Sparklines

Excel Combo Charts

Excel Waterfall Charts

Excel Pivot Charts

Excel Heatmap Conditional Formatting

Excel vs Python Pandas

Excel vs Tableau

Excel Solver for Operations Research

Excel Monte Carlo Simulation

Excel FORECAST.ETS

Excel Linear Regression

Excel for Project Management

Excel for Restaurant Operations

Excel for E-commerce Inventory

Excel Templates vs Workbooks

Excel VBA vs Power Query

Excel Protect Sheet

Excel Error Handling with IFERROR

Excel COPILOT Function Removed: Fix the #NAME? Errors

Excel REGEX Functions: REGEXTEST, REGEXEXTRACT, REGEXREPLACE