Re: Removing Blank Cells

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: David McRitchie (dmcritchie_at_msn.com)
Date: 08/04/04 

Date: Wed, 4 Aug 2004 01:57:26 -0400

The real check is Ctrl+End which will show you what
Excel is actually using. If you have your last cell
way out into empty space then you would be wasting
space. Another way of doing a cursory examination
would be to look at the scroll bars as you go down or
across.

If you need to make another cell your last cell to drop
of unused rows columns that Excel thinks you are using
see Make Last Cell in
    http://www.mvps.org/dmcritchie/excel/lastcell.htm#makelastcell

If you have 3 sheets and use only 2 sheets you could drop that
unused sheet to make the file smaller.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Frank Kabel" <frank.kabel@freenet.de> wrote in message news:%23fxGxhWeEHA.3840@TK2MSFTNGP10.phx.gbl...
> Hi
> you can't remove them (you can hide them if you like9. Also they do not
> add up to the size of your worksheet 8at least as long as your used
> range is correct)
>
> --
> Regards
> Frank Kabel
> Frankfurt, Germany
>
>
> Jeff Mortenson wrote:
> > I would like to know if there is a way to remove the blank
> > columns and rows from a worksheet. There really is no
> > need for this many blank rows in the workpaper I am
> > working on and I assume it contributes to the overall size
> > of the spreadsheet.
> >
> > Thanks in advance.
>

Relevant Pages

  • Re: Output form to excel with range ????
    ... here is a long post with lots of useful code for exporting to excel. ... Dim varGetFileName As Variant 'File Name with Full Path ... Set objXLws = objXLWkb.ActiveSheet ... For Each cell In objXLws.Range ...
    (microsoft.public.access.formscoding)
  • Re: Access to Excel
    ... by cell I mean the cell in the excel sheet in this case cell G8 I am trying ... By form I mean an excel sheet that has been designed with lines and boxes ... "John Nurick" wrote: ... John Nurick [Microsoft Access MVP] ...
    (microsoft.public.access.externaldata)
  • RE: More Help Needed..please
    ... Call SeeDiff ... Private Sub Workbook_Open ... By the way, if for some reason you ever select a cell in column A, the above ... I was going to use both Worksheet_Change & Workbook_Open in an Excel file ...
    (microsoft.public.excel.programming)
  • Re: Getting around Dependency Tree Performance Problems
    ... Bug in Excel VBA that causes the VBE title bar to be refreshed each time ... unless the calculation is initated from VBA: ... VBA UDFs are called by Excel even when their arguments are uncalculated. ... Using these techniques will reduce the worst-case timing for the 14000 cell ...
    (microsoft.public.excel.programming)
  • Re: Convert to Number Issue
    ... How do I programmatically get numbers recognized as numbers in a excel ... It contains some sort of data dump which is not recognized in excel ... delete the last number in each cell and replace the same number. ... But it is a lot of handwork to do that in all thesse sheets and files.... ...
    (microsoft.public.excel.programming)