I need help with Excel, again
Tue, 01/22/2013 - 2:33pm
14 years
|
I split the Wal-Mart file into Sam's and Walmart. Is there a clever way of selecting and then deleting all the Sam's entries?
14 years
|
I split the Wal-Mart file into Sam's and Walmart. Is there a clever way of selecting and then deleting all the Sam's entries?
.
Is there a clever way of selecting and then deleting all the Sam's entries?
- Sort by column C ascending.
- Scroll down to row 609, then click the row number to select the whole row.
- Scroll back up to row 1, then [Shift]-click the row number to select rows 1 through 609.
- Right-click any one of the selected row numbers, then choose "Delete".