Press Alt-4 to insert multiple rows at once. Hold down the Shift key and then use the Down arrow key to select multiple cells. If your keyboard has no Keypad,you can press Shift + Ctrl + + keys to insert rows orcolumns.Īlso Know, what is the shortcut key for Insert row in Excel? Press Alt-4 once to insert the initial row, and then press either F4 or Ctrl-Y to repeat thisaction. 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 yourselected row/column. Similarly, you may ask, how do you insert a row using the keyboard?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |