Shortcut Keys in Excel 365: Complete Guide

In this article, you will learn all essential shortcut keys in Excel 365. Boost productivity and save time with Microsoft Excel 365 shortcut keys.

Table of Contents:

📂 Workbook & File Shortcut Keys in Excel 365

Every Excel session starts with managing files. Whether you’re creating a new workbook, saving your work, or printing a report, these shortcuts make the process quick and effortless:

• Ctrl + N → Create a new workbook
• Ctrl + O → Open an existing workbook
• Ctrl + S → Save workbook
• F12 → Save As
• Ctrl + W or Ctrl + F4 → Close the current workbook
• Ctrl + P → Print
• Ctrl + F2 → Print Preview
• Alt + F4 → Exit Excel
• F9 → Recalculate workbook
• Shift + F9 → Recalculate active worksheet

🧭 Navigation Shortcut Keys in Excel 365

Moving through large spreadsheets can feel like navigating a maze. These shortcuts make it simple to jump to the right place in seconds:

• Ctrl + Page Down → Move to next sheet
• Ctrl + Page Up → Move to previous sheet
• Home → Go to beginning of row
• End → Go to end of row
• Ctrl + Home → Go to start of worksheet
• Ctrl + End → Go to end of worksheet
• Ctrl + G or F5 → Go to specific cell

🎨 Formatting Shortcut Keys in Excel 365

Neat formatting makes your data easier to read and interpret. Excel 365 shortcuts help you style data without wasting time on menus:

• Ctrl + B → Bold text
• Ctrl + I → Italic text
• Ctrl + U → Underline text
• Ctrl + 1 → Open Format Cells dialog
• Alt + H + AC → Center Align
• Alt + H + AL → Left Align
• Alt + H + AR → Right Align
• Ctrl + C → Copy
• Ctrl + V → Paste
• Ctrl + Z → Undo
• Alt + H + H → Fill Color

📈 Formula Shortcut Keys in Excel 365

Formulas are Excel’s superpower. These shortcuts help you create, edit, and manage formulas efficiently:

• = (Equal Sign) → Start a formula
• Alt + = → AutoSum numbers without typing the function
• Shift + F3 → Insert function
• F4 → Toggle absolute/relative reference ($)
• Ctrl + ` (Backtick or Grave Accent) → Show all formulas in your worksheet

📝 Data Shortcut Keys in Excel 365

Entering and editing data becomes a breeze with these shortcuts:

• F2 → Edit the selected cell
• Ctrl + D → Fill down from the cell above
• Ctrl + R → Fill right from the cell to the left
• Ctrl + Shift + L → Filter data
• Ctrl + Alt + F5 → Refresh data
• Ctrl + T → Insert Table
• Alt + A + SA → Sort ascending
• Alt + A + SD → Sort descending
• Alt + D + L → Data Validation
• Alt + Enter → Add a line break within a cell

📊 Row and Column Shortcut Keys in Excel 365

Manipulating rows and columns is faster with these essential shortcuts in Excel 365:

• Ctrl + Shift + + (Plus Sign) → Insert new row
• Ctrl + – (Minus Sign) → Delete row
• Ctrl + Shift + + (Plus Sign) → Insert new column
• Ctrl + – (Minus Sign) → Delete column
• Ctrl + Space → Select entire column
• Shift + Space → Select entire row
• Ctrl + Shift + Down Arrow / Up Arrow → Select multiple rows
• Ctrl + Shift + Right Arrow / Left Arrow → Select multiple columns
• Ctrl + 0 → Hide column
• Ctrl + 9 → Hide row
• Ctrl + Shift + 0 or Alt + H + O + U + L → Unhide columns
• Ctrl + Shift + 9 or Alt + H + O + U + O → Unhide rows
• Alt + Shift + Right Arrow → Group rows or columns
• Alt + Shift + Left Arrow → Ungroup rows or columns

🎛️ Ribbon Tabs Shortcut Keys in Excel 365

Accessing ribbon commands doesn’t require a mouse. Press Alt to activate key hints, then follow with the letters:

• Alt +Q → Search
• Alt + F → File tab
• Alt + H → Home tab
• Alt + N → Insert tab
• Alt + P → Page Layout tab
• Alt + M → Formulas tab
• Alt + A → Data tab
• Alt + R → Review tab
• Alt + W → View tab
• Alt + U → Automate tab
• Alt + L → Developer tab

⚡ Other Shortcut Keys in Excel 365

The other Excel 365 shortcut keys which are incredibly helpful:

• Esc → Cancel entry / exit cell editing
• F7 → Open spell check
• Alt + Enter → Insert line break in a cell
• Ctrl + F1 → Show/Hide Ribbon
• Ctrl + K → Add hyperlink
• Ctrl + ; → Insert current date
• Ctrl + Shift + ; → Insert current time
• Shift + F2 → Add comment
• Shift + F10 → Open right-click menu

⁉️ FAQs

What are Shortcut Keys in Excel 365?

In Excel 365, shortcut keys are special key combinations that help you do tasks faster, like copying, pasting, or moving around the spreadsheet. Excel 365 uses Ctrl, Alt, Shift and Function keys to streamline editing, formatting, and navigation etc.

Can I Use Shortcut Keys to Navigate Worksheets?

Yes, you can jump between cells, rows, columns, and even different sheets without using the mouse.

Can I Format Cells with Shortcut Keys?

Definitely! You can bold, italicize, underline, or apply number formats instantly using shortcuts.

Can Shortcuts Help with Formulas?

Yes, you can start formulas, sum ranges, and switch references between relative and absolute quickly.

Learn More