Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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


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
Inserting Rows in Excel 2003 Marilyn Excel Discussion (Misc queries) 5 February 7th 07 04:28 PM
hiding even (or odd) rows in excel 2003 9d1awd Excel Discussion (Misc queries) 5 February 2nd 07 06:25 PM
does excel 2003 support more than 65k rows? Landman Excel Discussion (Misc queries) 4 October 10th 06 05:57 PM
Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th Excellent1975 Excel Discussion (Misc queries) 0 June 21st 06 08:01 PM
How can I add additional rows beyond the 65,536 in excel 2003 pbhatt07 Excel Worksheet Functions 6 April 18th 06 11:20 PM


All times are GMT +1. The time now is 12:49 PM.

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

About Us

"It's about Microsoft Excel"