deleting unused cells / getting rid of inactive cells

[Woody13]

I have a workbook and its 34mb; too big. Problem is that while I only use
down to row 250 on most sheets, if I "Cntrl + End" the curser/active cell
jumps to the bottom of the spreadsheet (row 65,000+). I've tried to manually
delete the cells and rows but it doesn't seem to work. Any help is
appreciated.

[Kevin B]

Copy just the data you want from the original and paste into a new sheet.
--
Kevin Backmann


"Woody13" wrote:

> I have a workbook and its 34mb; too big. Problem is that while I only use
> down to row 250 on most sheets, if I "Cntrl + End" the curser/active cell
> jumps to the bottom of the spreadsheet (row 65,000+). I've tried to manually
> delete the cells and rows but it doesn't seem to work. Any help is
> appreciated.

[Kevin B]

I meant to say, paste into a sheet in a new workbook file.
--
Kevin Backmann


"Kevin B" wrote:

> Copy just the data you want from the original and paste into a new sheet.
> --
> Kevin Backmann
>
>
> "Woody13" wrote:
>
> > I have a workbook and its 34mb; too big. Problem is that while I only use
> > down to row 250 on most sheets, if I "Cntrl + End" the curser/active cell
> > jumps to the bottom of the spreadsheet (row 65,000+). I've tried to manually
> > delete the cells and rows but it doesn't seem to work. Any help is
> > appreciated.

[Ron de Bruin]

See your other thread

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Woody13" <[email protected]> wrote in message news:[email protected]...
>I have a workbook and its 34mb; too big. Problem is that while I only use
> down to row 250 on most sheets, if I "Cntrl + End" the curser/active cell
> jumps to the bottom of the spreadsheet (row 65,000+). I've tried to manually
> delete the cells and rows but it doesn't seem to work. Any help is
> appreciated.