Wednesday, October 8, 2025

500 Most Useful Microsoft Excel Commands – Boost Your Productivity Instantly

💻 500 Real Microsoft Excel Commands — Functions & Shortcuts

💻 500 Real Microsoft Excel Commands — Functions & Shortcuts

Functions and keyboard shortcuts only — concise list.

  1. SUM (function)
  2. AVERAGE (function)
  3. COUNT (function)
  4. COUNTA (function)
  5. COUNTIF (function)
  6. COUNTIFS (function)
  7. SUMIF (function)
  8. SUMIFS (function)
  9. IF (function)
  10. IFS (function)
  11. IFERROR (function)
  12. VLOOKUP (function)
  13. HLOOKUP (function)
  14. INDEX (function)
  15. MATCH (function)
  16. XLOOKUP (function)
  17. XMATCH (function)
  18. CONCAT (function)
  19. CONCATENATE (function)
  20. TEXTJOIN (function)
  21. LEFT (function)
  22. RIGHT (function)
  23. MID (function)
  24. LEN (function)
  25. TRIM (function)
  26. CLEAN (function)
  27. UPPER (function)
  28. LOWER (function)
  29. PROPER (function)
  30. SUBSTITUTE (function)
  31. REPLACE (function)
  32. VALUE (function)
  33. TEXT (function)
  34. DATE (function)
  35. TODAY (function)
  36. NOW (function)
  37. YEAR (function)
  38. MONTH (function)
  39. DAY (function)
  40. EOMONTH (function)
  41. WORKDAY (function)
  42. NETWORKDAYS (function)
  43. DATEDIF (function)
  44. EDATE (function)
  45. TIME (function)
  46. HOUR (function)
  47. MINUTE (function)
  48. SECOND (function)
  49. ROUND (function)
  50. ROUNDUP (function)
  51. ROUNDDOWN (function)
  52. CEILING (function)
  53. FLOOR (function)
  54. MOD (function)
  55. POWER (function)
  56. SQRT (function)
  57. RAND (function)
  58. RANDBETWEEN (function)
  59. LARGE (function)
  60. SMALL (function)
  61. PERCENTILE.INC (function)
  62. PERCENTILE.EXC (function)
  63. QUARTILE.INC (function)
  64. MEDIAN (function)
  65. MODE.SNGL (function)
  66. STDEV.P (function)
  67. STDEV.S (function)
  68. VAR.P (function)
  69. VAR.S (function)
  70. CORREL (function)
  71. COVARIANCE.P (function)
  72. FORECAST.LINEAR (function)
  73. TREND (function)
  1. SLOPE (function)
  2. INTERCEPT (function)
  3. LINEST (function)
  4. FIND (function)
  5. SEARCH (function)
  6. EXACT (function)
  7. TRANSPOSE (function)
  8. MMULT (function)
  9. MINVERSE (function)
  10. MDETERM (function)
  11. SUMPRODUCT (function)
  12. UNIQUE (function)
  13. SORT (function)
  14. FILTER (function)
  15. SEQUENCE (function)
  16. RANDARRAY (function)
  17. LET (function)
  18. LAMBDA (function)
  19. FORMULATEXT (function)
  20. ISBLANK (function)
  21. ISNUMBER (function)
  22. ISTEXT (function)
  23. ISERROR (function)
  24. ISNA (function)
  25. INDIRECT (function)
  26. ADDRESS (function)
  27. ROW (function)
  28. ROWS (function)
  29. COLUMN (function)
  30. COLUMNS (function)
  31. OFFSET (function)
  32. GETPIVOTDATA (function)
  33. PIVOT TABLE (tool)
  34. SLICER (tool)
  35. TABLE (Ctrl+T) (tool/shortcut)
  36. REMOVE DUPLICATES (tool)
  37. SORT (Data) (tool)
  38. FILTER (Ctrl+Shift+L) (shortcut)
  39. ADVANCED FILTER (tool)
  40. CONDITIONAL FORMATTING (tool)
  41. DATA VALIDATION (tool)
  42. TEXT TO COLUMNS (tool)
  43. FLASH FILL (Ctrl+E) (tool/shortcut)
  44. POWER QUERY (tool)
  45. POWER PIVOT (tool)
  46. DAX (language)
  47. NAME MANAGER (tool)
  48. DEFINE NAME (tool)
  49. GO TO SPECIAL (F5→Special) (shortcut)
  50. FORMULA AUDITING (tool)
  51. EVALUATE FORMULA (tool)
  52. WATCH WINDOW (tool)
  53. QUICK ANALYSIS (tool)
  54. SPARKLINE (tool)
  55. CHARTS (tool)
  56. TREEMAP (chart)
  57. SUNBURST (chart)
  58. COMBO CHART (chart)
  59. TRENDLINE (chart option)
  60. HISTOGRAM (chart/tool)
  61. PERCENTILE (function)
  62. QUARTILE (function)
  63. FREQUENCY (function)
  64. SOLVER (add-in)
  65. ANALYSIS TOOLPAK (add-in)
  66. PIVOT CHART (tool)
  67. GET & TRANSFORM (tool)
  1. IMPORT CSV (tool)
  2. IMPORT TXT (tool)
  3. WEB QUERY / FROM WEB (tool)
  4. CONNECTIONS (tool)
  5. REFRESH ALL (command)
  6. MANUAL CALCULATION (setting)
  7. CALCULATE NOW (F9) (shortcut)
  8. CALCULATE SHEET (Shift+F9) (shortcut)
  9. DYNAMIC ARRAYS (feature)
  10. UNPIVOT (Power Query)
  11. APPEND QUERY (Power Query)
  12. MERGE QUERY (Power Query)
  13. LOAD TO DATA MODEL (option)
  14. REFRESH ON OPEN (option)
  15. TEXTSPLIT (function, 365)
  16. TEXTBEFORE (function, 365)
  17. TEXTAFTER (function, 365)
  18. TOCOL (function, 365)
  19. TOROW (function, 365)
  20. TOCOL/TOROW combos (functions)
  21. BYROW (function, 365)
  22. BYCOL (function, 365)
  23. MAKEARRAY (function, 365)
  24. SPILL RANGE (behavior)
  25. UNIQUE+SORT (pattern)
  26. INDEX+MATCH (pattern)
  27. TEXTJOIN + FILTER (pattern)
  28. SUMPRODUCT (function)
  29. AGGREGATE (function)
  30. SUBTOTAL (function)
  31. REMOVE EXTERNAL LINKS (action)
  32. COMPATIBILITY CHECK (tool)
  33. EXPORT PDF (action)
  34. SAVE AS BINARY (.xlsb) (action)
  35. AUTOSAVE (feature)
  36. RECOVER UNSAVED (feature)
  37. VERSION HISTORY (feature)
  38. CELL (function) (function)
  39. INFO (function)
  40. TYPE (function)
  41. N (function)
  42. T (function)
  43. FORMATTEXT (typo avoided: FORMULATEXT used) (function)
  44. CAMERA TOOL (tool)
  45. HYPERLINK (function)
  46. INSERT PICTURE (action)
  47. HEADER & FOOTER (print)
  48. PAGE SETUP (print)
  49. PAGE BREAK PREVIEW (view)
  50. PRINT TITLES (print)
  51. PRINT AREA (print)
  52. PAGE ORIENTATION (print)
  53. FIT SHEET TO ONE PAGE (print)
  54. EXPORT CSV UTF-8 (action)
  55. FORMAT PAINTER (tool)
  56. FORMAT CELLS (Ctrl+1) (shortcut)
  57. CUSTOM NUMBER FORMAT (format)
  58. HIDE / UNHIDE ROWS (action)
  59. HIDE / UNHIDE COLUMNS (action)
  60. GROUP / UNGROUP (tool)
  1. SUBTOTAL (function)
  2. AGGREGATE (function)
  3. FILL HANDLE (tool)
  4. FILL SERIES (tool)
  5. AUTO FILL OPTIONS (tool)
  6. NAME BOX (UI)
  7. QUICK ACCESS TOOLBAR (UI)
  8. RIBBON CUSTOMIZE (UI)
  9. ADD-INS (feature)
  10. SOLVER ADD-IN (add-in)
  11. ANALYSIS TOOLPAK (add-in)
  12. FREQUENCY (function)
  13. ERROR.TYPE (function)
  14. SHOW FORMULAS (Ctrl+`) (shortcut)
  15. RELATIVE/ABSOLUTE REFERENCES (concept)
  16. MIXED REFERENCES (concept)
  17. INDIRECT (function)
  18. OFFSET (function)
  19. ADDRESS (function)
  20. ROW / ROWS (function)
  21. COLUMN / COLUMNS (function)
  22. NAMED RANGES (feature)
  23. NAME MANAGER (tool)
  24. FORM CONTROLS (tool)
  25. ACTIVE X CONTROLS (tool)
  26. MACROS (Alt+F8) (shortcut)
  27. VBA EDITOR (Alt+F11) (shortcut)
  28. RECORD MACRO (tool)
  29. RUN MACRO (action)
  30. ASSIGN MACRO TO SHAPE (action)
  31. PROTECT SHEET (action)
  32. PROTECT WORKBOOK (action)
  33. ALLOW EDIT RANGES (option)
  34. PASSWORD PROTECT (action)
  35. TRACK CHANGES (legacy)
  36. COMPARE WORKBOOKS (tool)
  37. COAUTHORING (feature)
  38. COMMENTS (modern) (tool)
  39. NOTES (legacy) (tool)
  40. SHOW/HIDE GRIDLINES (view)
  41. FREEZE PANES (action)
  42. SPLIT PANES (action)
  43. ZOOM (view)
  44. PAGE LAYOUT (view/tool)
  45. PRINT AREA (print)
  46. PRINT TITLES (print)
  47. PAGE BREAK PREVIEW (view)
  48. EXPORT TO PDF (action)
  49. SAVE AS (Ctrl+Shift+S) (shortcut)
  50. AUTOSAVE (feature)
  51. RECOVER UNSAVED WORKBOOKS (feature)
  52. VERSION HISTORY (feature)
  53. ICON SETS (conditional formatting)
  54. COLOR SCALES (conditional formatting)
  55. DATA BARS (conditional formatting)
  56. FORMULA AUDIT TOOLS (tool)
  57. TRACE PRECEDENTS (tool)
  58. TRACE DEPENDENTS (tool)
  1. GO TO (F5) (shortcut)
  2. FIND (Ctrl+F) (shortcut)
  3. REPLACE (Ctrl+H) (shortcut)
  4. QUICK ANALYSIS (tool)
  5. SPARKLINES (tool)
  6. INSERT SHAPE (action)
  7. SMARTART (tool)
  8. ICONS / 3D MODELS (visuals)
  9. HYPERLINK (Ctrl+K) (shortcut)
  10. CELL FORMATTING SHORTCUTS (Ctrl+B/I/U) (shortcuts)
  11. ALIGNMENT SHORTCUTS (shortcuts)
  12. MERGE & CENTER (action)
  13. WRAP TEXT (action)
  14. SHRINK TO FIT (format)
  15. COLUMN WIDTH / ROW HEIGHT (format)
  16. FORMAT PAINTER DOUBLE CLICK (tip)
  17. CTRL+C / CTRL+V (shortcuts)
  18. PASTE SPECIAL (tool)
  19. PASTE VALUES (action)
  20. PASTE FORMATS (action)
  21. PASTE TRANSPOSE (action)
  22. PASTE LINK (action)
  23. CLEAR CONTENT / FORMATS (action)
  24. INSERT ROW / COLUMN (action)
  25. DELETE ROW / COLUMN (action)
  26. MOVE / COPY SHEET (action)
  27. RENAME SHEET (action)
  28. COLOR SHEET TAB (UI)
  29. ZOOM SLIDER / STATUS BAR (UI)
  30. STATUS BAR CUSTOMIZE (UI)
  31. CTRL+1 (Format Cells) (shortcut)
  32. F2 (Edit Cell) (shortcut)
  33. F4 (Repeat / Toggle $) (shortcut)
  34. CTRL+D / CTRL+R (shortcuts)
  35. ALT+ENTER (Line Break) (shortcut)
  36. ALT+F1 / F11 (Charts) (shortcuts)
  37. CTRL+; / CTRL+SHIFT+; (Insert Date/Time)
  38. ALT+H+O+I (Auto-fit Column) (shortcut)
  39. ALT+H+O+A (Auto-fit Row) (shortcut)
  40. CTRL+K (Insert Link) (shortcut)
  41. CTRL+SHIFT+~ / $ / % / ^ / # (format shortcuts)
  42. CTRL+SHIFT+& / _ (border shortcuts)
  43. CTRL+9 / CTRL+0 (hide rows/columns)
  44. CTRL+SHIFT+9 / CTRL+SHIFT+0 (unhide rows/columns)
  45. ALT+A+M (Remove Duplicates) (shortcut)
  46. ALT+A+T (Text to Columns) (shortcut)
  47. ALT+N+V (Insert Pivot) (shortcut)
  48. ALT+F4 (Close Excel) (shortcut)
  49. CTRL+TAB (Switch Workbooks) (shortcut)
  50. CTRL+SHIFT+U (Formula Bar Expand) (shortcut)
  51. CTRL+ALT+F9 (Full Recalc) (shortcut)
  52. CTRL+` (Toggle Formulas) (shortcut)
  53. ALT+E+S+V (Legacy Paste Values) (legacy shortcut)
  54. ALT+= (Auto Sum) (shortcut)
  55. TABLE STRUCTURED REFERENCES (feature)
  56. PIVOT CACHE CONTROL (tip)
  57. POWER MAP (add-in/legacy)
  58. POWER VIEW (add-in/legacy)
  59. EXPORT TO POWER BI (integration)
  60. ANALYZE IN EXCEL (Power BI) (integration)
  61. SCHEDULER / AUTOMATION (Power Automate) (integration)
  62. BACKUP / VERSIONING (practice)
  63. DOCUMENTATION SHEET (practice)
© 2025 — 500 Real Excel Commands — concise list. Ads placed every 100 items.
```0
-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)