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.
#UNHIDE A COLUMN IN EXCEL 2013 HOW TO#
How to unhide the first column by expanding it
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
#UNHIDE A COLUMN IN EXCEL 2013 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.