How do increase the number of rows allowed in a worksheet?

[PayPaul]

I'm trying to paste in a lot of rows from a single column into another
worksheet. It seems as though the amount of those rows exceeds the number of
rows present in the worksheet. Is there a workaround? Is there a way of
adding additional rows to the maximum default number allowed in Excel 2003?

 

[T. Valko]

Excel 2003 is limited to 65,536 rows per worksheet. There is no way to
extend this number. You can either use additional worksheets or "upgrade" to
Excel 2007 which has 1,000,000+ rows per worksheet.

 

[Mike Rogers]

Los Alamitos

If the 65000+ is not enough the only work round is to invest in xl2007, it
has over 1,000,000 rows.

Mike Rogers

 

[Ron Rosenfeld]

I'm trying to paste in a lot of rows from a single column into another
worksheet. It seems as though the amount of those rows exceeds the number of
rows present in the worksheet. Is there a workaround? Is there a way of
adding additional rows to the maximum default number allowed in Excel 2003?

Only by upgrading to XL 2007
--ron

 

[Gord Dibben]

Are you pasting from one sheet into another sheet in the same version of Excel?

The number of rows to be pasted cannot possibly exceed the number of rows in the
target sheet in that case.

What is the error message you are getting when you try to paste?


Gord Dibben MS Excel MVP