Beauty Of Nature

Math Test ❓

👉 https://t.me/addlist/CNfReflaIBRhNDE0

🔹 Alt + W + F + F – Freeze or unfreeze panes ❄️
🔹 Alt + W + Q – Zoom to selection
🔹 Alt + W + V + G – Show or hide gridlines
🔹 Alt + W + V + F – Show or hide formula bar
🔹 Alt + W + V + H – Show or hide headings
🔹 Alt + W + S – Split the window
🔹 Alt + W + L – Switch between Normal, Page Layout & Page Break views
🔹 Alt + H + M + C – Merge and center
🔹 Alt + H + O + I – Auto-fit column width
🔹 Alt + H + O + A – Auto-fit row height
🔹 Alt + H + B + A – Apply all borders
🔹 Alt + H + B + N – Remove all borders
🔹 Alt + H + D + C – Delete selected column
🔹 Alt + H + D + R – Delete selected row
🔹 Alt + H + O + R – Rename worksheet
🔹 Alt + A + M – Remove duplicates
🔹 Alt + A + E – Text to Columns wizard
🔹 Alt + A + T – Refresh all connections
🔹 Alt + N + V – Insert a PivotTable
🔹 Alt + N + F + S – Insert a Slicer
🔹 Alt + N + S + F – Insert a chart quickly
🔹 Ctrl + Alt + F9 – Force calculate all formulas
🔹 Ctrl + ` – Show or hide all formulas
🔹 Ctrl + Shift + L – Turn filters ON/OFF
🔹 Ctrl + Shift + & – Apply outline border
🔹 Ctrl + Shift + _ – Remove outline border
🔹 Ctrl + Shift + 7 – Add border around selection
🔹 Ctrl + Shift + U – Expand or collapse formula bar
🔹 Ctrl + Alt + T – Insert current time in Power Query
🔹 Ctrl + Shift + F3 – Create names from selection

---

✨ Quick Tip:
Use Alt + W + F + F to freeze header rows or columns, so your headings stay visible while scrolling through long data sheets 👀

---

🔹 Ctrl + D – Fill down
🔹 Ctrl + R – Fill right
🔹 Ctrl + T – Convert range to Excel Table
🔹 Ctrl + G – Open Go To dialog 📍
🔹 F5 – Open Go To dialog
🔹 Ctrl + F – Find text or values
🔹 Ctrl + H – Replace text or values
🔹 Ctrl + A – Select entire worksheet
🔹 Ctrl + Space – Select entire column
🔹 Shift + Space – Select entire row
🔹 Ctrl + Shift + L – Toggle Filters ON / OFF
🔹 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 data block
🔹 Ctrl + ; – Insert today’s date
🔹 Ctrl + Shift + : – Insert current time
🔹 Ctrl + 1 – Open Format Cells dialog
🔹 Ctrl + Z – Undo last action
🔹 Ctrl + Y – Redo last undone action
🔹 Ctrl + C – Copy
🔹 Ctrl + X – Cut
🔹 Ctrl + V – Paste
🔹 Alt + = – Auto-insert SUM
🔹 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 + G to instantly jump to specific cells, formulas, blanks, or named ranges without scrolling.

🔹 Alt + H + W – Wrap text in selected cells 🧾
🔹 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 + H + B + N – Remove 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 + W + F + F – Freeze / Unfreeze panes
🔹 Alt + W + Q – Zoom to selection
🔹 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 + H + W to wrap long text instantly — perfect for making dashboards and reports more readable.

Exponents and powers

Computer Shortcut Keys A to Z - General Knowledge