Just because you have a spread sheet full of data does not imply you intend to see it all at once. You can conceal columns in Microsoft Excel that you do not require at the moment. Then simply unhide them when you’re ready.

Conceal Columns in Microsoft Excel

Concealing columns in Excel is super very easy. As well as, you can select the columns you wish to hide in a couple of various methods.

Once you choose the columns you want to conceal, they’ll be highlighted. Right-click one of them as well as pick “Hide” in the shortcut menu.

After you conceal columns in Excel, you’ll see a thick white line sign between the continuing to be column headers. If you’re using a Mac, this indicator might appear as a bold green line. This is a good idea to bear in mind if you’re looking for data you do not see.

If you would certainly such as to keep specific columns on screen while you scroll through your spreadsheet, find out exactly how to freeze columns and rows in Excel.

Unhide Columns in Microsoft Excel

When you’re all set to check out those hidden columns, unhiding them is equally as easy as concealing them. Select the columns on each side of the covert column(s). You can do this easily by dragging through them. Then, right-click as well as pick “Unhide” in the faster way menu.

One more way to unhide columns is by double-clicking the line sign for the concealed columns.

Keep in mind that you can hide rows in Excel the same way as concealing columns. And if you have an older version of the application, the process coincides, yet the look differs. Have a look at the screenshots in our how-to for concealing as well as unhiding rows and also columns in Excel 2013.