Master in MS Excel - Shortcuts and Formula

Print RSS
16
REHAN 24.01.2026 / 20:48 Author
Boss
0
πŸ”Ή Ctrl + K – Insert or edit a hyperlink πŸ”—
πŸ”Ή 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 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 used cell
πŸ”Ή Ctrl + Arrow Keys – Jump to data edges
πŸ”Ή Ctrl + Shift + Arrow Keys – Select entire data block
πŸ”Ή Ctrl + ; – Insert today’s date
πŸ”Ή Ctrl + Shift + : – Insert current time
πŸ”Ή Ctrl + 1 – Open Format Cells dialog
πŸ”Ή Ctrl + F – Find
πŸ”Ή Ctrl + H – Replace
πŸ”Ή Alt + = – Auto-insert SUM
πŸ”Ή Alt + Enter – New line inside a cell
πŸ”Ή Alt + A + E – Text to Columns
πŸ”Ή Alt + A + M – Remove duplicates
πŸ”Ή F2 – Edit active cell
πŸ”Ή Shift + F11 – Insert new worksheet

✨ Quick Tip:
Use Ctrl + K to quickly link cells to files, websites, or other sheets β€” perfect for dashboards and navigation!

#ExcelShortcuts #ExcelTips #ExcelHacks #ExcelFunClub #MicrosoftExcel #SpreadsheetHacks #ExcelLearning #ExcelTricks #OfficeProductivity #DataAnalysis #ExcelForWork #Excelfunclub
REHAN 24.01.2026 / 21:27 Author
Boss
0
Function Keys (F1–F12) and Their Uses
β€£ F1 – Help
β€’ Opens the Help menu of the active program
β€’ Used for getting instructions or support

β€£ F2 – Rename
β€’ Renames a selected file or folder
β€’ Used for editing file names quickly

β€£F3 – Search
β€’ Opens the Search feature
β€’ Used to find files, folders, or text

β€£ F4 – Address Bar / Close Window
β€’ Opens the address bar in File Explorer
β€’ Alt + F4 closes the current window or application

β€£ F5 – Refresh
β€’ Refreshes the current page or window
β€’ Commonly used in browsers and File Explorer

β€£ F6 – Switch Cursor / Address Bar
β€’ Moves the cursor to the address bar in browsers
β€’ Used to switch between screen elements

β€£ F7 – Spelling & Grammar Check
β€’ Checks spelling and grammar (MS Word, etc.)
β€’ Sometimes used for caret browsing in browsers

β€£ F8 – Startup / Safe Mode
β€’ Used during computer startup
β€’ Opens Advanced Boot Options or Safe Mode

β€£ F9 – Refresh / Update Fields
β€’ Refreshes documents or recalculates fields
β€’ Used in MS Word, Excel, and Outlook

β€£ F10 – Menu Bar
β€’ Activates the menu bar of the active program
β€’ Shift + F10 works like right-click

β€£ F11 – Full Screen Mode
β€’ Enters or exits full-screen view
β€’ Common in web browsers

β€£ F12 – Save As / Developer Tools
β€’ Opens Save As dialog in MS Word
β€’ Opens Developer Tools in browsers

βœ… Tip for Exams

β€£ F1 = Help
β€£ F2 = Rename
β€£ F5 = Refresh
β€£ F11 = Full Screen
β€£ Alt + F4 = Close program

β€£ Follow: CAPS LOCK

#shortcuts #functionkeys #computer #computertips #computertraining #pctips #typingskills #foryouγ‚· #photochallenge #trendingpost #CAPSLOCK
REHAN 24.01.2026 / 22:11 Author
Boss
0
πŸ”Ή Ctrl + ↑ (Up Arrow) – Jump to the top of the data column
πŸ”Ή Ctrl + ↓ (Down Arrow) – Jump to the bottom of the data column
πŸ”Ή Ctrl + ← (Left Arrow) – Jump to the beginning of the row
πŸ”Ή Ctrl + β†’ (Right Arrow) – Jump to the end of the row
πŸ”Ή Ctrl + Shift + ↑ – Select data upward
πŸ”Ή Ctrl + Shift + ↓ – Select data downward
πŸ”Ή Ctrl + Shift + ← – Select data to the left
πŸ”Ή Ctrl + Shift + β†’ – Select data to the right
πŸ”Ή Ctrl + Home – Jump to cell A1
πŸ”Ή Ctrl + End – Go to last used cell
πŸ”Ή Ctrl + Page Down – Move to next worksheet
πŸ”Ή Ctrl + Page Up – Move to previous worksheet
πŸ”Ή Ctrl + A – Select entire worksheet
πŸ”Ή Ctrl + Space – Select entire column
πŸ”Ή Shift + Space – Select entire row
πŸ”Ή Ctrl + T – Convert range to Excel Table
πŸ”Ή Ctrl + Shift + L – Toggle Filters ON / OFF
πŸ”Ή Ctrl + D – Fill down
πŸ”Ή Ctrl + R – Fill right
πŸ”Ή Ctrl + ; – Insert today’s date
πŸ”Ή Ctrl + Shift + : – Insert current time
πŸ”Ή Ctrl + 1 – Open Format Cells dialog
πŸ”Ή Ctrl + F – Find
πŸ”Ή Ctrl + H – Replace
πŸ”Ή Ctrl + Z – Undo last action
πŸ”Ή Ctrl + Y – Redo last undone action
πŸ”Ή Alt + = – Auto-insert SUM
πŸ”Ή Alt + Enter – New line inside a cell
πŸ”Ή F2 – Edit active cell
πŸ”Ή Shift + F11 – Insert new worksheet

✨ Quick Tip:
Use Ctrl + Navigation keys to move across large datasets in seconds β€” no scrolling, no mouse, pure speed!

#ExcelShortcuts #ExcelTips #ExcelHacks #ExcelFunClub #MicrosoftExcel #SpreadsheetHacks #ExcelLearning #ExcelTricks #OfficeProductivity #DataAnalysis #ExcelForWork #Excelfunclub
Stickers / Tags / Rules