Move data into empty rows when i delete old data

Hi all,

I am working on a project for work and every week i need to remove old data from a spreadsheet. i do this by filtering the completed files and deleting. However when i "show all" there are big gaps between existing data. what i would like is the remaining data to automatically move to the top of the sheet leaving no gaps (and ensuring that the data in adjacent cells remains adjacent to it). could anyone help please? i'm fed up of copy and paste!!

there are 17 columns and 1000 rows

Please help folks!!

Hi assuming you have data in column A and the blanks appear here you can use this:

Please Login or Register  to view this content.

Regards,
Simon

Hi simon,

many thanks for the help, i neglected to mention that i would like there to remain a constant of 1000 rows so deleting them wouldn't help. is there anything else i can do?

You could always use Data | Sort that way all the blanks will then be at the bottom!

Regards,
Simon