Delete problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Loi - 07 Dec 2004 17:40 GMT

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

Reply to this Message

Gordon - 07 Dec 2004 18:38 GMT

> 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!

Reply to this Message

Gord Dibben - 07 Dec 2004 18:50 GMT

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

>Hi,
>I have a spread sheet which is set up for 12 months of
[quoted text clipped - 17 lines]
>Please show me how to do it.
>Loi

Reply to this Message

JulieD - 08 Dec 2004 01:35 GMT

Hi Loi

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

cheers
JulieD

> Hi,
> I have a spread sheet which is set up for 12 months of
[quoted text clipped - 17 lines]
> Please show me how to do it.
> Loi

Reply to this Message