Thread: In my excel sheet I only want to see used rows and column.thanks
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default In my excel sheet I only want to see used rows and column.than
The conversion program is not doing a very good job then.

Have you tried saving the file in Excel 95 (or earlier) format? -
these files only had up to 16k rows, so it might speed things up by a
factor of 4.

Pete

On Jun 26, 10:46*am, Faisal wrote:
I physically want 10 columns and 100 rows in my worksheet to run a particular
conversion program. Otherwise it goes through every blank cell.



"Bernard Liengme" wrote:
Please elaborate
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Joe" wrote in message
...- Hide quoted text -

- Show quoted text -

Reply With QuoteReply With Quote