View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default How many rows are available from a tab in Excel 2003?

In Excel 2003 and earlier (to 97) you are limited to 65536 rows in
each sheet. There is no way of increasing this limit. You could think
about splitting your data and having part of it in Sheet1 and the rest
of it in Sheet2, or, if you only have a few columns then you could put
the excess rows to the right of the main data.

Hope this helps.

Pete

On May 7, 10:25*am, Cpviv wrote:
Hi,

I need 65700 numbers of rows for one tab in Excel 2003. However, when I copy
the rows information from another tab for combination, this combined tab
gives me not the correct numbers of rows.

How many rows are available from a tab in Excel 2003?
In what way, can I squeeze in these 65700 numbers of rows in a tab in Excel
2003?
--
Thank you,
Cpviv