Core Tech It solution

Excel shortcuts

🔹 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
🔹 Shift + F11 – Insert new worksheet

✨ Quick Tip:
Use Alt + H + O + I after pasting data to instantly fix column width and keep your sheet clean.