Excel for People who don't know anything
December 2, 2011 9:05 AM Subscribe
Excel issue. Tried looking on the internet, had no success. Can y'all help? Selecting and deleting multiple nonadjacent rows.
posted by crush-onastick to Technology (18 answers total) 3 users marked this as a favorite
I need to remove every tenth row from some spreadsheets which have between 500 and 5000 rows. Each row has 10 columns. Each column has text in it. I have been doing this for a couple days and at first it was working. I was clicking the first row to select the row, then holding down ctrl, clicking the next row (10 rows down from the first row selected), and so on, then hitting ctrl-x and removing the rows. Worked fine--if an extremely tedious task.
It is no longer working. When I click the first row, it selects the row. When I hit ctrl and click the next row, it selects the next row as well but there is now a box around the first cell in the next row and when I hit ctrl-x, I get an error message: "The command you chose cannot be performed with multiple sections. Select a single range and chose the command again."
I am clicking the row number to select the row and as far as I can tell, nothing is selected or highlight prior to my clicking the first row. I am able to select a row, and hold down the shift key to select multiple adjacent rows for cutting, but I cannot select multiple nonadjacent rows. I was able to do it before and I see the behavior across more than one spreadsheet in the same directory.
It's driving me nuts! any suggestions (other than getting the proper software tool or software to do the job, which is never in a million years going to happen).