Excel is a really more frequent tool in the offices and firms for arranging budgets, schedules, ideas, plans, and much more. Every office or professional working is really incomplete without Excel.
With time and increasing users, MS Excel has also included various new features and tools to benefit its working members. One of this enchanting features of Excel is to hide the columns and rows.
Through using this feature, you can easily hide columns that you do not want other employees or your colleagues to see at the moment. Maybe you think of adding some updated figure or fact in there that wasn’t there at the moment or so.
So let’s start knowing about the ways of hiding columns in Excel here.
Before moving onto the ways of hiding columns in Excel, let’s get a quick insight into the ways that we are going to cover.
How to Hide Columns in Excel Shortcut
Hiding columns in Excel
You can easily hide columns in Excel by using some simple steps given below;
- First of all go to the Excel sheet, where you want to hide columns in.
Thereafter you need to select the column that you want to hide in Excel.
- Select the required column by clicking on the top of that column, on the alphabet that denotes the required column.
After you select the column, it appears to be shaded on your screen.
- Right click on the column, to open the option menu.
- Select the Hide option from the menu.
Here, that column gets hidden from your screen.
Thereby a very small gap appears on the top of that column, just between the adjacent column alphabets of that column.
These were the steps for hiding columns in Excel.
If you wish to hide more than one column in Excel, then do follow the steps given below.
Hiding multiple columns in Excel
You can easily hide multiple columns in Excel by following some simple steps given below;
- First of all, go to the Excel sheet where you want to hide multiple columns.
Thereafter, you need to select the columns that you want to hide in Excel.
- Click and drag the top alphabet heading of the respective columns in spreadsheets
After this the Columns that you have selected appear to be shaded.
- Right click on any of the selected columns in Excel, to open the option menu.
- Select the Hide option, from the menu.
Here, your selected columns get hidden from all other columns in Excel.
Thereby a very small gap appears in place of those hidden columns respective alphabets, between their adjacent alphabets.
These were the steps for hiding multiple columns in Excel.
Hiding columns in Excel using Data tab
This is another way of hiding columns in Excel through the data tab, present on the menu bar.
You can easily hide columns in Excel using the data tab by following some simple steps given below;
- First of all, go to the Excel sheet where you want to hide columns.
Thereafter select the columns that you want to hide from all other columns.
Either you can select a single column or multiple columns.
- Click on the top of the column to select it.
Or,
Click and drag the top of the column for selecting multiple columns.
- Go to the Data tab on the top of the Excel window. And click on the Group option.
After that on the top of the column table a minus sign appears in the center.
- Click on the minus sign, above the Excel table.
Here, the respective columns get hidden from all others in Excel.
Thereby a very small gap appears in place of those hidden columns respective alphabets, between their adjacent alphabets.
Now, if you wish to unhide those columns, then click on the Plus button, above the Excel table, in the center of that part.
And the hidden columns appears on your Excel window, right where they were earlier.
Unhiding column in Excel
You can easily unhide your hidden columns on Excel by following some simple steps given below;
- First of all, go to the Excel sheet where you have hidden the columns or from where you want to unhide the columns.
Thereafter you need to select the adjacent area columns of the hidden column.
- Click and drag the top of the column, to select the hidden columns.
- Right click on the selected columns.
- Select the Unhide option from the menu.
Here, you have successfully unhidden the hidden columns in Excel.
These were the steps for unhiding some pre hidden columns in Excel.
Unhiding multiple columns in Excel
By following the below given, you can directly unhide various hidden columns in Excel altogether;
- First of all, go to the Excel sheet where you want to unhide various columns.
- Go to the Home tab.
- Click on the “Format” option, present on the top right side of the Excel window.
- Select the “hide and unhide” option, from the visibility section in the menu.
- Click on thr Unhide option, to unhide all of the hidden columns or rows in Excel.
After this, every hidden column appears on your Windows screen.
Here you have successfully unhidden the hidden columns in Excel.
This was all about hiding columns in Excel.
FAQ
Q: What is the shortcut to hide columns in Excel?
A: The shortcut to hide columns in Excel is “Ctrl + 0” (zero).
Q: How do I select the columns I want to hide?
A: To select the columns you want to hide, click on the column letter at the top of the column. You can select multiple columns by holding down the “Ctrl” key while clicking on the column letters.
Q: How do I hide the selected columns using the shortcut?
A: Once you have selected the columns you want to hide, press “Ctrl + 0” (zero) on your keyboard. This will hide the selected columns.
Q: How do I unhide hidden columns in Excel?
A: To unhide hidden columns in Excel, select the columns on either side of the hidden columns by clicking on the column letters. Then, right-click on the selected columns and click “Unhide”. This will unhide the hidden columns.
Q: Is there a shortcut to unhide hidden columns in Excel?
A: Yes, the shortcut to unhide hidden columns in Excel is “Ctrl + Shift + 0” (zero). To use this shortcut, select the columns on either side of the hidden columns, then press “Ctrl + Shift + 0” on your keyboard. This will unhide the hidden columns.
