Delete problem
Hi,
I have a spread sheet which is set up for 12 months of year 2005 with fomulars and colors. My questions a 1/ I am not sure why the sheet is too big. (10 KB). Do you think that it has a normal size because of the fomulars and color? Can we compact the sheet, so its size will be smaller as we do with Access? 2/ In my sheet, I see a extra border line. I tried to delete it as many different ways, but it is still there. Ex: I made a low border from cell A1 to A50. I would like to delete the border line after cell A51 to ......cell A 256. Please show me how to do it. Loi |
Loi wrote:
Hi, I have a spread sheet which is set up for 12 months of year 2005 with fomulars and colors. My questions a 1/ I am not sure why the sheet is too big. (10 KB). 10kb is a *very* SMALL workbook! I routinely deal with workbooks in the 4-5,000 kb size! |
Loi
Excel can over-estimate the used range of your worksheet if columns/rows have previously been used but are no longer in service. Hit CRTL + END to see where Excel takes you. May be far below and right of your actual data range. Go to bottom of actual data range(A51?). Select then SHIFT + END + Downarrow. EditDeleteEntire Rows. Do same for Columns to the right of your actual data range. If more than one sheet, perform steps on all sheets. NOW! IMPORTANT!! Save the workbook and close it. Re-open and used range should be much smaller and file-size reduced. BTW.........10KB is very small.........typo? Maybe 10MB? Gord Dibben Excel MVP On Tue, 7 Dec 2004 09:40:58 -0800, "Loi" wrote: Hi, I have a spread sheet which is set up for 12 months of year 2005 with fomulars and colors. My questions a 1/ I am not sure why the sheet is too big. (10 KB). Do you think that it has a normal size because of the fomulars and color? Can we compact the sheet, so its size will be smaller as we do with Access? 2/ In my sheet, I see a extra border line. I tried to delete it as many different ways, but it is still there. Ex: I made a low border from cell A1 to A50. I would like to delete the border line after cell A51 to ......cell A 256. Please show me how to do it. Loi |
Hi Loi
as for Q2 does tools / options and unticking Gridlines on the View tab give you what you want? cheers JulieD "Loi" wrote in message ... Hi, I have a spread sheet which is set up for 12 months of year 2005 with fomulars and colors. My questions a 1/ I am not sure why the sheet is too big. (10 KB). Do you think that it has a normal size because of the fomulars and color? Can we compact the sheet, so its size will be smaller as we do with Access? 2/ In my sheet, I see a extra border line. I tried to delete it as many different ways, but it is still there. Ex: I made a low border from cell A1 to A50. I would like to delete the border line after cell A51 to ......cell A 256. Please show me how to do it. Loi |
All times are GMT +1. The time now is 03:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com