How to hide columns in Excel?

Anna Piskunova
Anna Piskunova
May 7, 2015
How to hide columns in Excel?

Data in Excel spreadsheets can be contained in rows and columns. Sometimes you can hide insignificant information to optimize the presentation of this data. Let's figure out how to hide columns in Excel.

It should be remembered that the implementation of actions in spreadsheets is possible only with active objects. For example, to activate customization actions with columns, you should left-click on the column header.

Method 1

  1. Highlight a column by clicking on its column.
  2. Find its right border and connect it to the left.

The result of your actions will be a hidden column, and at first glance it may seem that it is deleted, and its data is lost. But if you do the reverse actions, you will understand that everything is safe and sound.

Method 2

  1. Highlight a column by clicking on its column.
  2. Click Format → Column → Hide.

To return columns, highlight the range in which the column entered and click Format → Column → Show.

Thus, by hiding several columns, but at the same time saving the information stored in them, you can optimize the space occupied by the spreadsheet and, if necessary, further highlight the data that were hidden in the columns.