SB TECH

🔹 Alt + W + F + F – Freeze / Unfreeze panes 🧊
🔹 Alt + W + Q – Zoom to selection
🔹 Alt + W + S – Split window
🔹 Alt + W + V + G – Show / Hide gridlines
🔹 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 + 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 + = – Auto-insert SUM
🔹 Alt + Enter – New line inside a cell
🔹 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 + Page Down – Move to next worksheet
🔹 Ctrl + Page Up – Move to previous worksheet
🔹 Ctrl + Space – Select entire column
🔹 Shift + Space – Select entire row
🔹 F2 – Edit active cell

✨ Quick Tip:
Use Alt + W + F + F to lock headers while scrolling — essential for working with large datasets.

Excell Tips

🔹 Ctrl + Alt + F5 – Refresh selected data connection 🔄
🔹 Ctrl + Alt + F9 – Force full recalculation of all formulas
🔹 Ctrl + ` – Show/Hide formulas
🔹 Ctrl + Shift + L – Turn Filters ON/OFF
🔹 Ctrl + Shift + "+" – Insert a row/column
🔹 Ctrl + "-" – Delete selected row/column
🔹 Ctrl + D – Fill down
🔹 Ctrl + R – Fill right
🔹 Ctrl + T – Convert range into Table
🔹 Ctrl + ; – Insert today’s date
🔹 Ctrl + Shift + : – Insert current time
🔹 Ctrl + 1 – Open Format Cells dialog
🔹 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 + 9 – Hide selected rows
🔹 Ctrl + Shift + 9 – Unhide rows
🔹 Ctrl + 0 – Hide selected columns
🔹 Ctrl + Shift + 0 – Unhide columns
🔹 Ctrl + Page Up – Previous worksheet
🔹 Ctrl + Page Down – Next worksheet
🔹 Alt + = – Auto-insert SUM
🔹 Alt + A + M – Remove duplicates
🔹 Alt + A + E – Text to Columns wizard
🔹 Alt + H + O + I – Auto-fit column width
🔹 Alt + W + F + F – Freeze/Unfreeze panes
🔹 F2 – Edit active cell
🔹 F4 – Repeat last action / toggle absolute references

---

✨ Quick Tip:
Use Ctrl + Alt + F5 to refresh only the selected query or data connection — faster and safer than refreshing everything!

---

🔹 Ctrl + 9 – Hide selected rows 👇
🔹 Ctrl + Shift + 9 – Unhide hidden rows
🔹 Ctrl + 0 – Hide selected columns
🔹 Ctrl + Shift + 0 – Unhide columns
🔹 Ctrl + A – Select entire worksheet
🔹 Ctrl + Space – Select entire column
🔹 Shift + Space – Select entire row
🔹 Ctrl + Shift + Space – Select entire data range
🔹 Ctrl + T – Convert data range into a Table
🔹 Ctrl + D – Fill down
🔹 Ctrl + R – Fill right
🔹 Ctrl + Shift + L – Turn Filters ON/OFF
🔹 Ctrl + ; – Insert current date
🔹 Ctrl + Shift + : – Insert current time
🔹 Ctrl + F – Find text or values
🔹 Ctrl + H – Replace text or values
🔹 Ctrl + 1 – Open Format Cells dialog
🔹 Ctrl + Shift + $ – Apply currency format
🔹 Ctrl + Shift + % – Apply percentage format
🔹 Ctrl + Shift + @ – Apply time format
🔹 Ctrl + Shift + # – Apply date format
🔹 Ctrl + Shift + ^ – Apply scientific format
🔹 Ctrl + Z – Undo last action
🔹 Ctrl + Y – Redo last undone action
🔹 Ctrl + Page Up – Go to previous sheet
🔹 Ctrl + Page Down – Go to next sheet
🔹 Alt + = – Auto insert SUM formula
🔹 Alt + H + O + I – Auto-fit column width
🔹 Alt + W + F + F – Freeze/unfreeze panes
🔹 F2 – Edit the active cell

---

✨ Quick Tip:
Use Ctrl + 9 to instantly hide unwanted rows — perfect for cleaning messy data or hiding intermediate calculations!

---

🔹 Ctrl + Alt + A + R – Refresh All data connections 🔄
🔹 Ctrl + Alt + F5 – Refresh selected connection
🔹 Ctrl + Alt + F9 – Force full recalculation
🔹 Ctrl + ` – Show/hide all formulas
🔹 Ctrl + Shift + "~" – Apply General number format
🔹 Ctrl + Shift + ! – Apply Number format
🔹 Ctrl + Shift + $ – Apply Currency format
🔹 Ctrl + Shift + % – Apply Percentage format
🔹 Ctrl + Shift + @ – Apply Time format
🔹 Ctrl + Shift + # – Apply Date format
🔹 Ctrl + 1 – Open Format Cells dialog
🔹 Ctrl + 9 – Hide selected rows
🔹 Ctrl + Shift + 9 – Unhide rows
🔹 Ctrl + 0 – Hide selected columns
🔹 Ctrl + Shift + 0 – Unhide columns
🔹 Ctrl + Shift + L – Turn Filters ON/OFF
🔹 Ctrl + Shift + + – Insert a new row/column
🔹 Ctrl + - – Delete selected row/column
🔹 Ctrl + D – Fill down
🔹 Ctrl + R – Fill right
🔹 Ctrl + ; – Insert today’s date
🔹 Ctrl + Shift + : – Insert current time
🔹 Ctrl + T – Convert range to Excel Table
🔹 Alt + A + E – Text to Columns
🔹 Alt + A + M – Remove duplicates
🔹 Alt + H + O + I – Auto-fit column width
🔹 Alt + H + M + C – Merge & center
🔹 Alt + W + F + F – Freeze/Unfreeze panes
🔹 Alt + N + V – Insert PivotTable
🔹 F2 – Edit active cell

---

✨ Quick Tip:
Use Ctrl + Alt + A + R to refresh every query, pivot, link, and connection in one shot — perfect for dashboards and automated reports! ⚡

---

What's your take?

What do you prefer?

What brand of laptop
Do you like
Dell, Lenovo,HP ,Asus,acer?