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 / 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 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 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
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