Excel Shortcut Pro

🔹 Ctrl + Shift + $ – Apply Currency format 💰
🔹 Ctrl + Shift + % – Apply Percentage format
🔹 Ctrl + Shift + # – Apply Date format
🔹 Ctrl + Shift + @ – Apply Time format
🔹 Ctrl + Shift + ! – Apply Number format
🔹 Ctrl + Shift + ^ – Apply Scientific format
🔹 Ctrl + Shift + ~ – Apply General format
🔹 Ctrl + 1 – Open Format Cells
🔹 Ctrl + B – Apply/remove Bold
🔹 Ctrl + I – Apply/remove Italic
🔹 Ctrl + U – Apply/remove Underline
🔹 Ctrl + 5 – Apply/remove Strikethrough
🔹 Ctrl + T – Convert range into an Excel Table
🔹 Ctrl + Shift + L – Turn Filters ON/OFF
🔹 Ctrl + E – Flash Fill
🔹 Ctrl + D – Fill Down
🔹 Ctrl + R – Fill Right
🔹 Ctrl + Enter – Fill selected cells with the same entry
🔹 Ctrl + ; – Insert current date
🔹 Ctrl + Shift + : – Insert current time
🔹 Ctrl + Space – Select entire column
🔹 Shift + Space – Select entire row
🔹 Ctrl + Home – Go to cell A1
🔹 Ctrl + End – Go to the last used cell
🔹 Ctrl + Page Up – Move to previous worksheet
🔹 Ctrl + Page Down – Move to next worksheet
🔹 Ctrl + Q – Open Quick Analysis
🔹 Ctrl + G – Open Go To
🔹 Alt + = – Insert AutoSum
🔹 F2 – Edit the active cell

--

✨ Quick Tip:
Use Ctrl + Shift + $ to instantly format selected numbers as currency. It’s especially useful when preparing salary, billing, sales, or financial reports. 💰📊

--

🔹 Ctrl + Shift + @ – Apply time format ⏰

🔹 Ctrl + Shift + $ – Apply currency format

🔹 Ctrl + Shift + % – Apply percentage format

🔹 Ctrl + Shift + # – Apply date format

🔹 Ctrl + Shift + ^ – Apply scientific format

🔹 Ctrl + 1 – Open Format Cells dialog

🔹 Ctrl + D – Fill down

🔹 Ctrl + R – Fill right

🔹 Ctrl + T – Convert range to Excel Table

🔹 Ctrl + Shift + L – Toggle Filters ON / OFF

🔹 Ctrl + A – Select current data region; press again to select entire worksheet

🔹 Ctrl + Space – Select entire column

🔹 Shift + Space – Select entire row

🔹 Ctrl + Page Down – Move to next worksheet

🔹 Ctrl + Page Up – Move to previous worksheet

🔹 Ctrl + Home – Jump to cell A1

🔹 Ctrl + End – Go to last cell of the used range

🔹 Ctrl + Arrow Keys – Jump to the edge of the current data region

🔹 Ctrl + Shift + Arrow Keys – Extend selection to the edge of the current data region

🔹 Ctrl + ; – Insert today’s date

🔹 Ctrl + Shift + : – Insert current time

🔹 Ctrl + F – Find

🔹 Ctrl + H – Replace

🔹 Ctrl + Z – Undo last action

🔹 Ctrl + Y – Redo last undone action

🔹 Alt + = – Insert the SUM formula

🔹 Alt + Enter – New line inside a cell

🔹 Alt + A + E – Text to Columns

🔹 F2 – Edit active cell

🔹 Shift + F11 – Insert new worksheet

✨ Quick Tip:

Use Ctrl + Shift + @ to quickly format time values correctly — especially useful for logs and timestamps.

● Ctrl + Shift + Esc – Open Task Manager
● Ctrl + Shift + N – Create a new folder
● Ctrl + Shift + V – Paste without formatting
● Ctrl + Shift + S – Save As
● Ctrl + Shift + E – Track Changes in Word
● Ctrl + Shift + W – Underline words only in Word
● Ctrl + Shift + D – Apply double underline in Word
● Ctrl + Shift + K – Apply small caps in Word
● Ctrl + Shift + A – Apply ALL CAPS in Word
● Ctrl + Shift + L – Apply bullet list in Word
● Ctrl + Shift + C – Copy formatting in Word
● Ctrl + Shift + F – Open Font settings
● Ctrl + Shift + P – Open Font Size settings
● Ctrl + Shift + > – Increase font size
● Ctrl + Shift + < – Decrease font size
● Ctrl + Shift + 7 – Apply borders in Excel
● Ctrl + Shift + U – Expand/collapse Formula Bar in Excel
● Ctrl + Shift + F3 – Create names from selected cells
● Ctrl + Shift + O – Select cells containing notes
● Ctrl + Shift + G – Open Workbook Statistics
● Ctrl + Shift + 1 – Apply Number format
● Ctrl + Shift + 2 – Apply Time format
● Ctrl + Shift + 3 – Apply Date format
● Ctrl + Shift + 4 – Apply Currency format
● Ctrl + Shift + 5 – Apply Percentage format
● Ctrl + Shift + 6 – Apply Scientific format
● Win + Ctrl + D – Create a new virtual desktop
● Win + Ctrl + F4 – Close the current virtual desktop
● Win + Ctrl + Left Arrow – Switch to the left virtual desktop
● Win + Ctrl + Right Arrow – Switch to the right virtual desktop
● Win + Shift + S – Capture a screen snip
● Win + Ctrl + Shift + B – Reset the graphics driver
● Win + Alt + R – Start/stop screen recording
● Win + Alt + Print Screen – Capture the active game window
● Ctrl + Shift + Tab – Move to the previous browser tab
● Ctrl + Shift + Page Up – Move the current tab left
● Ctrl + Shift + Page Down – Move the current tab right

Here's my Excel handbook I use every day!

● Ctrl + Shift + $ – Apply Currency format
● Ctrl + Shift + % – Apply Percentage format
● Ctrl + Shift + # – Apply Date format
● Ctrl + Shift + @ – Apply Time format
● Ctrl + Shift + ^ – Apply Scientific format
● Ctrl + Shift + ! – Apply Number format
● Ctrl + Shift + ~ – Apply General format
● Ctrl + Shift + & – Apply an outline border
● Ctrl + Shift + _ – Remove an outline border
● Ctrl + Shift + * – Select the current data region
● Ctrl + Shift + U – Expand or collapse the Formula Bar
● Ctrl + Shift + F3 – Create names from selected cells
● Ctrl + Shift + G – Open Workbook Statistics
● Ctrl + Shift + O – Select cells containing notes
● Ctrl + Q – Open Quick Analysis
● Ctrl + E – Flash Fill
● Ctrl + K – Insert a hyperlink
● Ctrl + G – Open the Go To dialog
● Ctrl + 5 – Apply or remove strikethrough
● Ctrl + 9 – Hide selected rows
● Ctrl + 0 – Hide selected columns
● Ctrl + W – Close the current workbook
● Ctrl + N – Create a new workbook
● Ctrl + O – Open an existing workbook
● Ctrl + P – Open the Print dialog
● Ctrl + F1 – Show or hide the Ribbon
● Ctrl + Shift + + – Insert cells, rows, or columns
● Ctrl + - – Delete cells, rows, or columns
● Ctrl + Alt + V – Open the Paste Special dialog
● Ctrl + Shift + V – Paste values or paste options
● Ctrl + Enter – Fill all selected cells with the current entry
● Ctrl + Backspace – Scroll the active cell into view
● Ctrl + Delete – Delete text to the end while editing a cell
● Alt + F8 – Open the Macro dialog
● Alt + F11 – Open the VBA Editor
● Alt + F1 – Create a chart in the current worksheet
● Alt + Down Arrow – Open a drop-down list
● Alt + A + G + G – Group selected rows or columns
● Alt + A + G + U – Ungroup selected rows or columns
● Alt + A + C – Clear filters from the current range
● Shift + F2 – Insert or edit a note
● F4 – Repeat the last action / cycle formula references
● F5 – Open the Go To dialog
● F7 – Check spelling
● F9 – Recalculate formulas
● F11 – Create a chart on a separate chart sheet
● Shift + F11 – Insert a new worksheet
● Ctrl + Page Up – Move to the previous worksheet
● Ctrl + Page Down – Move to the next worksheet
● Ctrl + Shift + Page Up – Select the previous worksheet
● Ctrl + Shift + Page Down – Select the next worksheet

🔹 Ctrl + E – Flash Fill ⚡
🔹 Ctrl + T – Convert a range into an Excel Table
🔹 Ctrl + Shift + L – Turn Filters ON/OFF
🔹 Ctrl + D – Fill Down
🔹 Ctrl + R – Fill Right
🔹 Ctrl + Enter – Fill selected cells with the same entry
🔹 Ctrl + Shift + Enter – Enter a legacy array formula
🔹 Ctrl + Q – Open Quick Analysis
🔹 Ctrl + G – Open Go To
🔹 Ctrl + K – Insert a hyperlink
🔹 Ctrl + F – Find data
🔹 Ctrl + H – Find & Replace
🔹 Ctrl + Space – Select entire column
🔹 Shift + Space – Select entire row
🔹 Ctrl + ↑ / ↓ – Jump to the edge of a data region
🔹 Ctrl + ← / → – Jump to the edge of a data region
🔹 Ctrl + Shift + ↑ / ↓ – Select data up/down
🔹 Ctrl + Shift + ← / → – Select data left/right
🔹 Ctrl + Home – Go to cell A1
🔹 Ctrl + End – Go to the last used cell
🔹 Ctrl + Page Up – Move to previous worksheet
🔹 Ctrl + Page Down – Move to next worksheet
🔹 Ctrl + ; – Insert today’s date
🔹 Ctrl + Shift + : – Insert current time
🔹 Ctrl + 1 – Open Format Cells
🔹 Ctrl + 5 – Apply/remove strikethrough
🔹 Ctrl + 9 – Hide selected rows
🔹 Ctrl + 0 – Hide selected columns
🔹 Alt + = – Insert AutoSum

--

✨ Quick Tip:
Use Ctrl + E for Flash Fill. Enter an example of the pattern you want in the first cell, then press Ctrl + E—Excel can automatically recognize and fill the remaining values. ⚡📊

--

● Ctrl + Shift + L – Turn AutoFilter ON / OFF

● F2 – Edit the active cell

● Alt + A + M – Remove Duplicates

● Ctrl + Home – Go to the beginning of the worksheet

● Ctrl + E – Flash Fill

● Ctrl + Shift + + – Insert cells, rows, or columns

● Alt + = – AutoSum

● Ctrl + Page Down – Move to the next worksheet

● Ctrl + 5 – Apply or remove strikethrough

● Alt + A + S + D – Sort data Z → A / Largest → Smallest

● Ctrl + K – Insert a hyperlink

● Shift + F11 – Insert a new worksheet

● Ctrl + Space – Select the entire column

● Alt + A + E – Open Text to Columns

● Ctrl + Q – Open Quick Analysis

● Ctrl + End – Go to the last used cell

● Alt + A + G + G – Group rows or columns

● Ctrl + 1 – Open the Format Cells dialog

● Ctrl + Shift + : – Insert the current time

● Ctrl + T – Convert a range into an Excel Table

● Alt + A + C – Clear active filters

● Ctrl + Page Up – Move to the previous worksheet

● Shift + Space – Select the entire row

● Ctrl + G – Open the Go To dialog

● Alt + A + S + A – Sort data A → Z / Smallest → Largest

● Ctrl + 9 – Hide selected rows

● Ctrl + ; – Insert the current date

● F4 – Repeat the last action / cycle formula references

● Alt + A + G + U – Ungroup rows or columns

● Ctrl + 0 – Hide selected columns

● Ctrl + Shift + S – Open Save As in supported Excel versions

● Ctrl + Shift + F – Open Font options

● Ctrl + Shift + P – Open Font Size options

● Ctrl + Shift + G – Open Workbook Statistics

● Ctrl + Shift + * – Select the current data region

● Ctrl + Shift + Home – Extend the selection to the beginning of the worksheet

● Ctrl + Shift + End – Extend the selection to the last used cell

● Ctrl + Alt + V – Open the Paste Special dialog

● Ctrl + Shift + V – Paste values/options in supported Excel versions

● Ctrl + D – Fill Down

● Ctrl + R – Fill Right

● Ctrl + F – Find data

● Ctrl + H – Find and Replace

● F7 – Check spelling

● F9 – Recalculate formulas

● F11 – Create a chart sheet

● Alt + F1 – Create an embedded chart

● Alt + Down Arrow – Open a cell's drop-down list

● Ctrl + Shift + Page Up – Select the current and previous worksheet

● Ctrl + Shift + Page Down – Select the current and next worksheet

● Ctrl + Arrow Key – Jump to the edge of the current data region

● Ctrl + Shift + Arrow Key – Extend selection to the edge of the data region

● Ctrl + Shift + 1 – Apply Number format

● Ctrl + Shift + 2 – Apply Time format

● Ctrl + Shift + 3 – Apply Date format

● Ctrl + Shift + 4 – Apply Currency format

● Ctrl + Shift + 5 – Apply Percentage format

● Ctrl + Shift + 6 – Apply Scientific format

● Ctrl + Shift + 7 – Apply Outline Border

● Ctrl + Shift + 8 – Show/hide outline symbols

🔹 Ctrl + Shift + V – Paste values only (no formulas, no formatting)

🔹 Ctrl + Alt + V – Open Paste Special dialog

🔹 Ctrl + C – Copy

🔹 Ctrl + X – Cut

🔹 Ctrl + V – Paste

🔹 Ctrl + Z – Undo last action

🔹 Ctrl + Y – Redo last undone action

🔹 Ctrl + D – Fill down

🔹 Ctrl + R – Fill right

🔹 Ctrl + T – Convert range to Excel Table

🔹 Ctrl + Shift + L – Toggle Filters ON/OFF

🔹 Ctrl + A – Select current data region; press again to select the entire worksheet

🔹 Ctrl + Space – Select entire column

🔹 Shift + Space – Select entire row

🔹 Ctrl + ; – Insert today’s date

🔹 Ctrl + Shift + : – Insert current time

🔹 Ctrl + 1 – Open Format Cells dialog

🔹 Ctrl + F – Find

🔹 Ctrl + H – Replace

🔹 Ctrl + Page Up – Move to previous worksheet

🔹 Ctrl + Page Down – Move to next worksheet

🔹 Ctrl + Arrow Keys – Jump to data edges

🔹 Ctrl + Shift + Arrow Keys – Select data to the edge of the current data region

🔹 Alt + = – Auto-insert SUM

🔹 Alt + Enter – New line inside a cell

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

🔹 Alt + A + E – Text to Columns

🔹 Alt + A + M – Remove duplicates

🔹 F2 – Edit active cell

✨ Quick Tip:

Use Ctrl + Shift + V when cleaning data — it pastes only values, helping you avoid unwanted formulas and formatting!

100 Excel Shortcuts!