Excel slows down for one core reason: it is doing more work than your hardware can handle at that moment. The fix is not always buying a new computer. Most of the time, the problem is inside the file itself.
Before doing anything else, check the file size. Press Ctrl + End to jump to the last used cell. If it lands somewhere unexpected, like row 50,000 when your data ends at row 500, you have ghost data bloating the file. That one issue alone can make Excel crawl.
Best Ways to Fix Slow Excel Performance: The Core Fixes
1. Switch Calculation Mode to Manual
This is the fastest win. By default, Excel recalculates every formula every time you type anything. On large files, that kills speed.
Go to Formulas > Calculation Options > Manual. Now Excel only calculates when you press F9. Switch back to Automatic when you are done editing.
This single change can make a file feel instantly faster.
2. Delete Unused Rows and Columns
Excel reserves memory for every cell it thinks you are using. If you once accidentally pressed Ctrl + End and it went to row 1,048,576, Excel is holding all of that in memory.
How to clean it:
- Press Ctrl + End to find the last used cell
- Select every row below your actual data
- Right-click and choose Delete (not just clear contents)
- Do the same for columns to the right of your data
- Save the file
This can shrink file sizes dramatically and speed up scrolling and calculation.
3. Replace Volatile Formulas
Volatile formulas recalculate every single time anything changes in the workbook, even if they have nothing to do with the changed cell.
The most common volatile functions:
| Volatile Function | What It Does | Better Alternative |
|---|---|---|
| NOW() | Returns current date and time | Hard-code the date if it does not need to update |
| TODAY() | Returns today’s date | Same as above |
| RAND() / RANDBETWEEN() | Random number | Use a static value if randomness is not needed |
| OFFSET() | Dynamic range reference | INDEX + MATCH or XLOOKUP |
| INDIRECT() | Dynamic cell reference | Direct cell reference where possible |
If you must use them, limit how many you have. Five INDIRECT() calls might be fine. Five hundred will wreck performance.
4. Reduce the Use of Array Formulas
Old-style array formulas entered with Ctrl + Shift + Enter are heavy on memory. If you are on Excel 365 or Excel 2021, modern dynamic array functions like FILTER(), SORT(), and UNIQUE() are far more efficient.
If you are stuck on an older version, try to limit array formula ranges to only what is needed. An array formula across 10,000 rows when you have 200 rows of data is wasteful.
5. Avoid Referencing Entire Columns
This is extremely common and extremely costly.
Instead of:
=VLOOKUP(A2, B:B, 1, 0)
Use:
=VLOOKUP(A2, B2:B5000, 1, 0)
When you reference an entire column, Excel processes over a million cells. When you reference a defined range, it processes only what you specified. On large files, this difference is enormous.
6. Convert Formulas to Values Where Possible
If a formula’s result never needs to change, convert it to a value.
Select the cells, copy them (Ctrl + C), then Paste Special > Values Only (Alt + E + S + V + Enter). The formula disappears, the value stays, and Excel no longer needs to recalculate it.
Do this for lookup results, imported data, or anything that was calculated once and is now static.
Formatting and Visual Fixes
7. Remove Excessive Conditional Formatting
Conditional formatting is one of the biggest hidden performance killers. The problem compounds when you copy and paste cells because Excel adds new rules on top of existing ones silently.
Go to Home > Conditional Formatting > Manage Rules and select “This Worksheet” from the dropdown. You may find hundreds of duplicate or overlapping rules. Delete the ones you do not need.
Also avoid applying conditional formatting to entire columns. Apply it only to the rows that contain data.
8. Reduce the Number of Unique Fonts and Cell Styles
Every unique font, size, color, border, and fill style adds to the file’s complexity. Excel stores each combination as a separate style.
Keep formatting consistent. Use one or two fonts across the file. Avoid manually formatting individual cells in unpredictable ways.
9. Delete Unnecessary Charts and Images
Charts, logos, and inserted images are stored inside the Excel file and increase load time. They also force Excel to render them every time the sheet redraws.
If you have embedded images or charts that are not essential, delete them. If you need them, consider moving them to a separate sheet so they do not render during normal data work.
Data Structure Fixes
10. Avoid Merging Cells
Merged cells look clean but break Excel’s internal optimization. They slow down sorting, filtering, and formula resolution. They also cause errors when you try to copy and paste data.
Use Center Across Selection instead (Format Cells > Alignment > Horizontal > Center Across Selection). It looks identical but does not merge.
11. Use Excel Tables Instead of Plain Ranges
Structured tables (created with Ctrl + T) are more memory-efficient than plain cell ranges for large datasets. They also auto-expand, so you do not need to manually update formula ranges when new rows come in.
Tables also work well with Power Query, which leads to the next point.
12. Use Power Query for Large Data Transformations
If you are manipulating thousands of rows with formulas and helper columns, Power Query is a better tool. It loads and transforms data outside the main calculation engine and only returns a clean result to the sheet.
This is especially useful for data you import from external sources regularly. According to Microsoft’s own documentation on Excel performance optimization, using Power Query reduces the in-memory load on the workbook calculation engine significantly.
13. Split Large Files Into Smaller Ones
If a single workbook has 15 sheets all connected by formulas, every calculation cascades across all of them. Breaking the file into separate workbooks that link only when needed reduces the calculation chain length.
A good rule: if your file is over 20 MB with mostly data and formulas (not embedded media), it is probably doing too much in one place.
System and Excel Settings Fixes
14. Enable Multi-Threaded Calculation
Excel can use multiple processor cores to calculate formulas in parallel. Make sure this is on.
Go to File > Options > Advanced > Formulas, then check “Enable multi-threaded calculation” and select “Use all processors on this computer.”
This is enabled by default in most installations, but it can get turned off after updates or on older machines.
15. Increase Virtual Memory (Windows)
If Excel is consistently slow even after file cleanup, your system may be low on available RAM. Windows uses virtual memory (pagefile) as overflow.
Go to Control Panel > System > Advanced System Settings > Performance Settings > Advanced > Virtual Memory. Set it to at least 1.5x your physical RAM. This helps on machines with 8 GB or less RAM.
16. Disable Add-Ins You Are Not Using
Every active add-in loads into memory when Excel starts. Some add-ins also hook into calculation events and slow things down invisibly.
Go to File > Options > Add-Ins, select “COM Add-ins” from the dropdown, click Go, and uncheck anything you do not use.
17. Repair the Excel Installation
Sometimes Excel itself is the problem. Corrupted installation files can cause sluggish behavior that has nothing to do with your file.
On Windows: Go to Control Panel > Programs > Microsoft Office > Change > Quick Repair. If that does not help, run Online Repair.
How to Identify What Is Slowing Down Your File
Use the Inquire Add-In (available in Excel 365 and Excel 2019 Professional Plus). It shows:
- Formula dependency chains
- Circular references
- Worksheet relationships
Another useful technique is to turn off all add-ins, close all other applications, and test calculation speed with F9. If the file calculates fast in isolation, the problem is resource contention from other programs.
Fixes by Impact
| Fix | Effort | Speed Impact |
|---|---|---|
| Switch to Manual Calculation | Very Low | Very High |
| Delete ghost rows/columns | Low | High |
| Remove volatile functions | Medium | High |
| Fix whole-column references | Medium | High |
| Convert formulas to values | Low | Medium-High |
| Clean conditional formatting | Low | Medium |
| Enable multi-threading | Very Low | Medium |
| Use Power Query | High | High (for large data) |
| Split large workbooks | High | High |
| Remove add-ins | Very Low | Low-Medium |
A Practical Order of Operations
If you are dealing with a slow file right now and do not know where to start, follow this sequence:
- Press Ctrl + End and check where the last used cell is
- Switch calculation to Manual mode immediately
- Delete all rows and columns below and to the right of your actual data
- Open Conditional Formatting Manager and delete duplicate rules
- Search for INDIRECT, OFFSET, and VOLATILE functions using Ctrl + F
- Replace whole-column formula references with specific ranges
- Convert any static formula results to values
- Save, close, and reopen the file to see the new file size
- Switch calculation back to Automatic and test speed
- If still slow, check add-ins and consider splitting the workbook
Most files improve significantly after steps 1 through 4 alone.
Conclusion
Slow Excel performance almost always has a fixable cause. The most impactful fixes are switching to manual calculation mode, deleting ghost rows and columns, eliminating volatile functions, and cleaning up conditional formatting. These four steps alone solve the problem in the majority of cases.
Bigger structural fixes like using Power Query, splitting workbooks, and converting formula ranges to explicit boundaries matter more as files grow in complexity. For most everyday users, the quick wins above will give you a noticeably faster spreadsheet within minutes.
Frequently Asked Questions
Why does Excel slow down when I scroll even if there are no formulas?
Scrolling lag is usually caused by conditional formatting applied to thousands of rows, large images or charts embedded in the sheet, or excessive cell styles. Check your conditional formatting rules first and reduce their range to only your data area. Also check if there are images behind other content that you cannot see but Excel is still rendering.
How do I know if a formula is volatile?
The most common volatile functions are NOW(), TODAY(), RAND(), RANDBETWEEN(), OFFSET(), INDIRECT(), and INFO(). You can press Ctrl + F and search for each of these in the workbook. If you find hundreds of them, that is likely a major contributor to slowness. VBA functions can also be volatile if they are written without the Application.Volatile False declaration.
Does file format affect Excel performance?
Yes. The .xlsb format (Excel Binary Workbook) opens and saves faster than .xlsx for very large files because it stores data in a compressed binary format rather than XML. If you have a file above 10 MB and do not need it to be human-readable outside Excel, saving as .xlsb can meaningfully improve performance. Note that .xlsb has some compatibility limitations with external tools.
Can too many named ranges slow down Excel?
Yes, but only in large quantities. A few dozen named ranges have no noticeable impact. Thousands of named ranges, especially those created automatically by features like the Name Manager or old macros, can slow down the calculation engine and increase file size. Go to Formulas > Name Manager and delete any named ranges that are no longer used or reference invalid cells (shown as #REF!).
Why does my Excel file get slower over time even if I do not add much data?
This is usually caused by accumulating conditional formatting rules from copy-paste operations, growing numbers of named ranges, increased formula dependencies, or add-in data that builds up in hidden sheets. It can also happen when Excel’s calculation chain grows complex as you add more interconnected formulas. Periodic cleanup using the steps in this article every few months keeps files running well.
