Add More Than One New Row or Column in Microsoft Excel
As you play around with your data in Microsoft Excel, you might find you’re constantly needing to add more rows and columns to your spreadsheets. Doing this one-by-one would be can be very tedious. Luckily, there’s always an easier way in Microsoft Excel.
To add multiple rows or columns in a spreadsheet, highlight the same number of preexisting rows or columns that you want to add. Then, right-click your mouse and select “Insert.”
In the screenshot to the right, 3 rows are selected, then we right clicked the mouse and clicked “Insert”. This will add 3 new rows to the spreadsheet.
Excel, Excel Columns, Excel Rows, Excel shortcuts, Excel tricks, Microsoft Excel