+ Reply to Thread
Results 1 to 4 of 4

how can you add more rows in excel 2000?

  1. #1
    Khody
    Guest

    how can you add more rows in excel 2000?

    Is there a way to add more rows to excel's already 65536 rows? In other
    words can you expand excel to have more rows then it already has.

  2. #2
    Harald Staff
    Guest

    Re: how can you add more rows in excel 2000?

    Impossible, sorry.

    HTH. Best wishes Harald

    "Khody" <Khody@discussions.microsoft.com> skrev i melding
    news:8A9B7CC9-6832-47D4-830C-7DE692D5616F@microsoft.com...
    > Is there a way to add more rows to excel's already 65536 rows? In other
    > words can you expand excel to have more rows then it already has.




  3. #3
    tjtjjtjt
    Guest

    RE: how can you add more rows in excel 2000?

    Unfortunately, you can't increase the number of rows. Versions 2002 and 2003
    have the same limitation.

    tj

    "Khody" wrote:

    > Is there a way to add more rows to excel's already 65536 rows? In other
    > words can you expand excel to have more rows then it already has.


  4. #4
    Howard
    Guest

    RE: how can you add more rows in excel 2000?

    However - the chances are that if you're trying to use more than 65,000 rows
    (or whatever) you'll not be entering these by hand - but by extraction from
    somewhere else.

    If that somewhere else is a database - leave the data where it is - and use
    Pivot Table/Olap cubes to give a drilldownable table. The database can
    contain way beyond 65,000 rows - and as long as EACH drill down does'nt
    stretch the 65k limit (which is quite likely in most cases) everything is
    fine.

    Having said all that - cmon Bill - isnt it about time Excel moved beyond
    that barrier? Moor'e law would suggest we should be having AT LEAST a million
    rows capability by now. (yes, yes I know - if you're using that much data you
    should be using a database anyhow - but I LIKE spreadsheets and dont want to
    leave home)


    Howard at work

    "tjtjjtjt" wrote:

    > Unfortunately, you can't increase the number of rows. Versions 2002 and 2003
    > have the same limitation.
    >
    > tj
    >
    > "Khody" wrote:
    >
    > > Is there a way to add more rows to excel's already 65536 rows? In other
    > > words can you expand excel to have more rows then it already has.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1