ExcelBanter - increase total rows

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - increase total rows (https://www.excelbanter.com/excel-discussion-misc-queries/257975-increase-total-rows.html)

Stan

increase total rows

Hi,
can someone show me how to increase the maximum number of rows, more than
65,536?
thanks
Stan

JLatham

increase total rows

I presume you have Excel 2007?

Open your .xls file in Excel 2007, save the file as an Excel 2007 file type
(.xlsw, .xlsx, etc) using File Save As. Close the file and reopen it you
should now have 2007's 1M+ rows available.

"Stan" wrote:

Hi,
can someone show me how to increase the maximum number of rows, more than
65,536?
thanks
Stan

Stan

increase total rows

Thanks!!!

"JLatham" wrote:

I presume you have Excel 2007?

Open your .xls file in Excel 2007, save the file as an Excel 2007 file type
(.xlsw, .xlsx, etc) using File Save As. Close the file and reopen it you
should now have 2007's 1M+ rows available.

"Stan" wrote:

Hi,
can someone show me how to increase the maximum number of rows, more than
65,536?
thanks
Stan

All times are GMT +1. The time now is 04:52 PM.