Any way to quickly get rid of lot of black cells?

K

kevs1

I have a workbook with many columns and rows. For some reason I got lot of uneeded black cells interspered among it all.
so I'm manually moving cells up or I am delecting these blanks and shifting important cells upward.
Anyway to just tell excel to delete all blank cells and shift all filled blank cells upward? thanks.

OFFICE 2004
MAC OS 10.4.11
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

multiple bugs in Excel 2008 (12.0.1) 2
SELECTION macro 1
Orphaned Links Driving me Crazy 2
ANY ONE ELSE FOUND THESE PP08 bug? 1
Problem getting Outlook2007 data from slave drive to new computer 1
Make macro go to first empty cell in column? 5
Lots of Frustration - Lots of Arrays, Dynamic Ranges Don't Work, Help With Options 6
MS Word Tables from C#: Best way to get cursor out of table ... 1

Top