Regain faster performance with Excel 2013 (or newer versions) by turning off spreadsheet animation.
Excel 2013 and newer versions use animation to make cell movements, filling cells, and even recalculation look smooth and fluid. For example, with animation filling a column with numbers makes the numbers appear to flow down the column. With animation on recalculated cells show numbers flipping like the displays on slot machines.
Experienced Excel users can find this annoying and on some systems the animation seriously slows Excel operation.
It’s easy to turn off the animation and regain the speed. The appearance without animation is the same as it was in Excel prior to the use of animation, so I don’t even miss the difference. I’d rather have speed.
Alert: Turning off animation turns off user interface animation in all Office applications. This does not affect slide and object animation in PowerPoint slides.
To turn off Office animation in Excel using the Control Panel,
1. Open the Control Panel:
Windows 7: Click Start, then Control Panel.
Windows 8 or 10: Right-click Windows button, then choose Control Panel.
2. Choose either Ease of Use or Ease of Access depending upon your Windows version. This opens the Ease of Access Center.
3. Click Use the computer without a display.
Don’t worry, you will still have complete screen capabilities. This set of options optimizes the computer for the blind, but it also turns off unneeded animation.
4. Select the checkbox for Turn off all unnecessary animations (when possible).
5. Click Ok.
In Windows 10 you can turn this off more easily by,
1. Pressing Windows logo key + U to display Ease of Access in Settings.
2. Click Other Options at the bottom of the window.
3. Turn Off the slider for Play animations in Windows.
4. Close the Window.
If you want additional speed improvements in Excel and you run or write macros that change protected worksheets, then you can get significant speed improvements using Protect UserInterFaceOnly. Check out the article.