Google Sheets Unhide Columns

To hide multiple columns click on the first column and drag across the columns you wish to hide or hold the shift key and click on the last row you want to hide.
Google sheets unhide columns. In this case select from the menu view freeze columns no frozen columns. To do that click on the first column letter a then press ctrl shift key multiple twice times. First and foremost select the entire columns. This way you can hide unhide columns in google sheets.
You can also see the row number will be missing as well. Google sheets displays small arrows on either side of a hidden column or row tap or click on those arrows to unhide the cells between the columns or rows indicated figure e. Your column will then disappear from view with arrows appearing in the column headers on either side of your hidden column. However if column b is frozen then this triangle will be disabled.
Magically the things you had hidden are now restored. Open the google sheet that has the hidden row. After that the triangle will be enabled again. Hide google sheets columns to hide a column right click the column header for your chosen column.
To unhide a row or column in sheets simply click the arrows left behind as shown in the screenshots above. Click the hidden worksheet that you want to unhide. If a row is missing you will see an arrow above and below the missing row in the grey number column to the left. How to unhide all the hidden columns in a flash in google sheets.
On google docs there s a small triangle in the column to the right in this case column b to unhide. Menu icon a vertical stack of three evenly spaced horizontal lines. Hide adjoining and distant rows. You can also unhide a sheet by clicking the view tab at the top of the window.
In the menu that appears click the hide column button. The hidden sheets are a slightly lighter gray color than the visible ones. Then right click and select unhide columns. Courtesy of this post.
You can easily unhide columns in google sheets on a desktop or mobile device either by clicking on the arrow or right clicking.