Excel Tip: Disable Cell Selection Animation in Excel 2016

If the animation for cell selection bothers you (or seems to be too slow..) you can easily turn it off under Excel Options (File>Options) as below:

Created by DoMyExcel.com © | Excel & VBA Consulting | Customized Excel Solutions starting at 29 USD

Services provided to Individuals and Businesses | Free Quote: DoMyExcel@gmail.com

How to highlight or hide error cells in an Excel pivot table

If you'd like not to show the error in a pivot table, simply go to the options and replace error by nothing:

Created by DoMyExcel.com © | Excel & VBA Consulting | Customized Excel Solutions starting at 29 USD

Services provided to Individuals and Businesses | Free Quote: DoMyExcel@gmail.com