close

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 quot;Cntrl Endquot; 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.

Copy just the data you want from the original and paste into a new sheet.
--
Kevin Backmannquot;Woody13quot; wrote:

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

I meant to say, paste into a sheet in a new workbook file.
--
Kevin Backmannquot;Kevin Bquot; wrote:

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

See your other thread

--
Regards Ron de Bruin
www.rondebruin.nlquot;Woody13quot; gt; wrote in message ...
gt;I have a workbook and its 34mb; too big. Problem is that while I only use
gt; down to row 250 on most sheets, if I quot;Cntrl Endquot; the curser/active cell
gt; jumps to the bottom of the spreadsheet (row 65,000 ). I've tried to manually
gt; delete the cells and rows but it doesn't seem to work. Any help is
gt; appreciated.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()