Delete problem

[Loi]

Hi,
I have a spread sheet which is set up for 12 months of
year 2005 with fomulars and colors.

My questions are:
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

 

[Gordon]

Hi,
I have a spread sheet which is set up for 12 months of
year 2005 with fomulars and colors.

My questions are:
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!

 

[Gord Dibben]

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.

Edit>Delete>Entire 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

 

[JulieD]

Hi Loi

as for Q2 does tools / options and unticking Gridlines on the View tab give
you what you want?

cheers
JulieD