cell deletion

**stevesunfold** · 10-06-2008, 08:19 AM

hi guys
is it possible to delete/remove all non use cells
for example if i only want the cells A1 THROUGH TO O31
all the rest removed??
thanks

**Andy Pope** · 10-06-2008, 08:27 AM

No, but you can hide the rows and columns beyond the range of cells.

**stevesunfold** · 10-06-2008, 08:33 AM

but that doesnt help andy because all it does then is gives you the next level of cells
or am i missing something?
perhaps not understanding what you mean

**Andy Pope** · 10-06-2008, 08:34 AM

I think you need to explain more fully what you want.

You said you wanted A1:O30 which means rows 31:65536 and columns P:IV can be hidden.

**Dav** · 10-06-2008, 08:39 AM

I would have answered the same as Andy's answer. It works in that if you hide all the columns from Q throught to the end right (IV in 2003 but something bigger in 2007), then select the rows from 32 to the bottom (65536 in 2003) that will display the range you want.

What do you want to do?

Regards

Dav