Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
delete row contains specific word in an macro | Excel Discussion (Misc queries) | |||
Saving to a network share without delete permssions | Excel Discussion (Misc queries) | |||
Paper Tray selection Problem, | Excel Discussion (Misc queries) | |||
File is locked for Editing by user problem | Excel Discussion (Misc queries) |