Deleting Rows in Excel

Cambridge

Local area resident woman, Elena "Lany" Mamlok, has decreased her effort by nearly 50% in manipulating a file.

"So I get this data dump of a report once a month and it's not formatted for anything useful. It costs me at least a day to reformat into something pretty... well, pretty as far as Excel can be attractive," Mamlok whined.

This particular step is where Mamlok deletes over 100 non-consecutive rows. "There's practically no data integrity left by the time I'm done deleting all this crap. I mean, the amount of human error in this process is huge."

Mamlok went on to state that this report does eventually make its way to Senior Vice Presidents in her company.

When asked if she could further explain how she cut her manipulation efforts down dramatically, Mamlok said, "Well, I used to highlight the row and then right click and select delete. Now I just right click, which selects the whole row and gives me the delete option at the same time. So I just saved half."

Half, indeed.