Now you can add your missed data in a hurry and save a few minutes at work for a coffee break. Press Alt+I and then while holding the Alt key, press R.Īnd there you go, three of the easiest ways to insert multiple rows in Excel. The first step is exactly the same, select your rows using whichever method you please.Ģ. Sure, you’ll save maybe one extra second, but you’ll look like an Excel pro.ġ. If you have any formatting in your cells, make sure to select Insert Options instead to keep the format consistent.īoth methods so far have been pretty quick and easy, but we can kick the speed up a notch using keyboard shortcuts. Now, right-click on the cells that you’ve selected and choose the Insert option. Select your cells and then highlight the rows.Ģ. This is the easiest way to put new rows into your sheet, however, you can also get the same results with the right-click menu as well.ġ. Now you can select the number of rows that you want to insert. Go to the Home tab and select the Insert option. ![]() You can also select rows by clicking on the row numbers.Ģ. ![]() To do this, select the cells and press Shift+Space to highlight the entire rows. ![]() Select the rows where you want blanks to appear. That means that the first option for inserting rows is the Insert tab. Following Occam’s Razor, the most obvious solution is usually correct.
0 Comments
Leave a Reply. |