How do I make a worksheet have unlimited lines
I need to make copy several worksheets and paste into 1 sheet to make 1 very
large worksheet. My problem is when I exported the data from Access I was
not allowed to export any more than 65000 records at 1 time. Now when I copy
1 sheet of 65000 and try to paste into the other worksheet under the current
records the stupid program won't let me because there are not enough rows to
paste into. This never happened in older versions of excel. I don't know
what moron changed the sheet size settings but I would really appreciate help
to make my worksheet have unlimited rows like tho older versions did.
|