You can also just hold down Ctrl+Shift as you repeating hit the “+” key, or hold down Ctrl as you repeatedly hit the “-” key.ĭo you know a better way to do it? Please share it with us in comments section. Select first cell in the row of the active cell. To insert more than one Row or Column at a time, use the ArRow Keys as you hold Shift before going to step 2. Select the first visible cell in the sheet (or bottom-right of freeze panes) Ctrl+Home. Remembering the SpaceBar is easy because the SpaceBar is a long key, so it can easily represent a Row or Column. A trick for remembering which shortcut to use for selecting the Row or Column is the mnemonic that both “Ctrl” and “Column” start with “C”. It’s easy to memorize these because Ctrl is pretty much the most powerful key there is and “+” and “-” make sense for adding and deleting. There is a two-step process that is very convenient for inserting or deleting a Row or Column: However, if you want to delete a Row or Column Method #2 below will help you do that with two more key strokes.Īlso Read: 24 Excel Keyboard Shortcuts to Help You Work Faster, Better Method #2 This is pretty simple and easy to insert a Column or Row quickly into your spreadsheet, in case you want to insert multiple Columns and Rows select required number of Rows or Columns as Step 1 then press or. ![]() Today we will learn how to quickly insert a new Row or Column using Keyboard Shortcuts in Excel. ![]() 4) used the keyboard shortcut Ctrl + (Ctrl key and the Plus sign from the keypad you can also use Ctrl + Shift + Plus sign from the numbers row) It inserted the rows and pasted. ![]() 3) highlighted the three cells below the 3s where I want the As to go. I have been trying to adapt as many Excel keyboard shortcuts as I can (not just for productivity, but for ergonomic reasons). 2) used the keyboard shortcut Ctrl X to cut them.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |