Cropping a worksheet

  • Thread starter Thread starter gord
  • Start date Start date
G

gord

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!
==============================================
 
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.
Click to expand...

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
 
Back
Top