Greetings,
I use Excel & have a very big excel file that was imported from access database and has a lot of blank rows that I tried to delete. I used the following Excel built in method :

F5 ->Special ->Blanks (blank cell will be highlighted)
Ctr+ 9 to hide the rows -> select visible command (to select only visible rows)
Ctr +C and Ctr+V to a new worksheet.

It works fine, except there is data missing for the columns highlighted in red on my sample attachment.

can this be corrected w/o recording a Macro?

Thanks,

My solution is to import the correct data from Access so you will not have the clean-up problem in Excel.
Do you own the data base so that you can fix the process that does the exporting? If not, can you link to the data base from a new data base and create your own query that excludes all the blanks you see in Excel?

I would export clean delimited data, using a delimiter character not found in the data (such as the tilde ~ character) into a text file, and import that into Excel.

Good luck.
Jerry

Thank you for your reply. I recorded a macro in Excel and it is working now.


Regards,

OCM