Home
Tech info
Technology
Science
Life
Application
Electric
Program
Mobile
Windows 10
Windows 11Shortcut keys to quickly hide and show rows and columns in Excel
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.
Micah SotoYou should read it
- 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
May be interested
- Create a PowerPoint presentation from an existing Word document
creating powerpoint presentations from existing word documents helps you create presentation slides faster and easier than usual. to learn how to do this, please follow the steps below. - PowerPoint presentation with keyboard, slide shortcutspresenting powerpoint using the keyboard is a great trick to help you control your slides. discover useful keyboard shortcuts in this article.
- How to create notes on your computer screen using Sticky Notesif you need to take notes while working on your computer, but don't want to open additional application windows, try creating notes on your computer screen with sticky notes, which helps you remember all important information.
- How to add fonts to Word in Windows computerwant to change the font in word to make your document stand out? check out this simple guide to adding fonts to word to help you compose beautiful and professional documents.
- How to install fonts for Win 10, download full font setwant to change the font on windows 10 to refresh the interface? check out this simple way to install fonts, making your computer look eye-catching and suitable for your personal style.
- How to Create a Budget Spreadsheet in Google Sheetsgoogle sheets helps you create a budget management table through a number of spreadsheet templates. then you just need to fill in the data into the budget spreadsheet on sheets.
Office information
How to convert columns into rows and rows into columns in Excel- How to temporarily hide rows and columns in Excel 2013
- How to hide and show the rows and columns in Excel is extremely simple.
- How to hide columns and hide rows in Excel 2016, 2013, 2010
- How to use Group to hide, show rows and columns in Excel 2007, 2010, 2013, 2016, 2019
How to convert columns into rows and rows into columns in Excel
How to temporarily hide rows and columns in Excel 2013
How to hide and show the rows and columns in Excel is extremely simple.
How to hide columns and hide rows in Excel 2016, 2013, 2010
How to use Group to hide, show rows and columns in Excel 2007, 2010, 2013, 2016, 2019