This resolution is suggested in the Microsoft Knowledge Base article.
How to unhide a column in excel windows 10#
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. If you want to unhide all hidden columns on an Excel spreadsheet, click on the Select All button, which is the blank rectangle to the left of column A and above row 1. These shortcut keys are in the below table: Shortcut Key Tips If some columns are still not visible after you’ve attempted to unhide the columns, the width of the columns may be set to 0 or another small value. 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.
![how to unhide a column in excel how to unhide a column in excel](https://support.content.office.net/en-us/media/4304dd04-ccb2-45f1-97bc-bf3070947634.png)
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.
![how to unhide a column in excel how to unhide a column in excel](https://www.dummies.com/wp-content/uploads/205980.image0.jpg)
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.