Youtor
How To Delete Or Remove A Row Or Multiple Rows In Excel Explained
>> YOUR LINK HERE: ___ http://youtube.com/watch?v=AWAj186aJlI
In this video we discuss how to delete or remove a row or multiple rows in an excel spreadsheet. We go through 2 different ways to delete a row and show examples of each way • Transcript/notes • There are 2 main ways to delet a row in excel. • For the first way, go over to the number of the row you want to delete, in this example, I want to delete row 4. You will see the cursor turn into a black arrow pointing to the right. • From here, left click once, and will see the entire row highlighted. Next, right click and you will see a pop up box appear. Next, go down the word delete and left click on it and the row will be deleted. Really, the contents of the row have been deleted, and the rows beneath have been moved up. • Be careful though, if you have any formulas in other cells that are dependent on the values in the deleted row, you will get this #reference. Then you can left click anywhere in the spreadsheet to unhighlight the column. • Now for the 2nd way. Make sure you are on the home tab at the top of the spreadsheet. Start by left clicking anywhere in the row you want to delete, so a 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 delete icon, and a drop down box will appear. From here, left click on delete sheet rows, and the row will be deleted, and the rows beneath will be moved up. • One note, as I am showing on the screen, for the first way, if you highlight multiple rows, you can delete multiple rows. And for the second way, if you highlight multiple cells in multiple rows, you can delete multiple rows. • Chapters/Timestamps • 0:00 How to quickly delete a row • 0:43 How to use delete tab icon to delete a row • 1:11 How to delete multiple rows at the same time
#############################
