Saved Bookmarks
| 1. |
How can we insert a column using shortcut key in excel 2010? |
|
Answer» rt row or column by shortcut keysSelect 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 keysSelect 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. |
|