How To Insert Add A Row Or Multiple Rows In Excel Explained

there are two main ways to insert row in Excel for the first way go over to the number of where you want to insert row in this example want to insert row under Row 4 in row 5. you will see the cursor turned into black arrow pointing to the right from here left click once and you'll see the entire row highlighted next right click and you'll see pop-up box appear from here go down to the word insert and left click on it and new blank row will be created and inserted then you can left-click anywhere in the spreadsheet to unhighlight the row now for the second way make sure you're on the Home tab at the top of the spreadsheet start by left clicking anywhere in the row where you want to insert new row so cell is highlighted in this example Row 3 from here go up to the insert tab in the cells section near the top of the spreadsheet left click on the down arrow under the insert Tab and drop down box will appear from here left click on insert sheet rows and new row will be created in row 3. and OneNote as I'm showing on the screen for the first way if you highlight multiple rows you can insert multiple rows and for the second way again if you highlight multiple rows you can insert multiple rows all right my friends hopefully you got something out of this video do have more videos right there for you till next time out of here