Baking a spreadsheet bigger

[Mjoza]

I'm using excel 2007 and just ran a report with 65k row and the problem is that it does not fit into one worksheet, excel has automatically added a new spreadsheet. How can I increase the number of rows in sheet 1 so that I can copy and paste the data in sheet 2 over to sheet 1 and analyze the data?

Thanks!

 

[pagrender]

Try saving it as: Save As Type: Excel Workbook (the 2007 version instead of the 2003 version).

Then, close the file and reopen it. Does that give you the 1,000,000+ rows?

 

[Mjoza]

Re: Making a spreadsheet bigger

That does the Job.

Thank you sooooo much!

 

[pagrender]

I ran into that problem many times myself.

Thanks for the feedback!