Creating a form / card

[dhunter84]

Hi there.

Was hoping someone could help, been trying for ages. All I want to do
is remove all the excess cells and space from my work-sheet so that I
get a nice tidy form / card.

Thanks so much.

Dan

 

[Paul B]

Dan, you can't remove them but you can hide them, select the rows you want
to hide and format rows hide, do the same for the columns, if this is for
printing you could set the print area to your data, select your data then
file set print area
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[dhunter84]

Excellent thanks. Only prob is that the rows are infinite I can't selec
all of them and hide them, any suggestions?

Regards,

Da

 

[Paul B]

Dan,
The rows are not infinite, there are only 65,536
Select a cell below your data, hold down the shift key and control key and
press the down arrow, format rows hide
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003