Lately, we have been providing tutorials on Microsoft Excel program. If you have been reading our articles, you must know that. So continuing the series, we have again come up with a fresh and interesting tutorial on excel that is How to hide columns in excel. Also learn, how to move columns in Excel.
Hiding and Unhiding cells in excel are just a few clicks steps. All you need to do is press a command. Yes, hiding data in excel don’t take much efforts and time. If you have a little bit of knowledge in excel, hiding cells in excel would not be at all a tough job for you.
There can be various reasons to hide columns and cells in excel sheet, for example, if you have some extra data worksheets that are the citation, but don’t require to be viewed. Or maybe you have a few rows or columns of data of the worksheet that need to be hidden or are not shareable.
In such situations, guides such as how to hide cells in excel prove to be very handy. In today’s guide, we will share the ways to hide columns in excel. Apart from that, we will also see some best shortcuts for rows and columns that can help you work done faster.
How to Hide Columns in Excel
Adding columns in Excel is pretty easy but to hide the confidential data may seem like a hard job. Hiding command in excel is just a few clicks steps as I said above. You can hide any cell at any time from the excel sheet. And the best part of hiding the cell is, it can be un-hided easily that too anytime you want.
Though, we are not going to cover the procedure of un-hiding in detail here. Instead, we will see all the possible ways to hide the rows in excel. The procedure of hiding the rows and columns is almost the same. If you want to hide the column then replace the word column with the row in this tutorial.
Since I am not going to cover the rows here. I will tell you the procedure of hiding columns. So what are you waiting for? Let’s begin the guide and check out the ways to hide columns in excel programs.
Read out the complete guide till the end and learn to hide columns/rows in the excel program. First, we will see the traditional approach to hiding rows and columns. And here go the method.
#Method 1:
- To hide a column in excel, first of all, select the column you want to hide. To select a single cell click the cell, or press the arrow keys to move to the cell. If you want to hide an entire row or column, right-click on the row or column header.
- Ok, after you have decided and have selected the column, right-click on it and click on Hide. Check out the screenshot I have taken for you.
After you hide the columns if you want to confirm if they are actually hidden or not, see the series of the letters or numbers at the head.
For example, if you have hidden the column ‘C’ then you will see in the series, column C is missing. Plus the double lines between the column B and D indicates hidden columns or rows.
In case, you want to hide multi columns then you will have to select them together and click on Hide option to make them invisible from the sheet. To select the
To select the multi-columns, either select by dragging the mouse from the first cell to the one you want to select. Or, select the first cell and press the arrow keys to make the selection.
Once the selection is done, simply right click on the column and click on Hide. That’s it.
#Method 2:
Another way to hide a column in excel is by changing the row height or column width to 0 (zero). This is one of the easiest way to hide, column or rows. You can hide the columns by dragging them to previous or next column manually as well.
For example, if you want to hide the column D then select the D column and drag it to either column E of C. Check out the image mentioned below. In the image, if you notice I have selected the column D.
That’s all! Just a few clicks and you are done. Isn’t hiding columns in excel is very easy.
If you want to unhide the column then you will need to select the hidden columns and click on unhide.
For example, as I hidden the column D in the above method. Now to unhide the same I will have to select the sided column like column C and column E.
After the selection, right click on the column and click on Unhide option and the hidden columns will go visible. You can see the complete guide to unhide the columns in Excel.
Now as you have learned How to hide columns in excel, let’s check out some shortcuts for rows and columns that would help you while using excel. Below I am sharing some of the best excel shortcuts, hoping it will help you job done faster.
- Shift+Space to select an entire row. Select any cell and press Shift+Space. And the entire row would be selected. And to select entire column press Ctrl+Space.
- To insert a new cell, row and column press Ctrl++ (plus character) from the keyboard. After pressing the key combination a small dialog box will be opened up. Choose any of the required options from the list.
- To delete a cell, row or column, press Ctrl+- (minus character)
- To hide row and column, press Ctrl+9 and Ctrl+0 (zero) respectively. And to unhide the row and column press Ctrl+Shift+( and Ctrl+Shift+) respectively.
The shortcuts I shared are one of the most useful shortcuts in the excel program. So, how do you like the article? Do let us know in the comment section below. If you have any other methods to hide columns in excel then you can also share with us.
And if you have any suggestion or doubt don’t hesitate to drop your comment in the comment section below.