Excel Hide Shortcut
MS Excel or Microsoft Excel is one of the most powerful spreadsheet software and has several distinct features. The hide feature in Excel is one of the useful features and helps users to manage vast amounts of data efficiently. The feature is very easy to use. It is used for both rows and columns accordingly.
This article discusses the Excel Hide feature and the process to use it using different shortcuts. The article includes the process for both hiding rows and columns.
What is the Hide feature in Excel Rows and Columns?
Excel Hide feature is one of the basic features, and it enables users to group the specific number of rows or columns and hides them temporarily. It mainly compresses the desired rows or columns within the Excel sheet. Users can unhide the rows/ columns whenever they need to see the details of the hidden rows/ columns.
Excel Hide feature is mainly used to hide rows/columns when the data is huge, and we want to hide unimportant data from the visible screen. The feature only hides data and does not change or affect results related to related rows/columns. The Hide feature is available in most Excel versions, including Excel 2007, 2010, 2013, 2016, 2019, and Office 365.
Hide Rows and Columns using Keyboard Shortcut
Excel has implemented several keyboard shortcuts to ease the use of Excel features. Users can perform most Excel tasks with shortcuts. Using the keyboard shortcuts reduces some steps and overall time of the working process. Thus, using keyboard shortcuts is the quickest and the most efficient way of performing most tasks in Excel. Thus, we must know the shortcut keys to hide rows and columns in Excel.
Since rows and columns the two different components of Excel, we use different shortcut keys to hide rows and columns:
For Hiding Row
The keyboard shortcut for hiding a row in Excel is "Ctrl + 9" without quotes. We need to follow the below steps to hide a row in Excel using a keyboard shortcut:
For Hiding Column
The keyboard shortcut for hiding a column in Excel is "Ctrl + 0" without quotes. However, we must use the shortcut properly. We need to follow the below steps to hide a column in Excel using a keyboard shortcut:
Note: It should be noted that the keys '0 and 9' must only be pressed from keyboard numbers. Using the respective keys from the number pad of the keyboard does not work.
Suppose we have the following Excel sheet with some employees' data. In the following Excel sheet, we want to hide the 5th and the column C using the keyboard shortcut. That means we need to hide a row and column in the same sheet.
We need to perform the following steps to hide the desired row and column in an example sheet:
That is how we can use the Excel Hide keyboard shortcut and hide a desired row or column.
Hide Rows and Columns using the Context Menu Shortcut
Another method to hide a row and column in Excel is to use the context menu. The context menu is accessed using the right-click directly on the row header or column header. Upon pressing the right-click on any headers, it displays some options, including the Hide option. However, it should be noted that the Context Menu only comes if the entire row/ column is selected when pressing the right-click button on the row/ column header.
For Hiding Row
For hiding a row, we need to press the right-click on the row header. For example, suppose the following Excel data where we need to hide the 3rd row.
For Hiding Column
For hiding a column, we need to press the right-click on the column header. For example, suppose the following Excel data where we need to hide column B.
That is how we can use the Excel Hide shortcut from the context menu and hide a desired row or column.
Hide Rows and Columns using the Ribbon and its Shortcuts
The last method to hide the desired rows or columns includes the use of ribbon tabs and their respective shortcuts. This is a typical method to hide rows/ columns. The process is the same for both rows and columns. Let us discuss the steps:
Apart from the steps mentioned above, we can also use the "Alt + H + O + U + R" shortcut without quotes. For this, we need to press the respective keys in series.
How to hide multiple rows/ columns in Excel?
Hiding multiple rows or columns is as easy as hiding an individual row or column. However, we must select all the corresponding rows/ columns before following any of the above methods. The easiest one is to use keyboard shortcut keys.
Let us understand the steps to hide multiple rows and columns in the same excel sheet with the help of an example:
Suppose we have the following Excel sheet where we need to hide columns 'C & D' and rows '3rd & 7th'.
In this case, we will be hiding the adjacent columns and non-adjacent (separated) rows. This means we can hide both the adjacent and non-adjacent rows/ columns.
We need to perform the following steps to hide the corresponding rows/ columns in an example sheet:
It should be noted here that we should use the Ctrl button to select non-adjacent rows/columns and the Shift button for adjacent rows/columns. In this way, we can hide multiple rows or columns, regardless of whether they are adjacent or non-adjacent.