How to Configure Worksheet to Maximize Number of rows or Columns

G

Guest

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 .
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rows and columns on worksheet 1
compare all data in one worksheet to another 1
Changing number of available columns & rows 5
Number of columns available in a worksheet 5
Copy/Paste with Hidden Rows/Columns Excel 2007 3
Set number of columns/rows? 4
Transposing Rows and Columns Using Paste Special 1
splitting long columns 3

Top