You can apply the same logic as we have applied for inserting rows here as well.Once the entire column has been selected, use the insert shortcut key “Ctrl and + (Plus)” to insert a new column.Cell D3 has been selected, so to select the entire column of the active cell, use the shortcut key “Ctrl + Space.”.So first, select any of the cells in column D. For example, in the same data table above, if you want to insert a column after column C, then we need to select the column after column C. Similarly, we can also insert columns using shortcut keys.After performing the insert row option, if you press the F4 key again, it will repeat the last action of inserting rows, and again three more rows will be inserted. There we have three new rows, so insert shortcut key will be inserted as many rows as we have selected at the time of using the shortcut key. Now press the shortcut key “Ctrl and + (Plus)” to insert as many rows as we have selected above.Assume you need to insert three rows instead of 1, then you need to select three before pressing the shortcut key.There you go, a new row has been inserted. Now simply press the shortcut key “Ctrl and + (Plus)” to insert a new row by pushing the currently selected row to down. ![]() After the cell selection, press the shortcut key “Shift + Space” to select the entire row.First select any of the cells in row number 5.Follow below steps to insert new row using excel shortcut. Assume we need to insert a new row after row number 4.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |