How do I delete duplicate rows in an Excel spreadsheet?
Pull Down Zoom MenuOpen the Excel spreadsheet with the duplicate rows by clicking “File” then “Open.” Browse to the spreadsheet on your computer and double-click the file name so it opens in the Excel workspace. Pull down the zoom menu at the top of the screen and reduce the view percentage so you can see all the duplicate rows on the screen.Click on Each RowPress and hold down the “Ctrl” key, then click your cursor on each row number to delete. Click the number of the row in the very first column, not an actual cell.
