Re: Have 5000 extra rows




On 4/18/07 10:30 PM, in article C24C2271.24350%kevs@xxxxxxxxxxx, "kevs"
<kevs@xxxxxxxxxxx> wrote:

On 4/18/07 12:23 AM, in article
1176880987.717295.10420@xxxxxxxxxxxxxxxxxxxxxxxxxxxx, "PhilD"
<phildeaves@xxxxxxxxxxx> wrote:

On Apr 18, 4:20 am, kevs <k...@xxxxxxxxxxx> wrote:
"Make sure there are no formulas or defined names that refer to cells
beyond your last cell. If so, correct them."

I don't know what this means.

This means that if, say, cell A1 has a formula doing something with a
value in cell A65536, then Excel understands the end of your
spreadsheet as row 65536. Change the formula so that it only refers
to things in the region you want.


Actually right now I have 65,000 Rows, which is 64,000 more than I'd like.

(I did paste some new columns in, but how I got 64,000 new black rows making
the file a 500k file to a 4mb file is unimportant for now)


Ah, if the rows are black then you inserted immediately below a
formatted row, and not knowing any better Excel assumes that you want
the same formatting in every new row, too. That formatting in turn
makes Excel believe that those rows contain stuff you want, and thus
understands the end of your spreadsheet as row 65536. Delete the
formatting.

PhilD

--
<><

Ok Phil, that's a bit over my head.

JE, and Phil...

Ok, lets make it simple.

What is easy way to tell Excel that I want to keep all cells with stuff in
them, (text), and delete all empty cells, thus reducing the file size by 95%






OS 10.4.7
Office 2004


Hi kevs -

Just thought I'd try to reword a few points for clarification:

First, each Excel worksheet has 256 columns & 65,536 rows. There is nothing
you can do to change that. They can have a Hidden attribute applied to them,
but they are still there. Since Hiding columns & rows doesn't *remove* them
from the sheet, doing so will *not* reduce the size of the file.

Also, from your previous post in this thread:

(I did paste some new columns in, but how I got 64,000 new black rows making
the file a 500k file to a 4mb file is unimportant for now)

Do you mean "black" or is this a typo & you actually meant "blank"? Either
way, you're copying from your browser again, aren't you? If so, you're
probably getting all kind so additional "junk" above & beyond what you
"think" you're copying. I believe *THAT* is what's adding to the size of
your file.

Regards |:>)
Bob Jones
[MVP] Office:Mac

.

Relevant Pages

  • Re: Word list to Excel
    ... In your original post, you said "I have a long list of words in a Word 2007 file". ... Not sure what the formatting was but there was no crowding or other physical hinderances. ... click on whatever Excel cell you want to use as the starting point and paste the list. ... Only in that case, or by selecting the formula bar, would everything go into one cell. ...
    (microsoft.public.excel)
  • Re: Paste formatted text from Word into Excel.
    ... I am pasting into a cell, ... Excel with the features already marked. ... Formatting part of the text in a cell is clunky in Excel, ...
    (microsoft.public.word.docmanagement)
  • Re: Programmatically create html as input to Excel
    ... The data file used to be output sent directly to a printer. ... I'm enhancing this program to have Excel be a third target. ... Your best bet is to turn on the macro recorder and do some formatting, ... indicate that if a cell in column 10, 11, or 13 is numeric, it should be ...
    (microsoft.public.excel.programming)
  • Re: Word list to Excel
    ... I copied and pasted this list off of a web page into cell A1 in Excel. ... Not sure what the formatting was but there was no crowding or other physical ... exporting but I can't figure theat out either. ...
    (microsoft.public.excel)
  • Re: Too many different cell formats
    ... You receive a "Too many different cell formats" error message in Excel ... In Microsoft Excel, when you format a cell or a range of cells, ... A combination is defined as a unique set of formatting elements that are applied to a cell. ...
    (microsoft.public.excel.misc)