You can hide a row or column by using the Hide command, or by changing the row height or column width to 0 (zero). You can display either again by using the Unhide command. You can unhide specific rows and columns, or you can unhide all hidden rows and columns at the same time. If you hide the first row or column in a worksheet, you follow a different process, and you'll find that in the last section of the article.
Hide or unhide columns in your spreadsheet to show just the data that you need to see or print.
Select one or more columns, and then press Ctrl to select additional columns that aren't adjacent.
Right-click the selected columns, and then select Hide.
Note: The double line between two columns is an indicator that you've hidden a column.
Select the adjacent columns for the hidden columns.
Right-click the selected columns, and then select Unhide.
Or double-click the double line between the two columns where hidden columns exist.