View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
XRacr XRacr is offline
external usenet poster
 
Posts: 3
Default 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 .