contador web Saltar al contenido

How to hide columns in Excel | Productivity

Excel lets you hide entire columns without permanently deleting them from the spreadsheet so that the user can observe data from distant cells. The feature can be useful for organizing information in the spreadsheet without losing information, having a better table view or for hiding data during printing, for example. Check out the following tutorial how to hide an Excel column, and then learn how to unhide a column that has been hidden.

How to fill blank cells automatically in Microsoft Excel

Hiding Excel columns can be useful for hiding information without losing data Photo: Divulgao / MicrosoftHiding Excel columns can be useful for hiding information without losing data Photo: Divulgao / Microsoft

Hiding Excel columns can be useful for hiding information without losing data Photo: Divulgao / Microsoft

Want to buy a cell phone, TV and other discounted products? Meet the Compare TechTudo

Step 1. To hide a column in Excel, select the desired column and right-click on it. Then in the context menu press the Hide option;

Hiding an entire spreadsheet column in Excel Photo: Reproduo / Rodrigo FernandesHiding an entire spreadsheet column in Excel Photo: Reproduo / Rodrigo Fernandes

Hiding an entire spreadsheet column in Excel Photo: Reproduo / Rodrigo Fernandes

Step 2. A double line will appear between the two adjacent columns, indicating that you have hidden a column at that position;

Excel symbolically indicates that there is a hidden column in the spreadsheet Photo: Reproduction / Rodrigo FernandesExcel symbolically indicates that there is a hidden column in the spreadsheet Photo: Reproduction / Rodrigo Fernandes

Excel symbolically indicates that there is a hidden column in the spreadsheet Photo: Reproduction / Rodrigo Fernandes

How to unhide hidden columns in Excel

To reactivate the column, right-click the double row and then select Unhide. She reappear immediately in the spreadsheet.

  You can reactivate a hidden Excel column anytime you want Photo: Reproduction / Rodrigo Fernandes  You can reactivate a hidden Excel column anytime you want Photo: Reproduction / Rodrigo Fernandes

You can reactivate a hidden Excel column anytime you want Photo: Reproduction / Rodrigo Fernandes

Ready. Take advantage of the tip to organize your Excel spreadsheets.

Is it possible to use a "Case" in Excel? Ask questions on the TechTudo forum.

How to customize an Excel spreadsheet

How to customize an Excel spreadsheet