Google Sheets Show Hidden Columns

Built in formulas pivot tables and conditional formatting options save time and simplify common spreadsheet tasks. Make it count google sheets makes your data pop with colorful charts and graphs. How to manipulate rows and columns in google sheets.

I ve written about these before and will showcase them again here. Anyways now that you know how to hide columns and rows within google sheets there are a few other sheets tips to show you to increase your proficiency. On libreoffice you can click on the first header to mark all columns and rows and than click on format row column show.

Well on google docs you have little mark to click on and expand hidden colums. To hide a column right click on the column letter at the top of the spreadsheet and choose hide column. Hide columns in a google spreadsheet.

To unhide rows click the arrow icon that appears over the hidden row numbers. Then right click and select hide rows x x where x indicates the numbers of the rows you have selected. Simple double click this arrow to make the hidden items appear again.

For example if you chose to hide columns b through f the two arrows would appear between a and g. Within google sheets any of your hidden columns and rows will be represented by arrows that link between the start and end of the hidden items. You can see that a column or row for that matter is hidden in google sheets because the labeled column will be missing it will skip from b to e for.

How to unhide columns in google sheets. Clicking on these arrows will expose the column and return. Your column will then disappear from view with arrows appearing in the column headers on either side of your hidden column.

To hide a column right click the column header for your chosen column. Hide google sheets columns. 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.

Magically the things you had hidden are now restored. To unhide a row or column in sheets simply click the arrows left behind as shown in the screenshots above. Unhiding rows and columns in google sheets.

The things you have hidden have not disappeared the information is still there so let us unhide it now.