This option examines your file for hidden properties and personal details. Go to File and click on the Check for issue icon.You should employ Document Inspector in this case. If you want to check the entire workbook for hidden columns before searching for their location, the Go To Special functionality may not be the best option. The shortcut funs can just press the Alt + (semicolon) hotkey.Ĭheck how many hidden columns there are in a workbook You can do the same using this short path: F5>Special > Visible cells only. You will see the entire visible part of the table highlighted and the column borders adjacent to the hidden columns borders will become whitish. On the Go To Special dialog box, select the Visible cells only radio button and click OK.Click on the Find & Select icon and pick the Go to Special… option from the menu list.Open your workbook and navigate to the Home tab.Still there is one trick to help you locate hidden columns in Excel. However, it's not an option if your worksheet contains numerous, like more than 20, hidden columns. Of course, you can review the column letters.
![how to unhide a column in excel document how to unhide a column in excel document](https://i.ytimg.com/vi/trk1MIOynm8/hq720.jpg)
It can be rather difficult to find all hidden columns in a worksheet. Show all hidden columns in Excel via Go To Special That's it! This will show column A and leave the other columns hidden. Release the mouse cursor and go to Home > Format > Hide & Unhide > Unhide Columns.It means column A is selected though you don't see it. Drag your mouse pointer to the left until you see the border change its color.Now just drag the mouse pointer to the right to expand the hidden column A.Move the mouse cursor to the left until you see the double-sided arrow.Click on the header for column B to select it.
#How to unhide a column in excel document how to#
How to unhide the first column by expanding it You go to the Home > Cells group, and click Format > Hide & Unhide > Unhide Columns.Although you cannot see it, cell A1 is now selected.Enter A1 in the Reference: field and click OK. Press F5 or navigate to Home > Find & Select > Go To….Though there is nothing before column A to select, we could select cell A1 to unhide the first column. How to unhide column A using the Go To option Pick one of the tricks below to unhide only the first column in your table. Unhiding columns in Excel may seem easy until you have several hidden columns but need to display only the left-most one. Or you can right-click the selection and choose Unhide from the context menu, or just press the Unhide columns shortcut: Ctrl + Shift + 0 How to unhide first column in Excel Go to the Home tab > Cells group, and click Format > Hide & Unhide > Unhide columns.For example, to show hidden column B, select columns A and C. Select the columns to the left and right of the column you want to unhide.If you have an Excel table where multiple columns are hidden and want to show only some of them, follow the steps below. How to show hidden columns that you select
![how to unhide a column in excel document how to unhide a column in excel document](https://www.exceltip.com/wp-content/uploads/2019/08/31.png)
#How to unhide a column in excel document free#
If you don't know VBA too well, feel free to explore its possibilities by reading our article How to insert and run macros.
![how to unhide a column in excel document how to unhide a column in excel document](https://i.ytimg.com/vi/lFdU9lDacSs/maxresdefault.jpg)
Whether you have one or several hidden columns in your table, you can easily display them all at once using the Excel Unhide option.
![how to unhide a column in excel document how to unhide a column in excel document](https://www.germanpearls.com/wp-content/uploads/2016/10/17oct2016_how-to-hide-and-unhide-columns-in-excel_1-1024x545.png)