Choosing “Delete columns” (yellow arrow).Select all the unused columns (or rows) at the edge of the Sheet.You can clear cells through a variety of means, but one of the easiest and fastest is: While these cells don’t add any information for a person viewing the sheet, they take up space in the program’s memory. If you’ve moved a lot of data around in your spreadsheet, you’ve likely accumulated a lot of blank cells. If you are still experiencing performance issues in Google Sheets, it is now safe to presume the problem is within Sheets itself. You can turn off individual add-ons in the “Extensions” menu by tapping or clicking the slider.You can do this in most browsers simply by opening the Sheet in an “incognito window.” If the Sheet runs correctly in “incognito” mode, you can disable add-ons until you find the guilty party. You can also try disabling browser add-ons/extensions. Other popular browsers also use similar steps to clear the cache. If restarting doesn’t work, you can try clearing the browser cache. The simple act of restarting clears countless potential slow-performance causes without needing to do any investigation into the issue. If you’re still experiencing the issue, the next thing to try is rebooting or restarting the computer or other device you’re using. On the lowest-level, completely close out of your web browser (or the Google Sheets app) and restart the program. When you’re experiencing slow performance in Google Sheets, the first thing you should do is make sure Google Sheets is responsible for the problem. Use “=IF()” to avoid unnecessary formula calculations.Avoid Functions that Require Recalculating the Entire Sheet on any Change.Only Use Conditional Formatting when Necessary.
Avoid Calculation Chaining by Converting Formula Cells to Static Values.