These losses also affectformulasand charts that reference the data in the deleted columns and rows.
This can also be done using akeyboard shortcut:
Excel inserts the new row above the row selected.
If you want three new rows, select three existing rows.
Lifewire / Lisa Fasol
Selecting adjacent rows can be done using the arrow keys on the keyboard after the first row is selected.
The key combination becomesCtrl++.
If you want three new columns, select three existing columns.
The easiest way to delete a column is to grab the entire column to be deleted.
Selecting adjacent columns can be done using the arrow keys on the keyboard after the first column is selected.
