How to Configure Worksheet to Maximize Number of rows or Columns
 

Is there a way to define the number of rows or columns so that large data
files can be loaded without exceeding the limit on number of cells
allowed....ie if i have a file with a huge number of rows , but only several
columns ...there should be some way to read it in by reducing the number of
columns in the worksheet .

How to Configure Worksheet to Maximize Number of rows or Columns
 

The number of available columns and rows is fixed in Excel, and has nothing
to do with having fewer of one dimension.

If you need more than 65,000 rows, either use Excel 2007 (which has 1
million rows), or else use a database. There are also macros which will
split large data files among several worksheets.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"XRacr" wrote:

Is there a way to define the number of rows or columns so that large data
files can be loaded without exceeding the limit on number of cells
allowed....ie if i have a file with a huge number of rows , but only several
columns ...there should be some way to read it in by reducing the number of
columns in the worksheet .