Add And Delete Rows And Columns In Excel

If you accidentally delete columns or rows containing data, use the undo feature on the ribbon to get your data back.

Add Rows Using Shortcut Keys

The keyboard key combination used to add rows to a worksheet is: Before adding a row, tell Excel where you want the new one to be inserted by selecting its neighbor. This can also be done using a keyboard shortcut: Excel inserts the new row above the row selected. To Add a Single Row Using a Keyboard Shortcut To Add Multiple Adjacent Rows Using a Keyboard Shortcut Tell Excel how many new adjacent rows you want to add to the worksheet by selecting the same number of existing rows. If you want to insert two new rows, select two existing rows where you want the new ones to be located. If you want three new rows, select three existing rows. To Add Three New Rows to a Worksheet

Add Rows Using the Context Menu

The option in the context menu (also referred to as the right-click menu) that adds rows to a worksheet is Insert. As with the keyboard method above, before adding a row, tell Excel where you want the new one to be inserted by selecting its neighbor. The easiest way to add rows using the context menu is to select the entire row by selecting the row header. To Add a Single Row to a Worksheet To Add Multiple Adjacent Rows Tell Excel how many new rows you want to add to the worksheet by selecting the same number of existing rows. To Add Three New Rows to a Worksheet The easiest way to delete a row is to select the entire row to be deleted. This can also be done using a keyboard shortcut: To Delete a Single Row using a Keyboard Shortcut To Delete Adjacent Rows using a Keyboard Shortcut Selecting adjacent rows in a worksheet allows you to delete them all at once. Selecting adjacent rows can be done using the arrow keys on the keyboard after the first row is selected. To Delete Three Rows from a Worksheet

Delete Rows Using the Context Menu

The option in the context menu (or right-click menu) that is used to delete rows from a worksheet is Delete. The easiest way to delete rows using the context menu is to highlight the entire row by selecting the row header. To Delete a Single Row to a Worksheet To Delete Multiple Adjacent Rows Again, multiple adjacent rows can be deleted at the same time if they are all selected To Delete Three Rows from a Worksheet In the row header, drag with the mouse pointer to highlight three adjacent rows. To Delete Separate Rows Separate, or non-adjacent, rows can be deleted at the same time by first selecting them with the Ctrl key and mouse. To Select Separate Rows Before adding a column, tell Excel where you want the new one to be inserted by selecting its neighbor. This can also be done using a keyboard shortcut: Excel inserts the new column to the left of the column selected. To Add a Single Column using a Keyboard Shortcut To Add Multiple Adjacent Columns using a Keyboard Shortcut Tell Excel how many new adjacent columns you want to add to the worksheet by selecting the same number of existing columns. If you want to insert two new columns, select two existing columns where you want the new ones to be located. If you want three new columns, select three existing columns. To Add Three New Columns to a Worksheet

Add Columns Using the Context Menu

The option in the context menu that is used to add columns to a worksheet is Insert. Before adding a column, tell Excel where you want the new one to be inserted by selecting its neighbor. The easiest way to add columns using the context menu is to highlight the entire column by selecting the column header. To Add a Single Column to a Worksheet To Add Multiple Adjacent Columns Again as with rows, tell Excel how many new columns you want to add to the worksheet by selecting the same number of existing columns. To Add Three New Columns to a Worksheet It’s important to note that deleting a column is just that — while there is the option of hiding columns, which is the not-so-permanent way of getting rid of your columns. The easiest way to delete a column is to select the entire column to be deleted. This can also be done using a keyboard shortcut: To Delete a Single Column using a Keyboard Shortcut To Delete Adjacent Columns using a Keyboard Shortcut Selecting adjacent columns in a worksheet allows you to delete them all at once. Selecting adjacent columns can be done using the arrow keys on the keyboard after the first column is selected. To Delete Three Columns from a Worksheet

Delete Columns Using the Context Menu

The option in the context menu that is used to delete columns from a worksheet is Delete. The easiest way to delete columns using the context menu is to highlight the entire column by selecting the column header. To Delete a Single Column to a Worksheet To Delete Multiple Adjacent Columns Multiple adjacent columns can be deleted at the same time if they are all selected. To Delete Three Columns from a Worksheet To Delete Separate Columns Separate, or non-adjacent, columns can be deleted at the same time by first selecting them with the Ctrl key and mouse. To Select Separate Columns