![]() ![]() If you need to add numerous rows at a time, like one or two hundred, take the advantage of the F4 button. If you prefer to use the main keyboard, you can get the same results if you use the Ctrl + Shift + Plus on the main pad. Now press Ctrl + Plus on the numerical pad.To do this left-click on the row number button next to the fist cell of the selection and extend the range keeping the left mouse button pressed. Select the range in Excel to insert a new row.The Excel insert row shortcut I show below will work only if you press the Plus key on the numerical keypad. Use numerical keypad shortcut to add rows in ExcelĮven if you don't enter large amounts of numeric data, you can still benefit from using the number pad. Please keep reading - the most interesting details are ahead. Voila! You can see the new rows added below. The current content will be moved down to make room for the new rows. Select the necessary number of rows where the blank lines will appear by picking the corresponding cells and pressing Shift + Space. ![]() The first shortcut I'd like to cover is the one repeating the Ribbon option Insert Sheet Rows. I'll share how to insert new rows in Excel with keyboard shortcuts. If you think that the ways described above are fast enough, check out the below options to see what is really quick. If you need to remove rows with irrelevant data, you'll find some effective solutions here: How to delete rows in Excel based on a cell value. ![]()
0 Comments
Leave a Reply. |