Google Sheets have simplified our lives in so many different and unique ways. From tracking your personal expenses to creating a collaborative work, Google Sheets has made a huge impact. But after using Google Sheet for a long period of time, or when a particular sheet is processing a large amount of data, you may find Google Sheet to be much less responsive or laggy. In this article, we discuss 10 very easy ways to speed up slow Google Sheet.
Workarounds -
1. Close the browser. Then restart the browser. Open the Google Sheet and see if this works.
2. Delete the cell content, and then copy and paste the cell content from a cell above or below. This is when you have a column where each cell calculates a value for you. You can copy and paste the value from the cell above and all reference values will be adjusted automatically.
If that doesn't work, you're up the drain without a paddle afaik.
Fix 1 : Clear browsing data
Large browser cache is one of the reasons behind this problem.
1. Open Google Chrome .
2. On the Google Chrome screen, simply tap the three-dot menu at the top-right corner and click " Help ".
3. Then click on " Clear browsing data ".
3. Here you need to expand the ' Period: ' drop-down option .
4. Select " Total Time " from the drop-down list.
5. Next , tick the " Browsing history " and then " Cookies and other website data " and finally check the box next to " Cached images and files ".
6. Then click " Clear Data " to clear cache of websites.
Wait a while. Then follow these steps to disable the extensions.
1. Open Google Chrome on your computer.
2. Then click the three-bar menu in the right corner and click More
."
Tools> ". Then click on " Extensions ".
3. Now you will see the list of installed extensions in Google Chrome.
4. Just toggle all extensions to " Off ". Make sure all extensions are disabled.
(Also, you can easily "remove" these extensions by clicking " Remove ".)
Then open the Google Sheet on your computer and check the loading speed.
Fix 2 : Remove the unused columns
By default, Google Sheets contain a large number of cells. This can make it bulky and slow to use.
1. Open the Google Sheet on your computer.
2. Click on the first empty row from the list and then select any unused columns (or rows) up to the edge of the Google Sheet.
3. Then right click on the selected columns and click " Delete Column DZ ".
(Example- you only use columns " A ", " B " and " C " in Google spreadsheet.
So you can delete all extra rows *(from column " D " to " Z ") from the worksheet. )
When you're done, check the Google Sheet. Try scrolling down and checking the speed. This should speed up the loading time significantly.
Fix 3 : Remove unused rows
Remove the unused rows from your Google Sheet.
1. Open the Google Sheet on your computer.
2. Here scroll down and click on the first blank row and scroll down to " 1000 " to select all blank rows at once.
3. Then right click on the selected rows and click " Delete rows 140-1000 ".
(Suppose you use rows 1-140. So you can delete the rest of the abundant rows from the sheet that you don't use.)
After deleting the leaves, check if the speed is given in the google spreadsheet. Something should improve.
Fix 4 : Avoid calculation methods
Chaining calculations is common, but it can consume a large amount of system resources. So convert formulas to static values.
1. Open the Google spreadsheet.
2. Serve, select all the cells which uses the calculation chains, and click " Copy " to copy the data in them.
3. Next, right click the selected cells and choose " Paste Special > ".
4. Finally, click on " Paste values only ".
This will replace the selected cell formulas with the static values. Google spreadsheet doesn't use the resources to calculate every single cell in this process and is faster to load and operate.
Fix 5 : Use limited range in cells
If you use unlimited or high range in the formulas in Google spreadsheet, it will consume more resources than usual and slow down the spreadsheet.
Here are some tips you can follow-
1. Try to be specific about the rows/columns you use instead of using the entire column. This small tweak reduces the process significantly.
example -
Suppose you have 2000 data entries in column B. Instead of using the range for the entire column " B ", you can specify the specific range.
For example, if you want to perform an operation on a specific range - write " B1-B2000 " instead of " B:B ".
2. Try to use built-in formulas instead of creating large chains of formulas.
example -
The processing time for =AVERAGE(A1:A100 ) is much faster than =SUM((A1:A100)/100 ).
Fix 6 : Use conditional formatting only when necessary
Conditional formatting is a great tool to present or present the sheet for better representativeness. But at the same time, it eats up a huge resource for a continuous data entry process.
We recommend making a copy of the original spreadsheet you are working on. Then proceed to remove conditional formatting.
1. First, select the specific row or column with conditional formatting.
2. Then right click on the selected rows/columns and further click " Conditional Formatting ".
3. On the right side, you will see the list of conditional formatting you have set for each cell.
4. Just click on the " Trash icon " next to the conditional formatting to remove it.
This will disable conditional formatting and increase the working speed of the entire Google Sheet.
Fix 7 : Avoid using volatile functions
Volatile functions are functions that recalculate all cell values associated with the process each time a specific value in the Google spreadsheet changes.
We advise you not to use these special features in Google spreadsheet unless it is necessary-
a. NOW
b. TODAY
C. RAND
i.e. EDGE BETWEEN
Using any of these functions in the spreadsheet will slow down the google spreadsheet significantly, especially when you are working with a large amount of data on the spreadsheet.
Also, using these volatile functions along with conditional formatting slows down Google Sheet more than usual.
Fix 8 : Use nearer/narrower references
Linking to other workbooks from your current Google Sheet is a very useful feature. However, using many references can reduce the loading time of the Google Sheet. You can fix this problem by referencing the workbook that is near the sheet instead of referencing a workbook that is farther away.
Instead, if you want to reference the far away workbook, you can copy and paste the data from the workbook into a closer workbook and then reference it from there.
Fix 9-Befehl "=IF()" verwenden
The "If" command is very useful to avoid using complex formulas over and over again, which can consume a huge amount of resources and slow down the Google spreadsheet operation.
The syntax of the " =If() " command is as follows -
“=if(*conditional statement*, *what to do if the condition is true*, *what to do if the condition is false*)”.The command
" =If() " can waste a lot of resource overhead when you calculate data from another workbook in your Google Sheet. Using it on the same sheet might not be useful at all.
Fix10 : Split large google sheets
Even after applying all these fixes, if the Google Sheet still slows down badly, you still need to split the massive datasheet into two or more parts. This allows the sheet to handle less data in a sheet alone.
If you follow these simple tips, the Google Sheet will be much faster.
แสดงความคิดเห็น