That's all there is to it! Using this keyboard shortcut is a quick and easy way to insert multiple rows or columns in Excel. Simply select the number of columns you want to insert, then press the Ctrl + Shift + + keys on your keyboard. You can also use this keyboard shortcut to insert multiple columns in Excel. Excel will add the selected number of rows to your spreadsheet. In this box, choose Entire Row and click OK. While the rows are selected, press Ctrl+Shift+Plus (+ sign) at the same time on a PC, or Command+Shift+Plus (+ sign) on a Mac. This will insert the number of rows you selected. Excel will add new rows above the selected rows. Next, press the Ctrl + Shift + + keys on your keyboard (Ctrl + Shift + plus sign). All of the rows between the first and last row you selected will be highlighted. To do this, click on the row header of the first row you want to insert, then hold down the Shift key and click on the row header of the last row you want to insert. For this example, we'll insert three rows. Here's how to use it.įirst, select the number of rows you want to insert. Luckily, there's a keyboard shortcut that allows you to insert multiple rows in Excel quickly and easily. If you work with large amounts of data in Microsoft Excel, you know how frustrating it can be to insert multiple rows manually.
0 kommentar(er)
