Microsoft Excel is one of the most widely used spreadsheet software in the world. It is used for various purposes such as accounting, data analysis, budgeting, and more. However, sometimes, you may accidentally hide columns, which can be frustrating. In this article, we will discuss the shortcut key to unhide columns in Excel.
What is the Shortcut Key to Unhide Columns in Excel?
The shortcut key to unhide columns in Excel is Ctrl + Shift + 0. This shortcut key is used to unhide the selected columns in Excel.
How to Unhide Columns in Excel using the Shortcut Key?
To unhide columns in Excel using the shortcut key, follow the steps below:
- Select the columns to unhide. You can select multiple columns by dragging the mouse over the column headers.
- Press Ctrl + Shift + 0 on your keyboard.
That’s it! The hidden columns will now be visible.
Why Would You Need to Unhide Columns in Excel?
There are several reasons why you might need to unhide columns in Excel. For example:
- You may have accidentally hidden the columns while working on your spreadsheet.
- You may have received a spreadsheet from someone else, and some of the columns are hidden.
- You may have intentionally hidden the columns to declutter your spreadsheet and now need to make them visible again.
Other Ways to Unhide Columns in Excel
Aside from using the shortcut key, there are other ways to unhide columns in Excel. Here are some of them:
Using the Right-click Menu
You can also unhide columns in Excel by using the right-click menu. Here’s how:
- Select the column headers to the left and right of the hidden columns.
- Right-click on one of the selected columns and click on Unhide.
Using the Home Tab
You can also unhide columns in Excel by using the Home tab. Here’s how:
- Select the column headers to the left and right of the hidden columns.
- Click on the Format dropdown in the Cells section of the Home tab.
- Click on Hide & Unhide, then select Unhide Columns.
Conclusion
Unhiding columns in Excel is easy and can be done in several ways. However, using the shortcut key can save you a lot of time and effort, especially if you need to unhide multiple columns. Remember to use Ctrl + Shift + 0 to unhide columns in Excel.
