Shortcut keys to quickly hide and show rows and columns in Excel

Sometimes you need to hide rows in Excel to clean up your spreadsheet. Instead of doing it manually, learn how to use the shortcut key to hide rows, which will save you time and improve your work efficiency.

For office workers, especially accountants,  Excel shortcuts  are very important. In this article, let's learn what the shortcut keys to hide rows and columns in Excel are and how to use them.

Shortcut keys to quickly hide and show rows and columns in Excel Picture 1Shortcut keys to quickly hide and show rows and columns in Excel Picture 1
 

Shortcut keys to hide and show rows and columns in Excel

Ctrl + 9 or Ctrl + Shift + 9
Press once to hide and again to show the column again in Excel.

Shortcut keys to quickly hide and show rows and columns in Excel Picture 2Shortcut keys to quickly hide and show rows and columns in Excel Picture 2

- To hide a column in Excel we use Ctrl + 0 or Ctrl + Shift + 0. Similarly
, press once to hide the column and press again to return to the old state.

Shortcut keys to quickly hide and show rows and columns in Excel Picture 3Shortcut keys to quickly hide and show rows and columns in Excel Picture 3
 

Note: The shortcut keys to hide rows and columns in Excel only work when you have selected one or more rows or columns. If not selected, the above shortcut keys will not work.


With the above answer, you must have known how to use shortcut keys to hide rows and columns in Excel, right? In the process of learning Excel, many people still do not fully understand the features of Excel, such as how to wrap lines in Excel, which is why it is necessary to improve your knowledge through in-depth articles.

5 ★ | 1 Vote