Hide And Show On Googlesheet. Using automatic formulas in google sheets is more of a necessity than a choice when dealing with a large amount of data. And if the value in column a is show then show the row.
Right click the column you do not wish to see and select hide column again if you want to hide multiple columns hold your shift key down then click on the furthest column to the right that you want to be hidden. If cell contains hide hide the row. With the row s still highlighted right click anywhere.
The formula bar is a box right above the sheet and below the commands in google sheet.
Then go over to the number on the left of the row or top of the column right click it and select the hide option. Select the worksheet in which you want to hide the gridlines. Essentialy loop through all the sheets if the value in column a is hide hide the row. Now right click and choose to hide columns the numbers of the columns you selected will be shown in the dialogue.
