![microsoft excel unhide columns shortcut microsoft excel unhide columns shortcut](https://www.addintools.com/documents/excel/where-is-unhide-command/excel-unhide-command-menus-445-487.png)
This looks like the first method, but it is good to know all the methods to become a master.
![microsoft excel unhide columns shortcut microsoft excel unhide columns shortcut](https://cdn.wallstreetmojo.com/wp-content/uploads/2018/11/Unhide-Column-step-9.jpg)
Step 3: Once you click on this, it will unhide all the hidden columns. Step 2: Go to Home tab > Format > Hide & Unhide > Unhide Columns Step 1: Select the entire range you want to unhide. This method requires a lot of your time than the previous two methods. Unhide Columns in Excel Using Format Option Instead of unhiding columns, it will hide columns. Note: You can use Ctrl + 0 to unhide the columns, but this may not work in many operating systems. Step 3: This will unhide the hidden columns instantly. Step 2: Press the key board shortcut ALT + H + O + U + L. I have selected the columns from A to F because totally there are 3 columns hidden in this range. The reason why I told you this is because we can unhide all the columns using a keyboard shortcut. That word still playing in my mind all the time when I open an excel sheet. They told me if you want to learn or masters excel, you need to forget that you have a mouse you should know everything on the keyboard itself. There was a golden word from one of my seniors at the start of my career. Unhide Columns in Excel Using Key Board Shortcut Now we can see the entire column in the worksheet, right from column A to G. When the pointer changes from the selection arrow to a double arrow - this will happen as the mouse pointer nears the Select All cell - right-click and choose Unhide.Note: All another hidden column other than in the range of A to G remains hidden only. Hover the mouse over column B’s header cell and move left.Now, choose Column from the Format menu, and the choose Unhide. Doing so will selecteverything to the left, including column A. Release the mouse with the pointer over the Select All cell (the blank gray cell that intersects the header and row cells). Don’t click any borders, just drag the selection mouse pointer (the fat arrow pointing down). Click column B’s header cell and drag the mouse pointer to the left.Don’t panic, column A isn’t gone forever, and there’s more than one way to unhide it: Selecting just column B won’t select column A. That works fine until you try to unhide column A, as there’s only one adjacent column, column B. After selecting the hidden column and its adjacent columns, choose Column from the Format menu and then select Unhide. You’re really selecting three columns: the hidden column and both columns on either side of it. Select the columns that are adjacent to the hidden column. Unhiding a column takes a bit of specialized knowledge, but it isn’t difficult. To hide a column, select it, choose Column from the Format menu, and then select Hide. SEE: Download: Build your Excel skills with these 10 power tips (TechRepublic) Hiding a column tucks data out of sight without interfering with its function.
![microsoft excel unhide columns shortcut microsoft excel unhide columns shortcut](https://cdn4syt-solveyourtech.netdna-ssl.com/wp-content/uploads/2013/03/how-to-unhide-columns-excel-2.jpg)
Even you won’t want to see all of it all the time.
![microsoft excel unhide columns shortcut microsoft excel unhide columns shortcut](https://i.ytimg.com/vi/JdpFJeyx98U/maxresdefault.jpg)
Confidentiality aside, sometimes endless data is just a nuisance. Not everything in your worksheet needs to be privy to everyone. Fortunately, there are two simple tricks for unhiding it. The secret to unhiding column A in an Excel worksheetĪfter you hide column A, it might seem like it's gone forever.