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.

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

 

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.

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

- 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.

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

 

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.

Update 24 December 2024
Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile