Cropping a worksheet

I have forgotten how to remove all unused rows and columns, below and to the
right of the used area. It's not practicable to drag the selection because
of the huge size of a worksheet. My Excel book doesn't tell me how to do
this.
Thanks
Gord.

You don't *remove*, but you can hide.

Select the *entire* column past your last wanted column and then,
<Ctrl> <Shift> <RightArrow>
This should select all the columns out to ColumnIV.
Right click in the selection and choose "Hide".

Same for rows, using the <DownArrow>.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"gord" <gord@no_spaming.com> wrote in message
news:V5udndRLsZhe6JbeRVn-rw@magma.ca...
> I have forgotten how to remove all unused rows and columns, below and to
the
> right of the used area. It's not practicable to drag the selection because
> of the huge size of a worksheet. My Excel book doesn't tell me how to do
> this.
> Thanks
> Gord.
>
>

"gord" <gord@no_spaming.com> wrote in
news:V5udndRLsZhe6JbeRVn-rw@magma.ca:

> I have forgotten how to remove all unused rows and columns, below and
> to the right of the used area. It's not practicable to drag the
> selection because of the huge size of a worksheet. My Excel book
> doesn't tell me how to do this.
>

Select the first column you want to delete, hold shift and press right
arrow. Ctrl-minus (minus being the - in the numerical keypad).

Select the first row, hold shift and press down arrow. Ctrl-minus


--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)

"Dodo" <dodo2u@-takethisNOSPAMout-freemail.nl> wrote in message
news:Xns96BBDBB2185B0dodo2ufreemailnl@130.133.1.4...
> "gord" <gord@no_spaming.com> wrote in
> news:V5udndRLsZhe6JbeRVn-rw@magma.ca:
>
Thanks to both of you.Works like a charm!
Gord