Dua Shortcuts

Dua Shortcuts Learn computer shortcuts, tutorial, troubleshoot, shortcut keys, and Microsoft Office skills

16/07/2025

Don't use a Calculator
🧐

9+8×0!

🔹 Ctrl + 5 - Apply/Remove strikethrough 🔹 Ctrl + E - Flash Fill 🔹 Alt + H + F + F - Change font 🔹 Alt + H + O + I - A...
01/07/2025

🔹 Ctrl + 5 - Apply/Remove strikethrough
🔹 Ctrl + E - Flash Fill
🔹 Alt + H + F + F - Change font
🔹 Alt + H + O + I - AutoFit column width
🔹 Alt + = - AutoSum
🔹 Ctrl + ; - Insert current date
🔹 Ctrl + Shift + ; - Insert current time
🔹 Ctrl + 1 - Format Cells dialog
🔹 Ctrl + T - Create table
🔹 Ctrl + Space - Select entire column
🔹 Shift + Space - Select entire row
🔹 Ctrl + Arrow Keys - Navigate data edges
🔹 Ctrl + Shift + L - Toggle filters
🔹 Alt + N + V - Insert PivotTable
🔹 Alt + A + M - Remove duplicates
🔹 Ctrl + D - Fill down
🔹 Ctrl + R - Fill right
🔹 Ctrl + - (Minus) - Delete selection
🔹 Ctrl + Shift + + (Plus) - Insert cells
🔹 Alt + E + S + V - Paste values
🔹 Alt + H + O + A - AutoFit row height
🔹 F2 - Edit active cell
🔹 F4 - Repeat last action/Toggle references
🔹 F9 - Calculate worksheets
🔹 Shift + F3 - Insert function
🔹 Ctrl + F3 - Name Manager
🔹 Alt + F1 - Create embedded chart
🔹 F11 - Create chart in new sheet
🔹 Ctrl + Shift + $ - Currency format
🔹 Ctrl + Shift + % - Percentage format

Strikethrough Tip: Use Ctrl + 5 to mark completed tasks while keeping them visible!

Follow 👉 excel_funclub

🔹 Ctrl + E - Flash Fill (auto-complete patterns)🔹 Ctrl + ; - Insert current date🔹 Ctrl + Shift + ; - Insert current time...
24/06/2025

🔹 Ctrl + E - Flash Fill (auto-complete patterns)
🔹 Ctrl + ; - Insert current date
🔹 Ctrl + Shift + ; - Insert current time
🔹 Alt + = - AutoSum selected cells
🔹 Ctrl + 1 - Format Cells dialog
🔹 Ctrl + T - Create table
🔹 Ctrl + Space - Select entire column
🔹 Shift + Space - Select entire row
🔹 Ctrl + Arrow Keys - Navigate data regions
🔹 Ctrl + Shift + L - Toggle filters
🔹 Alt + N + V - Insert PivotTable
🔹 Alt + A + M - Remove duplicates
🔹 Ctrl + D - Fill down
🔹 Ctrl + R - Fill right
🔹 Ctrl + - (Minus) - Delete selection
🔹 Ctrl + Shift + + (Plus) - Insert cells
🔹 Alt + E + S + V - Paste values
🔹 Alt + H + O + I - Auto-fit column width
🔹 Alt + H + O + A - Auto-fit row height
🔹 F2 - Edit active cell
🔹 F4 - Repeat last action
🔹 F9 - Calculate worksheets
🔹 Ctrl + F3 - Name Manager
🔹 Alt + F1 - Create embedded chart
🔹 F11 - Create chart in new sheet
🔹 Ctrl + Shift + $ - Currency format
🔹 Ctrl + Shift + % - Percentage format
🔹 Ctrl + Shift + # - Date format
🔹 Ctrl + Shift + @ - Time format
🔹 Alt + W + F - Freeze panes

Flash Fill Tip: Type 1-2 examples, then press Ctrl + E to automatically fill patterns (names, dates, addresses etc.).

🔹 Ctrl + Shift + ~ - Apply General number format 🔹 Ctrl + ; - Insert current date 🔹 Ctrl + Shift + ; - Insert current ...
22/06/2025

🔹 Ctrl + Shift + ~ - Apply General number format
🔹 Ctrl + ; - Insert current date
🔹 Ctrl + Shift + ; - Insert current time
🔹 Ctrl + N - Create new workbook
🔹 Ctrl + O - Open existing workbook
🔹 Ctrl + S - Save workbook
🔹 Ctrl + P - Open print dialog
🔹 Ctrl + Z - Undo last action
🔹 Ctrl + Y - Redo last action
🔹 Ctrl + C - Copy selection
🔹 Ctrl + X - Cut selection
🔹 Ctrl + V - Paste
🔹 Ctrl + F - Find text
🔹 Ctrl + H - Find and replace
🔹 Ctrl + A - Select all cells
🔹 Ctrl + Arrow keys - Jump to edge of data region
🔹 Shift + Space - Select entire row
🔹 Ctrl + Space - Select entire column
🔹 Ctrl + Home - Go to cell A1
🔹 Ctrl + End - Go to last used cell
🔹 Alt + = - AutoSum selected cells
🔹 Ctrl + 1 - Open Format Cells dialog
🔹 Alt + F1 - Create embedded chart
🔹 F11 - Create chart in new sheet
🔹 Alt + A + M - Remove duplicates
🔹 Alt + N + V - Insert PivotTable
🔹 Ctrl + Shift + $ - Apply Currency format
🔹 Ctrl + Shift + % - Apply Percentage format
🔹 Ctrl + Shift + # - Apply Date format
🔹 Ctrl + Shift + @ - Apply Time format

Use Ctrl + Shift + ~ to quickly reset number formatting to General!

🔹 Ctrl + Shift + L - Toggle filters on/off 🔹 Alt + N + V - Create PivotTable 🔹 Alt + A + M - Remove duplicates 🔹 Ctrl...
21/06/2025

🔹 Ctrl + Shift + L - Toggle filters on/off
🔹 Alt + N + V - Create PivotTable
🔹 Alt + A + M - Remove duplicates
🔹 Ctrl + T - Create table
🔹 Ctrl + Space - Select entire column
🔹 Shift + Space - Select entire row
🔹 Ctrl + - (Minus) - Delete selection
🔹 Ctrl + + (Plus) - Insert cells
🔹 Ctrl + Shift + + (Plus) - Insert row/column
🔹 Ctrl + Page Up - Previous sheet
🔹 Ctrl + Page Down - Next sheet
🔹 Alt + E + S + V - Paste special values
🔹 Alt + H + O + I - Auto-fit column width
🔹 Alt + H + O + A - Auto-fit row height
🔹 Ctrl + Shift + ~ - General number format
🔹 Ctrl + Shift + $ - Currency format
🔹 Ctrl + Shift + % - Percentage format
🔹 Ctrl + Shift + # - Date format
🔹 Ctrl + Shift + @ - Time format
🔹 Ctrl + Shift + ! - Number format
🔹 Alt + W + F - Freeze panes
🔹 Alt + W + S - Split window
🔹 Ctrl + F6 - Switch between workbooks
🔹 Alt + Tab - Switch between applications
🔹 F2 - Edit active cell
🔹 F4 - Repeat last action
🔹 F9 - Calculate all worksheets
🔹 Shift + F3 - Insert function
🔹 Ctrl + F3 - Define name
🔹 Alt + F8 - Open macro dialog

Use Ctrl + Shift + L to quickly add/remove filters from your data headers!

🔹 Ctrl + Shift + ; - Insert current time 🔹 Ctrl + ; - Insert current date 🔹 Alt + = - AutoSum selected cells 🔹 Ctrl +...
20/06/2025

🔹 Ctrl + Shift + ; - Insert current time
🔹 Ctrl + ; - Insert current date
🔹 Alt + = - AutoSum selected cells
🔹 Ctrl + N - New workbook
🔹 Ctrl + O - Open workbook
🔹 Ctrl + S - Save workbook
🔹 Ctrl + P - Print dialog
🔹 Ctrl + Z - Undo
🔹 Ctrl + Y - Redo
🔹 Ctrl + C - Copy
🔹 Ctrl + X - Cut
🔹 Ctrl + V - Paste
🔹 Ctrl + F - Find
🔹 Ctrl + H - Replace
🔹 Ctrl + A - Select all
🔹 Ctrl + Arrow Keys - Navigate data edges
🔹 Ctrl + 1 - Format Cells dialog
🔹 Alt + F1 - Create quick chart
🔹 F11 - Create chart in new sheet
🔹 Ctrl + Shift + L - Toggle filters

Bonus Tip: Use Ctrl + Shift + ; to quickly timestamp your data entries!

Coloring doll
17/06/2025

Coloring doll

🔹 Ctrl + Shift + $ - Apply Currency format 🔹 Alt + F1 - Create quick chart 🔹 F11 - Create chart in new sheet 🔹 Ctrl +...
14/06/2025

🔹 Ctrl + Shift + $ - Apply Currency format
🔹 Alt + F1 - Create quick chart
🔹 F11 - Create chart in new sheet
🔹 Ctrl + N - New workbook
🔹 Ctrl + O - Open workbook
🔹 Ctrl + S - Save workbook
🔹 Ctrl + P - Print dialog
🔹 Ctrl + Z - Undo
🔹 Ctrl + Y - Redo
🔹 Ctrl + C - Copy
🔹 Ctrl + X - Cut
🔹 Ctrl + V - Paste
🔹 Ctrl + F - Find
🔹 Ctrl + H - Replace
🔹 Ctrl + A - Select all
🔹 Ctrl + Arrow Keys - Navigate data edges
🔹 Shift + Space - Select entire row
🔹 Ctrl + Space - Select entire column
🔹 Ctrl + Home - Go to A1
🔹 Ctrl + End - Last used cell
🔹 Alt + = - AutoSum
🔹 Ctrl + ; - Insert date
🔹 Ctrl + Shift + ; - Insert time
🔹 Ctrl + 1 - Format Cells dialog
🔹 Alt + A + M - Remove duplicates
🔹 Alt + N + V - Insert PivotTable
🔹 Ctrl + Shift + % - Percentage format
🔹 Ctrl + Shift + # - Date format
🔹 Ctrl + Shift + @ - Time format
🔹 Ctrl + Shift + ! - Number format

Ctrl + Shift + $ to quickly format numbers as currency!

🔹 Ctrl + N - New workbook🔹 Ctrl + O - Open workbook🔹 Ctrl + S - Save workbook🔹 Ctrl + P - Print dialog🔹 Ctrl + Z - Undo🔹...
09/06/2025

🔹 Ctrl + N - New workbook
🔹 Ctrl + O - Open workbook
🔹 Ctrl + S - Save workbook
🔹 Ctrl + P - Print dialog
🔹 Ctrl + Z - Undo
🔹 Ctrl + Y - Redo
🔹 Ctrl + C - Copy
🔹 Ctrl + X - Cut
🔹 Ctrl + V - Paste
🔹 Ctrl + F - Find
🔹 Ctrl + H - Replace
🔹 Ctrl + A - Select all
🔹 Ctrl + Arrow Keys - Navigate data edges
🔹 Shift + Space - Select entire row
🔹 Ctrl + Space - Select entire column
🔹 Ctrl + Home - Jump to A1
🔹 Ctrl + End - Last used cell
🔹 Alt + A + E - Text to Columns wizard
🔹 Ctrl + B - Bold
🔹 Ctrl + I - Italic
🔹 Ctrl + U - Underline
🔹 Ctrl + 1 - Format cells
🔹 F2 - Edit cell
🔹 Alt + = - AutoSum
🔹 Ctrl + ; - Insert date
🔹 Ctrl + Shift + ; - Insert time
🔹 Alt + A + M - Remove duplicates
🔹 Alt + N + V - PivotTable
🔹 Alt + F1 - Quick chart
🔹 F11 - New chart sheet

Alt + A + E is perfect for splitting names, addresses, or any delimited data!

🔹 Alt + A + T – Apply or remove filters🔹 Ctrl + A – Select all🔹 Ctrl + T – Create Table🔹 Ctrl + B – Bold🔹 Ctrl + I – Ita...
29/05/2025

🔹 Alt + A + T – Apply or remove filters
🔹 Ctrl + A – Select all
🔹 Ctrl + T – Create Table
🔹 Ctrl + B – Bold
🔹 Ctrl + I – Italic
🔹 Ctrl + U – Underline
🔹 Ctrl + C – Copy
🔹 Ctrl + V – Paste
🔹 Ctrl + X – Cut
🔹 Ctrl + Z – Undo
🔹 Ctrl + Y – Redo
🔹 Ctrl + F – Find
🔹 Ctrl + H – Replace
🔹 Ctrl + K – Insert Hyperlink
🔹 Ctrl + ; – Insert today’s date
🔹 Ctrl + Shift + : – Insert current time
🔹 Ctrl + Shift + "+" – Insert new row/column
🔹 Ctrl + - – Delete row/column
🔹 Ctrl + 1 – Format Cells
🔹 Ctrl + D – Fill Down
🔹 Ctrl + R – Fill Right
🔹 Ctrl + Space – Select column
🔹 Shift + Space – Select row
🔹 Alt + A + R – Refresh data
🔹 Alt + W + F + F – Freeze panes
🔹 Ctrl + Page Up – Previous sheet
🔹 Ctrl + Page Down – Next sheet
🔹 F2 – Edit active cell
🔹 Alt + E + S – Paste Special
🔹 Ctrl + Q – Quick Analysis

---

🔥 Tip of the day: Hit Alt + A + T to add filters instantly and sort like a boss!
💬 Comment “Filter Flex” if you use this every day!
✅ Like | 💾 Save | 👉 Follow

Address

Hubli

Website

Alerts

Be the first to know and let us send you an email when Dua Shortcuts posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Shortcuts

Share

Category