Shortcuts to hide/unhide rows and columns

To hide columns, use Control + 0. you might also work with multiple columns at the same time.

To unhide columns again, make a selection that spans the hidden columns, and use Control Shift 0.

To hide rows, use Control + 9.

Again, you’ll see a visual indication in row numbers to indicate that rows are hidden.

To unhide rows again, make a selection that spans hidden rows, and use Control Shift 9.

So for example, I can hide every other column in this table.

Or, every other row.

Finally, you could hide extra rows and columns to focus attention on just the work area.

Now go to the last cell again, move a couple columns to the right.

Then opt for entire column, then all columns to the right, and then hide.