#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 150
Default increase total rows

Hi,
can someone show me how to increase the maximum number of rows, more than
65,536?
thanks
Stan
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,203
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 150
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Increase rows by 1 when moving data from col. to col. Gayle Excel Discussion (Misc queries) 3 May 30th 08 10:16 PM
Formula to increase value according to total Mayte Excel Worksheet Functions 3 April 25th 08 10:21 PM
The increase number of rows in Excel wise_man Excel Discussion (Misc queries) 12 January 17th 07 03:38 PM
how do I increase the number of cells I want to total acking62 Excel Discussion (Misc queries) 3 August 23rd 06 02:44 PM
Increase the maximum number of rows Mortego Excel Discussion (Misc queries) 3 June 29th 06 03:03 PM


All times are GMT +1. The time now is 02:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"