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 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.
- 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.
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.
You should read it
- How to Create a List in Cells in Excel
- How to create a drop list in Excel 2016
- How to create bullet list in Excel
- Calculate the subtotal of the list on Excel
- How to create List Box in Excel
- How to create drop down list to select in excel
- Differentiate between PVC and PE food wrap, which is safe and best
- How to use the SUBTOTAL function in Excel
- How to list conditional lists in Excel
- Instructions for ordering food through Zalo
- How to order food on the phone with Now.vn application
- Calculate the total value of the filtered list in Excel