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.
- Sep 29 Fri 2006 20:09
deleting unused cells / getting rid of inactive cells
close
全站熱搜
留言列表
發表留言