Question

How can we insert a column using shortcut key in excel 2010?

Answer 1

To insert row or column by shortcut keys

Select an entire row/column that you want to add a row/column above or left of it, and then press Ctrl + + keys, then a new blank row/column added above/left of your selected row/column.



If your keyboard has no Keypad, you can press Shift + Ctrl + + keys to insert rows or columns.



Tip: If you want to add several rows/columns at once time, for example, insert five rows/columns,, select entire five rows/columns by clicking Ctrl key first, then press Ctrl+ + keys or Shift + Ctrl + + keys, then new blank five rows/columns are inserted.

To delete row or column by shortcut keys

Select the entire row/column you want to delete, if you want to delete several rows/columns at once time, press Ctrl key to select them, then press Ctrl + - keys delete.