How to delete rows and columns in Excel with mouse or key
Excel is an important and indispensable tool in the work process. However, editing data or deleting rows and columns in Excel can be quite complicated for some new users. Therefore, to help make work more efficient, we will introduce to readers how to delete rows and columns in Excel using the mouse or keys in detail in the article below.
Deleting rows and columns in Excel 2016, 2013, 2010, 2007 and 2003 is actually very simple and the way to do it is absolutely no different from deleting a column row in Word, removing it from the table you are editing.
How to delete rows and columns in Excel with mouse or key
If you don't have Excel, you can choose Office versions to install on your computer. You can also install both Office suites on the same computer at the same time. If you don't know, please refer to how to install 2 Office suites on the same computer without system conflicts.
1. How to delete rows and columns in Excel with the mouse
Suppose we have a list with a total of 6 series of numbers including the Code column in order from A to K, now let's join TipsMake to delete rows and columns in Excel.
Step 1: This is the basic way to delete rows and columns in Excel 2016, 2013, 2010, 2007 and 2003. To delete the previous row, just click on the column number and right-click . A Menu will appear, select Delete to delete. In the TipsMake line, try deleting the row with the letter B.
Step 2: View the results and you will see that now there is no longer a Code B column with related values. Deleting rows in Excel 2016, 2013, 2010, 2007 and 2003 is complete.
Step 3: Similarly, we proceed to delete columns in Excel with the example of deleting column C (ie row 3) in the table by doing the above.
- Then you look again and you will see that a column containing the number 3 is missing. With the above method, we have deleted rows and columns in Excel 2016, 2013, 2010, 2007 and 2003 super quickly and simply.
2. How to delete rows and columns in Excel using the delete key
Step 1: With this method, we will delete rows and columns in Excel by pressing the Delete key , but you must remember that this deletion only deletes all data of that row and column and does not make them disappear like the above method. In this example, TipsMake tries to delete the C code row with the Delete key.
Step 2: After deleting the row, try deleting column E ( row number 4) using the delete key in the same way.
Note: You will not be able to delete columns or rows by value type this way if a certain object is related to many other rows and columns.
3. How to delete rows and columns in Excel using keyboard shortcuts
To delete rows and columns in Excel using keyboard shortcuts, just highlight the rows and columns and press the key combination Ctrl + "-" . To add rows and columns in Excel, hold Ctrl + Shift and press + to add . This is the fastest way to help you delete rows and columns in Excel or add them.
That's how to delete rows and columns in Excel 2016, 2013, 2010, 2007 and 2003 with the mouse or hotkey that we want to introduce to you in this article. This method is much faster than deleting each cell one by one that you usually do. In addition, we also guide how to delete links in Excel. Or if you want to add or insert rows into an Excel table, you can do it easily.
You should read it
- How to add rows and delete rows in Excel
- 8 How to delete blank rows in ExcelHow to delete blank rows in Excel
- How to delete, add columns in Excel
- How to delete photos in bulk in Excel
- This is a simple way to find and delete Hyperlink in Excel
- How to delete cells in Excel
- How to quickly delete multiple sheets in Excel
- How to delete quick recipe on Excel
- How to delete white pages in Excel
- How to delete dots in a series of numbers on Excel
- MS Excel 2007 - Lesson 5: Edit Worksheet
- MS Excel - Lesson 4: Working with lines, columns, sheets
Maybe you are interested
How to turn off Update Link notification in Excel - File content from many different sources Create Autotext in Word 2007, edit documents faster Alignment in Word 2010, beautiful alignment of Word 2010 documents Excel 2016 - Lesson 8: How to format numbers in Excel (Number Formats) How to master numerical data in Google Sheets with the AVERAGE function How to change commas to dots in Word - Number unit separator