Sometimes you'll want to temporarily remove columns or rows but you don't want to permanently delete them. In these cases you can use the hide function.

To hide columns, just select the columns you want to hide, right click on one of the selected columns and click Hide.

If you look at the column letters, you'll notice that the columns seem to skip over a few letters where the hidden columns used to be. That's OK. In fact, that's one of the ways you can tell that there are hidden columns in the worksheet.

You can hide rows in the same manner. Just select the rows you want to hide, right click on one of the rows and click hide.

To show hidden rows in your worksheet, select the rows on either side of the hidden row. Right click on the row and select show.

The same process applies for showing hidden columns. Select the column of either side of the hidden column and select show.