Click on the header for column B to select it.
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
If you don't know VBA too well, feel free to explore its possibilities by reading our article How to insert and run macros.
First open the ‘Control Panel’, navigate to the ‘Change keyboards or other input methods’ link.The resolution of this issue is pretty obvious and that is changing the Keyboard Layout shortcut. So, the root of this problem is that whenever you press the column un-hiding shortcut key your OS gulps the keys and hence it interferes with the functionality of Microsoft Excel. This functionality probably assigns numbers to different layouts.
Microsoft Windows 8 and Windows 10 operating systems have assigned the ‘CTRL+SHIFT’ keys for Regional/ Language settings for changing the keyboard layouts. Many Windows 8 and Windows 10 users have reported that the shortcut key for un-hiding the hidden columns doesn’t work on their systems. Unhide Column or Rows shortcut keys not working? First, select one column on either side of the hidden column and then press the shortcut key. The procedure of using these shortcut keys is quite simple. Unhides the hidden columns within the selection. Unhides the hidden rows within the selection. These shortcut keys are in the below table: Shortcut Key Unhide Columns in Excel Using the ShortcutĪctually, Microsoft Excel has provided certain shortcut keys for hiding rows and columns in your spreadsheets. This will open a popup menu, select the ‘unhide’ option and the hidden columns will be visible.Now, with all these columns selected right-click on the column header.First of all select one column on either side of the hidden column.Follow the below steps to use this method: This is the easiest way to unhide columns in excel. Unhide Columns or Rows in Excel using a VBA script.Unhide Column or Rows shortcut keys not working?.Unhide Columns in Excel Using the Shortcut.Un-hiding Columns in Excel the Easy Way.