Desperately need a command or something!
Mitch,
why dont you go to tools, macro, record marcro and create a shortcut that
deletes 22 rows. In this process it also allows you to create a keyboard
command that will initiate the macro. You'd have to put your cursor on the
correct row, run the command, and then go to the next row. If you have a
large set of data it could still take a little while, but will be simpler
than just hi-lighting the rows and deleting them.
Hope this helps.
Red
"mitch phelps" wrote:
I need to delete muliple rows in the excel file and would like to repeat the
pattern throughout the file as I'm looking for specific rows to keep and I
have tons of rows. I'm looking for a shortcut instead of spending hours
deleting rows.
For example: I need to be able to delete 22 rows then skip one row, delete
22 rows then skip one row, and so on.
I am really needing help!
|