⏱️ How many hours do you waste every week clicking through menus in Word and Excel? If the answer is “too many,” this guide is for you.
Professionals save up to 8 hours per week just by using keyboard shortcuts. You don’t need to be an expert—you just need the right shortcuts.
In this complete guide, you’ll find the most useful keyboard shortcuts for Microsoft Word and Microsoft Excel—organized by category, with simple explanations and real-world examples.
📌 Works on Windows — Mac users can replace Ctrl with ⌘ Command.
Open, Save and Print Files
Let’s start with the basics—these are the shortcuts you’ll use every single day:
Ctrl + N
Create a new blank document
Ctrl + O
Open an existing file
Ctrl + S
Save your document (make it a habit!)
F12
Save As (new name or location)
Ctrl + P
Print your document
Ctrl + W
Close the current document
💡 Pro tip: Press Ctrl + S every few minutes while working. It can save you from losing hours of work if something goes wrong.
Text Formatting
Want to make text bold or change its size? Simply select the text first, then press:
Ctrl + Shift + >
Increase font size
Ctrl + Shift + <
Decrease font size
Shift + F3
Toggle uppercase / lowercase
Text Alignment
Want to center your text or justify it neatly? Just press:
Ctrl + J
Justify text (full width)
Search, Replace & Navigation
Working on a long document and need to find something quickly? These shortcuts will save you time:
Ctrl + F
Find a word or phrase
Ctrl + H
Find and replace text
Ctrl + G
Go to a specific page
Ctrl + Home
Go to the beginning of the document
Ctrl + End
Go to the end of the document
Ctrl + Enter
Insert a page break (new page)
💡 Example: Typed a word wrong 20 times? Press Ctrl + H, enter the wrong word and the correct one, and fix everything in seconds!
Copy, Paste and Undo
Ctrl + C
Copy selected text
Ctrl + X
Cut selected text
Ctrl + Alt + V
Paste special (text only, no formatting)
Ctrl + Z
Undo last action
Ctrl + Y
Redo undone action
💡 Golden tip: When copying text from the internet into Word, use Ctrl + Alt + V to paste only the text—no weird fonts or formatting!
Basic Actions
Ctrl + N
Create a new Excel file
Ctrl + T
Convert data into a formatted table
F2
Edit the selected cell
Esc
Cancel changes in a cell
Delete
Clear cell content
Navigation and Selection
Working with thousands of rows? These shortcuts help you move instantly:
Ctrl + Arrow Keys
Jump to the last cell with data (any direction)
Ctrl + Shift + Arrow Keys
Select an entire data range
Ctrl + Space
Select entire column
Shift + Space
Select entire row
Ctrl + A
Select entire worksheet
F5
Go to a specific cell (e.g. B500)
Formulas and Calculations
Excel is powerful for calculations—here’s how to use it faster:
=
Start any formula in Excel
Alt + =
AutoSum selected cells
Ctrl + `
Show or hide formulas
F9
Recalculate all formulas
Shift + F3
Open function insert dialog
Ctrl + Shift + Enter
Enter array formula (advanced)
💡 Example: Select a column of numbers and press Alt + =. Excel instantly calculates the total—no typing needed!
Managing Sheets and Cells
Ctrl + +
Insert rows or columns
Ctrl + -
Delete rows or columns
Shift + F11
Insert a new worksheet
Ctrl + PageDown
Go to next sheet
Ctrl + PageUp
Go to previous sheet
Ctrl + D
Fill down (copy content downward)
Ctrl + R
Fill right (copy content to the right)
Ctrl + 0
Hide selected column
Ctrl + 9
Hide selected row
Alt + H + O + I
Auto-fit column width
Formatting Data
Want to display numbers as currency or percentages? Select your cells and press:
Ctrl + 1
Open Format Cells window
Ctrl + Shift + $
Format as currency (€/$)
Ctrl + Shift + %
Format as percentage (%)
Ctrl + Shift + #
Format as date
Ctrl + Shift + !
Format as number (with decimals)
Ctrl + Shift + L
Toggle filters on/off
Charts and Quick Analysis
Ctrl + Q
Quick analysis of selected data
F11
Create chart in a new sheet
Alt + F1
Insert chart in current sheet
Ctrl + Shift + &
Apply border to cells
Alt + ↓
Open column filter dropdown
🏆 Pro Excel tip: Select your data and press Ctrl + Q to instantly see suggestions for charts, totals, and formatting—no formulas required!
🎯 How to Learn Them Easily
You don’t need to memorize everything at once! Here’s a simple strategy:
- ✅ Week 1: Learn the 5 basics: Ctrl+S, Ctrl+C, Ctrl+V, Ctrl+Z, Ctrl+F
- ✅ Week 2: Add 3–4 more shortcuts that match your daily tasks
- ✅ Week 3+: Keep adding gradually—you’ll soon use them automatically!
With just 10 minutes of practice per day, you can work up to 50% faster in a few weeks.
🚀 Start today and see the difference!
