Microsoft Excel Tutorial: A new Check Performance Feature debuts in Excel to clean excess cell formatting that can cause large file sizes.
Welcome to episode 2632 of MrExcel's Net Cast! In this video, we'll be discussing a new feature in the Windows version of Excel that has been available in Excel online for some time now. It's called Check Performance and it can help you clean up unwanted cell formats and reduce file sizes. This feature can be found on the Review tab and is definitely worth checking out for any workbook that you've been using for years.
Now, before you go ahead and click "optimize all", it's important to take a look at what Check Performance has found. It looks for excess formatting, unused cell styles, and unneeded metadata that can slow down your workbook. While it may be tempting to get rid of everything, it's important to be cautious as there may be some formatting that you actually want to keep. For example, if you have a tooltip cell or if you're using pixel art, Check Performance may not be able to detect it and could potentially delete it. However, the good news is that the undo button can bring back any unintentionally deleted formatting.
In this video, we'll also be discussing a potential issue with Check Performance that was discovered while filming. It seems that in some cases, the feature may not work perfectly and could potentially delete intentional formatting. So, while it can be a useful tool for cleaning up excess styles and formats, it's important to be careful and double check before using it. As always, if you have any questions or comments, please feel free to leave them down below and don't forget to like, subscribe, and ring the bell for more helpful Excel tips and tricks. Thank you for watching and we'll see you in the next episode of MrExcel's Net Cast!
Buy Bill Jelen's latest Excel book: www.mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: www.mrexcel.com/like-mrexcel-...
To download the workbook from today: www.mrexcel.com/youtube/a338W...
Table of Contents
(00:00) Check Performance debuts in Excel
(00:13) On the Review tab
(00:23) Excess formatting, cell styles, and metadata that can slow your workbook down
(00:48) Identifies useful cells that appear blank
(01:06) Do not use with pixel art
(01:20) Undo works
(01:36) Row Height is there on purpose
(02:04) Undo after Row Height left images in wrong spot
(02:20) Useful but be careful
(02:30) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #excelnew #excelperformance
This video answers these common search terms:
how to improve performance on excel
excel is slow how to fix
how to fix a slow excel
how to fix excel slowness
how to get rid of excess formats in excel
Join the MrExcel Message Board discussion about this video at www.mrexcel.com/board/threads...
14 июл 2024
