Hi Guys,

Is there a way to remove vacant/empty cells quickly. I'm copying and pasting data from elsewhere that leaves every 6th cell in the column empty. Currently I'm scrolling down and Edit>Delete>Shift Cells up. Can I select the whole column and do it with a shortcut?? With approximately 10,000 entries I'm sure you can see why this would be handy. Unfortunately I'm a VERY basic excel user so I need your expertise.

Thanks

Crania