Excel 2013 has a feature called “Live Preview” which will show a preview of a formatting change while you are hovering over an option. This is helpful when you need to make an adjustment, but you want to see it before you actually make the change.
The “Live Preview” feature can be problematic for some users, however, and the benefit that it provides can be outweighed by the confusion or performance declines that it causes. Our guide below will show you what setting you need to adjust in order to disable the “Live Preview” feature in Excel 2013.
Disabling Live Preview in Excel 2013
The steps in this article will assume that the Live Preview setting is currently enabled in Excel 2013. This is the feature where Excel will show you how a formatting change will affect your workbook while you are hovering over that setting. Turning off Live Preview will make it so that this preview stops occurring, and you will only see the change once you have made it.
Here is how to disable the Live Preview in Excel 2013 –
- Open Excel 2013.
- Click the File tab.
- Click Options in the left column.
- Click the box to the left of Enable Live Preview to clear the check mark. Click the OK button at the bottom of the window to save and apply your changes.
These same steps are shown below with pictures –
Step 1: Open Microsoft Excel 2013.
Step 2: Click the File tab at the top-left corner of the window.
Step 3: Click the Options button at the bottom of the column on the left side of the window.
Step 4: Click the box to the left of Enable Live Preview to remove the check mark. You can then click the OK button at the bottom of the Excel Options window to close the window and apply your changes.
Do you have multiple cells in a spreadsheet that you need to modify, but those cells are apart from one another? Learn how to select non-adjacent cells in Excel 2013 to apply the same change to non-contiguous cells.