Wouldn’t it be better if you could spend a little less time navigating, formatting, and entering formulas for the data? Hence we’ve put together a list of keyboard shortcuts for Microsoft Excel.

You can also unhide the column by selecting the entire worksheet, then right-clicking anywhere in the worksheet, and then clicking on the unhide option.Many marketers who own a MacBook use Microsoft Excel every day, whether it’s to analyze data, create a pricing table, or to make a presentation to the client.Ĭreating reports in Excel is a laborious, time-consuming task.

In that case, enter A:A in the name box and then use the above keyboard shortcut to unhide the columnĪlternate Ways to Unhide Columns in Excel in Excel:

If the first column in your worksheet is hidden and you only want to unhide the first column, you won’t be able to select the columns before and after it (as the first column itself is hidden).

There are other alternate shortcuts to unhide columns as well, however, they are dependent on your keyboard layout and your system settings and may not always work

While the keyboard shortcut I mentioned above is a little long, it works every time without fail.

Important Things to Know About Unhide Columns in Excel:

With the entire sheet or the specific columns selected, use the keyboard shortcut ALT + H + O + U + L (press one key after the other).

in case you only want to unhide columns between specific columns, you need to hold the shift key on your keyboard and then select the columns between which you have the hidden columns that you want to unhide

If you want to unhide all the columns in the entire worksheet, select the entire worksheet by using the keyboard shortcut Control + A + A.

Or ALT + O + C + U How to Use the Keyboard Shortcut to Unhide Columns in Excelīelow are the steps to use the above keyboard shortcut:

Alternate Ways to Unhide Columns in Excel in Excel:īelow is the keyboard shortcut to Unhide Columns in Excel: ALT + H + O + U + L.

Important Things to Know About Unhide Columns in Excel:.

How to Use the Keyboard Shortcut to Unhide Columns in Excel.

Shortcuts for excel 2016