Buzz
Deleting rows and columns in Excel 2016, 2013, 2010, 2007, and 2003 is actually very simple and the process is no different from deleting rows and columns in Word to remove them from the table you are editing.
Using mouse clicks or keyboard shortcuts to delete rows, columns in Excel spreadsheet
Deleting Rows, Columns in Excel Using Mouse or Keyboard
If you don't have Excel yet, you can choose from the various Office versions to install on your computer. You can also install both Office suites on the same machine. If you're unsure how, refer to the guide on installing two Office suites on the same machine without system conflicts.
1. Deleting Rows, Columns in Excel Using Mouse
Let's say we have a list with a total of 6 rows including the Code column from A to K. Now let's proceed with Mytour to delete rows and columns in Excel.
Step 1: This is the basic method to delete rows and columns in Excel 2016, 2013, 2010, 2007, and 2003. To delete a row, simply click on the column number and right-click. A Menu will appear, select Delete to remove it. Here, Mytour will try deleting the row containing the letter B.
Step 2: Upon checking, you'll notice that the column Code B with its related values is now gone. Deleting rows in Excel 2016, 2013, 2010, 2007, and 2003 is now completed.
Step 3: Similarly, let's proceed to delete a column in Excel with the example of deleting column C (i.e., row 3) from the table by following the same method.
- Afterwards, upon review, you'll notice the absence of a column containing the number 3 series. With this method, we've swiftly and easily deleted rows and columns in Excel 2016, 2013, 2010, 2007, and 2003.
2. Deleting Rows, Columns in Excel Using the Delete Key
Step 1: With this method, we'll delete rows and columns in Excel using the Delete key. However, remember that this deletion only removes the data in the row or column, not the row or column itself. In this example, Mytour will attempt to delete row C using the Delete key.
Step 2: After deleting the row, try deleting column E (row 4) using the Delete key with the same approach.
Note: You cannot delete rows or columns based on values using this method if another object is linked to multiple rows or columns.
3. Deleting Rows, Columns in Excel Using Shortcut Keys
To delete rows or columns in Excel using shortcut keys, simply select the rows or columns and press Ctrl + '-'. To add rows or columns in Excel, hold Ctrl + Shift and press +. This is the quickest way to delete rows or columns in Excel or to add them.
This is the method to delete rows or columns in Excel 2016, 2013, 2010, 2007, and 2003 using mouse clicks or hotkeys that we want to introduce to you in this article. This method is much faster than deleting cell by cell as you usually do. Additionally, we also provide guidance on how to delete links in Excel. Whether you want to add or insert rows into an Excel table, you can easily do so.
- Read More: How to Add Rows in Excel
