These instructions explain how to add and delete rows and columns using a keyboard shortcut and the right-click context menu in Excel 2019, 2016, 2013, 2010, Excel Online, and Excel for Mac.
Adding and Deleting Columns and Rows in Excel
When columns and rows of data are deleted, the data is also deleted. These losses also affect formulas and charts that reference the data in the deleted columns and rows.
If you accidentally delete columns or rows of data, you can use the Undo feature on the ribbon to get the data back.
The key combination you use to add rows to a worksheet is:
