MS Excel Funclub

🔹 Ctrl + ; – Insert today’s date 📅 🔹 Ctrl + Shift + : – Insert current time ⏰ 🔹 Ctrl + A – Select entire worksheet 🔹 Ctrl + Space – Select entire column 🔹 Shift + Space – Select entire row 🔹 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 + F – Find text or values 🔹 Ctrl + H – Replace text or values 🔹 Ctrl + 1 – Open Format...

🔹 Ctrl + P – Open Print dialog 🖨️ 🔹 Ctrl + N – Create a new workbook 🔹 Ctrl + O – Open an existing workbook 🔹 Ctrl + S – Save current workbook 🔹 Ctrl + W – Close active workbook 🔹 Ctrl + C – Copy selected cells 🔹 Ctrl + X – Cut selected cells 🔹 Ctrl + V – Paste content 🔹 Ctrl + Z – Undo last action 🔹 Ctrl + Y – Redo last undone action 🔹 Ctrl + A – Select entire worksheet 🔹 Ctrl + F – Find text or values 🔹 Ctrl + H – Replace text or values 🔹 Ctrl + D – Fill down 🔹 Ctrl + R – Fill right 🔹 Ctrl...

Here's my Excel Formulas handbook I use every day! 💯 Save this for quick reference! 🔖 #exceltips #exceltricks #exceltutorial #explore #excelformulas excelshortcuts

🔹 Ctrl + Shift + D – Double underline text 🔹 Ctrl + D – Open Font dialog box 🅰️ 🔹 Ctrl + B – Bold selected text 🔹 Ctrl + I – Italic selected text 🔹 Ctrl + U – Underline text 🔹 Ctrl + Shift + W – Underline words only 🔹 Ctrl + Shift + K – Small caps 🔹 Ctrl + Shift + A – ALL CAPS 🔹 Ctrl + = – Subscript 🔹 Ctrl + Shift + = – Superscript 🔹 Ctrl + L – Align left 🔹 Ctrl + E – Center align 🔹 Ctrl + R – Align right 🔹 Ctrl + J – Justify text 🔹 Ctrl + M – Increase indent 🔹 Ctrl + Shift + M – Decrease...

Here's my Excel Formulas handbook I use every day! 💯 Save this for quick reference! 🔖 #exceltips #exceltricks #exceltutorial #explore #excelformulas excelshortcuts

🔹 Alt + = – Auto-insert SUM formula ➕ 🔹 Alt + Enter – New line inside a cell 🔹 Alt + A + E – Text to Columns 🔹 Alt + A + M – Remove duplicates 🔹 Alt + A + G + G – Group rows or columns 🔹 Alt + A + G + U – Ungroup data 🔹 Alt + A + S + A – Sort A → Z 🔹 Alt + A + S + D – Sort Z → A 🔹 Alt + N + V – Insert PivotTable 🔹 Alt + N + S + F – Insert chart 🔹 Alt + H + O + I – Auto-fit column width 🔹 Alt + H + O + A – Auto-fit row height 🔹 Alt + H + M + C – Merge & Center 🔹 Alt + H + B + A – Apply all...

🔹 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 entire worksheet 🔹 Ctrl + Space – Select entire column 🔹 Shift + Space – Select entire row 🔹 Ctrl + ; – Insert...

Here's my Excel Formulas handbook I use every day! 💯 Save this for quick reference! 🔖 #exceltips #exceltricks #exceltutorial #explore #excelformulas excelshortcuts

🔹 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...

🔹 Ctrl + D - Fill down (copies cell above) 🔹 Ctrl + R - Fill right (copies cell to left) 🔹 Ctrl + E - Flash Fill 🔹 Ctrl + C - Copy 🔹 Ctrl + X - Cut 🔹 Ctrl + V - Paste 🔹 Ctrl + Z - Undo 🔹 Ctrl + Y - Redo 🔹 Ctrl + F - Find 🔹 Ctrl + H - Replace 🔹 Ctrl + A - Select all 🔹 Ctrl + S - Save 🔹 Ctrl + N - New workbook 🔹 Ctrl + O - Open workbook 🔹 Ctrl + P - Print 🔹 Ctrl + W - Close workbook 🔹 F12 - Save As 🔹 Alt + = - AutoSum 🔹 Ctrl + ; - Insert current date 🔹 Ctrl + Shift...

Here's my Excel Formulas handbook I use every day! 💯 Save this for quick reference! 🔖 #exceltips #exceltricks #exceltutorial #explore #excelformulas excelshortcuts

🔹 Win + G – Open Xbox Game Bar 🎮 🔹 Win + Alt + R – Start/Stop screen recording 🔹 Win + Alt + G – Record last 30 seconds ✨ Quick Tip: Use Win + G to quickly record tutorials, reels, or screen demos without installing any extra software. #KeyboardShortcuts

🔹 Alt + A + G + G – Group selected rows or columns 📊 🔹 Alt + A + G + U – Ungroup rows or columns 🔹 Alt + A + G + C – Clear outline 🔹 Alt + A + M – Remove duplicates 🔹 Alt + A + E – Text to Columns 🔹 Alt + A + S + A – Sort A → Z 🔹 Alt + A + S + D – Sort Z → A 🔹 Alt + A + T – Refresh all data 🔹 Alt + H + O + I – Auto-fit column width 🔹 Alt + H + O + A – Auto-fit row height 🔹 Alt + H + M + C – Merge & Center 🔹 Alt + H + B + A – Apply all borders 🔹 Alt + W + F + F – Freeze / Unfreeze panes 🔹 Alt...

🔹 Ctrl + D – Open Font dialog box 🅰️ ✨ Quick Tip: Use Ctrl + D to quickly open the Font dialog box and apply advanced formatting like character spacing, effects, and styles in one go. #msword #keyboardshortcuts

🔹 Alt + D + S – Open Sort dialog box 🔽 🔹 Alt + A + S + A – Sort A → Z 🔹 Alt + A + S + D – Sort Z → A 🔹 Alt + A + M – Remove duplicates 🔹 Alt + A + E – Text to Columns 🔹 Alt + A + G + G – Group rows or columns 🔹 Alt + A + G + U – Ungroup data 🔹 Alt + H + O + I – Auto-fit column width 🔹 Alt + H + O + A – Auto-fit row height 🔹 Alt + H + M + C – Merge & Center 🔹 Alt + H + B + A – Apply all borders 🔹 Alt + W + F + F – Freeze / Unfreeze panes 🔹 Alt + W + Q – Zoom to selection 🔹 Alt + = –...