Removing empty cells
 

A colleague has a ss with all possible (20) academic subjects across the top
row and pupils' names down the first column.

Inevitably there are blanks as Sally only does French German and English
whereas Amy does Physics Chemistry and Biology.

How can my colleague remove the blank cells?

I know there's a solution to this, but cannot remember what it is - I had a
disk crash and lost the file with the solution!!! (I now have proper
back-ups...)

Thanks,

Richard

Removing empty cells
 

Removing the blanks would either affect the cells below, or those to the
right. In either case, the data will be inappropriate.
Why do you want to remove the blanks?
--
David Biddulph

"rehaylock" wrote in message
...
A colleague has a ss with all possible (20) academic subjects across the
top
row and pupils' names down the first column.

Inevitably there are blanks as Sally only does French German and English
whereas Amy does Physics Chemistry and Biology.

How can my colleague remove the blank cells?

I know there's a solution to this, but cannot remember what it is - I had
a
disk crash and lost the file with the solution!!! (I now have proper
back-ups...)

Thanks,

Richard