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
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
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
>
> --
> dhunter84
> ------------------------------------------------------------------------
> dhunter84's Profile:
> http://www.excelforum.com/member.php...o&userid=33373
> View this thread: http://www.excelforum.com/showthread...hreadid=531997
>
Excellent thanks. Only prob is that the rows are infinite I can't select all of them and hide them, any suggestions?
Regards,
Dan
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
"dhunter84" <[email protected]> wrote
in message news:[email protected]...
>
> Excellent thanks. Only prob is that the rows are infinite I can't select
> all of them and hide them, any suggestions?
>
> Regards,
>
> Dan
>
>
> --
> dhunter84
> ------------------------------------------------------------------------
> dhunter84's Profile:
> http://www.excelforum.com/member.php...o&userid=33373
> View this thread: http://www.excelforum.com/showthread...hreadid=531997
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks