#Hide columns in excel how to#

In case the workbook is not saved already, Excel would first force you to save it. Note that you need to save this workbook before running the Document Inspector option. The above steps would delete all the hidden rows and columns in the workbook. You will see that it shows the total number of hidden rows and columns that it has found in the workbook. Scroll down to the вЂHidden Rows and ColumnsвЂ™ option.This will inspect the entire workbook and give you the information about the workbook In the вЂDocument InspectorвЂ™ dialog box, click on the вЂInspectвЂ™ button.This will open the Document Inspector dialog box Click on the вЂInspect DocumentвЂ™ option.In the options on the left, click on вЂInfoвЂ™.Remember that it is going to remove these hidden rows and columns from the entire workbook and not from the active sheet only.Д«elow are the steps to delete all the hidden rows and columns from the workbook in Excel: If you want to delete all the hidden rows and columns in an entire workbook in Excel, you can use the method shown here. Delete Hidden Rows and Columns using VBAДelete All Hidden Rows and Columns in Excel.Delete All Hidden Rows and Columns in Excel.Similarly, you may hide or unhide the selected rows by using respective menu options. Note: By clicking on the вЂњHide SheetвЂќ option, the current worksheet will hide. Open its menu and click on the вЂњ Hide ColumnsвЂќ option. Under the вЂњ VisibilityвЂќ you can see вЂњ Hide & UnhideвЂќ. Locate the вЂњCellsвЂќ group and there you can see the вЂњ FormatвЂќ button along with others as shown below: Select the column you want to hide by clicking on the column head e.g.

#Hide columns in excel how to#

I will show you how to hide the column while the process of hiding row remains the same as in the above examples. This is how you may hide the column, rows, and even the worksheet by using the main menu in the ribbon. You may double click or drag the lower line to unhide a row. Similarly, the hidden row border is thicker that indicates the hidden row. You may also unhide the hidden column by double-clicking the double line or drag the line towards the right. If you look closer at the column lines after hiding a column, you will notice those are double lines and look a little thick than normal columns. Right click on the C or F column and click on the вЂњUnhideвЂќ menu option as shown below: In our first example, we have hidden the D column. Select any of the adjacent columns of the hidden column. Follow this to unhide the hidden row or column. To unhide the hidden column or row, the procedure is simple and alike. Right click on any of the selected row numbers or their cells and press the вЂњHideвЂќ option. Press the Ctrl key and select other row(s) that you want to hide. Just like hiding multiple columns that are not adjacent, for hiding multiple non-adjacent rows, select a row by clicking on the row number.

Hiding multiple rows that are not adjacent The result of this is hidden sixth row is as shown below: Right click on the row number or any cell of that row and click on the Hide option in the menu as we did to hide a column. Suppose, we want to hide the row number 6 in our demo: Select a row by clicking on the row number. Right click on any of the cell of column B or D and press Hideoption as shown in the first example. This is how columns B and D look after we selected: If you want to hide more columns then keep pressed the Ctrl key and select those columns. Press the Ctrl key in the keyboard and select the column вЂњDвЂќ. Select the B column by clicking on the letter вЂњBвЂќ. Suppose we want to hide the columns B and D. However, if you want to hide two or more columns that are not adjacent by a single click, follow this. Hiding multiple columns by single click exampleД«y following the above method, you may hide as many columns as you want one by one. You can see, the D column is disappeared. For our demo, I selected the D column and clicked on the Hide option in the menu, after right clicking on a cell and see the result:

Now, right-click on any cell of that column and click on the вЂњ HideвЂќ option in the menu: It should select the whole column as shown below:

Select the column that you want to hide by clicking on the letter: A, B, C etc. Similarly, to unhide the hidden row or column, you need to press the Unhide menu item after right-clicking on the adjacent row or column I will show you how with screenshots in the section below.ДЇor hiding one column in Excel, follow these steps. Hiding the rows or columns in Excel is just the matter of right clicking on the column letter or row number and pressing the Hide option in the menu.