Are you tired of manually unhiding columns in Excel? Do you want to know a faster way to do it? Well, look no further because Excel has a shortcut that allows you to quickly unhide columns. In this blog post, we’ll be discussing the Excel keyboard shortcut to unhide columns, how to use it, and some points to remember.
Keyboard Shortcut to Unhide Columns In Excel
The keyboard shortcut to unhide columns in Excel is Ctrl + Shift + 0 for Windows and ⌃ + ⇧ + 0 for Mac.
How to Use the Keyboard Shortcut
- To use the keyboard shortcut to unhide columns in Excel, follow these steps:
- Select the columns on either side of the hidden column.
- Press the keyboard shortcut Ctrl + Shift + 0 (Windows) or ⌃ + ⇧ + 0 (Mac) to unhide the column.
Points to Remember
- Here are some points to keep in mind when using the keyboard shortcut to unhide columns:
- You must select the columns on either side of the hidden column for the keyboard shortcut to work.
- If you have hidden multiple columns, you will need to repeat the process for each column you want to unhide.
- This keyboard shortcut works for columns that have been hidden using the “Hide” option in the “Format” menu or by right-clicking on the column header and selecting “Hide.”
Conclusion
Using the keyboard shortcut to unhide columns is a quick and efficient way to unhide columns without having to manually unhide them. By using this shortcut, you can save yourself time and improve your productivity. So go ahead and give it a try!