Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Loi
 
Posts: n/a
Default 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   Report Post  
Gordon
 
Posts: n/a
Default

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   Report Post  
Gord Dibben
 
Posts: n/a
Default

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   Report Post  
JulieD
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Row Autofit problem Excel 2003 Matthias Klaey Excel Discussion (Misc queries) 0 January 19th 05 06:33 PM
delete row contains specific word in an macro Jean-Francois Excel Discussion (Misc queries) 4 January 12th 05 12:40 AM
Saving to a network share without delete permssions SteveHoot Excel Discussion (Misc queries) 1 January 5th 05 10:50 PM
Paper Tray selection Problem, Michael Hoffmann Excel Discussion (Misc queries) 4 December 3rd 04 10:08 PM
File is locked for Editing by user problem Mirth Excel Discussion (Misc queries) 1 December 3rd 04 05:45 PM


All times are GMT +1. The time now is 02:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"