copying formulas from Page 1 to next page

[jterr]

Thanks for the help with the formulas in previous thread.
Now I started using formulas in the first page and found there is not enough cells, so I need to go to the next page in the worksheet and copy all the formulas.
I have already put text and numbers in the 1st page.
I get the copy function to work ,but when I go to paste nothing there.
Do I have to remove all other data then copy or do I just need to make a new worksheet with endless cells?
Not sure where to go here, so I'm again asking for your help.

Using Excel 10

[FDibbins]

ummm not enough cells?????? you have 17 179 869 184 (=1048576 rows x 16384 columns)...thats 17 BILLION cells on 1 sheet, and you used them all up?

[FDibbins]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-gene...worksheet.html

Thread Closed.