Microsoft Excel includes a graphical feature known as “Live Preview.” Whenever you highlight a massive block of cells and hover your mouse over a font color, a new text size, or a complex conditional formatting rule in the top ribbon, Excel instantly renders a temporary preview of those changes across all the selected cells. The moment you move your mouse away, the preview vanishes.
While this is incredibly helpful for choosing the perfect shade of blue for a pie chart, it is a catastrophic performance killer when working with massive, enterprise-level datasets. If you highlight 100,000 rows of complex financial data and accidentally drag your mouse pointer across the “Cell Styles” gallery, Excel will attempt to instantly recalculate and render 100,000 graphical changes simultaneously. On older laptops or virtual machines, this single accidental mouse movement will instantly freeze the application, peg the CPU to 100%, and often cause Excel to crash completely, wiping out any unsaved progress. To guarantee that Excel remains rock-solid and never wastes processing power rendering temporary graphical changes, you must completely disable Live Preview.
Disabling Live Preview via Excel Options
You can instantly kill the dynamic rendering engine directly from the application’s core settings menu.
- Open the Microsoft Excel desktop application.
- Bypass the Start Screen by clicking Blank workbook to enter the main editing interface.
- Look at the main menu ribbon at the top of the screen and click on File (in the top-left corner).
- Scroll to the absolute bottom of the left-hand blue sidebar and click on Options.
- A new Options window will appear. In the left-hand menu, click on General (this should be selected by default).
- Look under the “User Interface options” section at the very top of the main panel.
- Locate the checkbox labelled Enable Live Preview.
- Completely uncheck this box.
- Click OK at the bottom of the window to save your changes.
The change takes effect instantly. You can now highlight entire massive spreadsheets and aggressively drag your mouse across every formatting option in the ribbon without fear. Excel will remain completely static and highly responsive, only applying the heavy graphical rendering calculations when you definitively click to confirm a formatting change.