Google Sheets is an excellent alternative to Microsoft Excel.

Some of us even feel it is better.

It is much more intuitive.

Article image

Things are easier to find and do without always having to stop to look things up.

This is true of nearly all software, no matter who the manufacturer may be.

Regardless of your situation, fear not well help you out today.

Hide a Row in Google Sheets

Now, right-click and choose toHide rows.

you’re able to hit these arrows to unhide your rows.

Now, lets focus on how to hide a column in Google Sheets.

Arrows for hidden rows in Google Sheets

To hide a column, follow the same process.

Right-hit the column you do not wish to see, and selectHide column.

Now, right-click and choose toHide columns.

The step to hide a column in Google Sheets

Again, Google will leave behind markers showing and reminding you that there should be another column there.

The things you have hidden have not disappeared.

Like when hiding rows, you might unhide columns by clicking on the arrow.

Arrows for Hidden Columns Google Sheets

Can You Hide and Unhide Columns in Google Sheets on Mobile?

But did you also know that its possible to do so from your smartphone or tablet?

The process is incredibly straightforward.

Hide a Column in Google Sheets on Mobile

First, highlight the column(s) or row(s) that you want to hide.

An easy way to select your columns is by tapping on the letter at the top.

To pick multiple columns, drag your finger across to them.

Arrow to unhide a column in Google Sheets

This will then reveal the column that previously hid in that place.

Anything that you typed in that column beforehand will still be there when it becomes visible again.

Is There a Way to Hide Only Specific Columns or Rows?

Its very easy to only hide specific columns in the middle of your document.

When you drag a column to the left, its technically not fully hidden.

Thus, you wont see an unhide command when clicking on it.

To make that column visible again, drag it to the right and it should expand.

Its incredibly helpful for displaying information more easily, and youve got a good selection of customization options available.

Moreover, when you run into those problems, theyre normally quite simple to resolve.

you could also perform the actions listed today on each of your smartphone, tablet, and computer.