Competitive exams

📌 Useful Excel Shortcuts

Basic Navigation

Arrow Keys – Move one cell up/down/left/right

Ctrl + Arrow Keys – Jump to the last filled cell in that direction

Home – Go to beginning of the row

Ctrl + Home – Go to cell A1

Selecting Data

Shift + Arrow Keys – Select cells

Ctrl + Shift + Arrow Keys – Select entire data range

Ctrl + A – Select the whole worksheet

Editing

F2 – Edit the active cell

Ctrl + C / Ctrl + X / Ctrl + V – Copy / Cut / Paste

Ctrl + Z / Ctrl + Y – Undo / Redo

Ctrl + D – Fill down

Ctrl + R – Fill right

Formatting

Ctrl + B / I / U – Bold / Italic / Underline

Ctrl + 1 – Format cells dialog

Alt + H + O + I – Auto-fit column width

Working with Sheets

Ctrl + N – New workbook

Ctrl + S – Save

Ctrl + P – Print

Ctrl + Page Up/Page Down – Switch worksheets

Formulas

= – Start formula

Alt + = – AutoSum

Ctrl + ` (grave accent) – Show formulas