Excel Tricks

Excel Tricks: Unhiding Columns Made Simple

Are you tired of struggling to unhide columns in Excel? Look no further! In this article, we will show you some simple tricks to make the process of unhiding columns a breeze.

With just a few clicks or keystrokes, you’ll be able to effortlessly reveal hidden columns and regain access to your important data. We will guide you through various methods, including using the Ribbon Menu, shortcut keys, and the Format Cells Dialogue Box.

We will also show you how to unhide multiple columns at once and deal with hidden columns in protected sheets. Plus, we’ll teach you how to customize the Quick Access Toolbar for easy access to the unhide columns feature.

And if you encounter any issues along the way, don’t worry, we’ve got you covered with troubleshooting tips.

So let’s dive in and master the art of unhiding columns in Excel!

Using the Ribbon Menu

Are you tired of wasting time trying to figure out how to unhide columns in Excel? Well, fear not! We’ve got a simple solution for you – just use the Ribbon Menu! It’s a quick and easy way to access all the hidden features in Excel.

To unhide columns, first, select the range of cells that include the hidden columns. Then, go to the Home tab on the Ribbon Menu and find the Format option. Click on it, and a drop-down menu will appear. Look for the Hide & Unhide option, and from there, select Unhide Columns.

Voila! Your hidden columns will magically reappear, saving you valuable time and frustration.

So, why waste any more time? Start using the Ribbon Menu today and make unhiding columns in Excel a breeze!

Shortcut Key Method

Discover how you can effortlessly reveal hidden columns in a more efficient manner by utilizing a shortcut key method. Instead of navigating through the Ribbon Menu, this handy trick allows you to quickly unhide columns with just a few keystrokes.

To begin, select the columns adjacent to the hidden columns that you want to reveal. Then, press and hold the Alt key on your keyboard. While holding the Alt key, press the following sequence of keys: H, O, and U. This will instantly unhide the selected columns, making them visible again.

By using this shortcut key method, you can save time and easily manage your spreadsheet without the need to navigate through menus or search for hidden options.

Unhiding Multiple Columns at Once

Save yourself time and effort by unhiding multiple columns at once using this efficient method. Instead of manually unhiding each column one by one, you can select multiple columns and unhide them all at once.

To do this, first, click on the column header of the first column you want to unhide, then hold down the Ctrl key on your keyboard. While holding down the Ctrl key, click on the column headers of the other columns you want to unhide.

Once you have selected all the columns, right-click on any of the selected column headers and choose the ‘Unhide’ option from the context menu. Voila! All the selected columns will be instantly unhid, saving you valuable time and effort.

Using the Format Cells Dialogue Box

Let’s take a look at how you can easily adjust the formatting of cells using the dialogue box.

When you need to unhide multiple columns in Excel, the Format Cells dialogue box is your go-to tool. To access it, select the columns you want to adjust and right-click on the selected area. Then, choose the Format Cells option from the drop-down menu.

A dialogue box will appear, allowing you to make various formatting changes to the selected columns. To unhide the columns, go to the ‘Protection’ tab and uncheck the ‘Hidden’ option. Click OK, and the hidden columns will be revealed instantly.

This method is efficient and saves you time when unhiding multiple columns at once.

Unhiding Columns in Protected Sheets

Unhiding columns in protected sheets can be a breeze with a simple trick. When you encounter a protected sheet in Excel and need to unhide certain columns, follow these steps.

First, right-click on any visible column header and select ‘Format Cells’ from the drop-down menu. In the Format Cells dialogue box, navigate to the ‘Protection’ tab. Uncheck the ‘Locked’ box and click ‘OK.’

Next, select the entire worksheet by clicking the small triangle at the top left corner. Right-click and choose ‘Format Cells’ again. This time, go to the ‘Protection’ tab and check the ‘Hidden’ box.

Finally, click ‘OK’ and the hidden columns will be visible once again. With this trick, unhiding columns on protected sheets becomes a piece of cake.

Customizing the Quick Access Toolbar

Customizing the Quick Access Toolbar can greatly enhance your Excel experience, allowing you to personalize the commands and functions that are readily available at your fingertips.

By customizing the Quick Access Toolbar, you can save time and effort by adding the commands you use most frequently. To customize the toolbar, simply click on the dropdown arrow at the end of the toolbar and select ‘More Commands.’

From there, you can choose from a wide range of commands and functions to add to your toolbar. You can also rearrange the order of the commands by clicking on the ‘Up’ or ‘Down’ arrows.

Additionally, you can choose to show the toolbar above or below the ribbon for easy access.

With a customized Quick Access Toolbar, you can streamline your workflow and make Excel work more efficiently for you.

Troubleshooting Common Issues

If you’re encountering any issues while using Excel, don’t worry – troubleshooting common problems is easier than you might think!

First, check if the issue is related to hidden columns. Sometimes, columns can accidentally get hidden, making it difficult to view or edit data. To unhide columns, simply select the columns on either side of the hidden columns, right-click, and choose ‘Unhide’ from the context menu.

Another common issue is when formulas are not calculating correctly. Double-check that all cell references are correct and that the calculation mode is set to automatic. If formulas still aren’t working, try using the ‘Evaluate Formula’ tool to identify any errors.

Lastly, if Excel is crashing or freezing frequently, try disabling any unnecessary add-ins or repairing the program through the Control Panel.


In conclusion, unhiding columns in Excel can be done easily using various methods. Whether you prefer using the Ribbon Menu, shortcut keys, or the Format Cells Dialogue Box, Excel provides multiple options to meet your needs.

Additionally, you can unhide multiple columns at once and even unhide columns in protected sheets. By customizing the Quick Access Toolbar, you can further streamline the process.

In case you encounter any issues, there are troubleshooting techniques available to help you resolve them. With these tricks, unhiding columns in Excel becomes a simple task.

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *