IBM PC Build

Good afternoon 🌨🌨

Monitor MSI MD272UPHG កម្រិត 4k អាចបង្វិលបាន នឹង តម្លៃសមរម្យ ✨❄️🎄

MLC0116 "MODERN MD272UPHG
( 27"" / UHD, IPS / HDR 400 / 60Hz / 0.5ms / HDMI 2x Port, 1x DP, 1x Type C (98W PD) USB Port )" 3-Years

🔹 Alt + D + S - Open Sort dialog
🔹 Ctrl + E - Flash Fill
🔹 Alt + A + E - Text to Columns
🔹 Alt + N + V - Create PivotTable
🔹 Alt + A + M - Remove duplicates
🔹 Ctrl + T - Create table
🔹 Ctrl + Space - Select entire column
🔹 Shift + Space - Select entire row
🔹 Ctrl + - (Minus) - Delete selection
🔹 Ctrl + + (Plus) - Insert cells
🔹 Ctrl + Shift + L - Toggle filters
🔹 Alt + W + F - Freeze panes
🔹 Alt + W + S - Split window
🔹 Ctrl + Page Up - Previous sheet
🔹 Ctrl + Page Down - Next sheet
🔹 Alt + E + S + V - Paste values
🔹 Alt + H + O + I - Auto-fit column width
🔹 Alt + H + O + A - Auto-fit row height
🔹 Ctrl + 1 - Format Cells dialog
🔹 F2 - Edit cell
🔹 F4 - Repeat last action/Toggle references
🔹 F9 - Calculate worksheets
🔹 Shift + F3 - Insert function
🔹 Ctrl + F3 - Define name
🔹 Alt + F8 - Macro dialog
🔹 Ctrl + Shift + : - Insert time
🔹 Ctrl + ; - Insert date
🔹 Alt + = - AutoSum
🔹 Ctrl + Shift + $ - Currency format
🔹 Ctrl + Shift + % - Percentage format

Bonus: Use Alt + D + S for multi-column sorting (Data > Sort in newer versions).

Follow 👉 excel_funclub