NUMBER OF CELLS IN A WORKSHEET

[Guest]

I pasted some data from one worksheet into another and the new worksheet gave me 65k rows and an unknown but large number of columns. This made the file exceedingly large. how do i prevent that from haqppening?

 

[Ken Wright]

Every excel worksheet in the later versions has 65,536 rows of 256 columns.
Just ignore the empty ones.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

I pasted some data from one worksheet into another and the new worksheet gave

me 65k rows and an unknown but large number of columns. This made the file
exceedingly large. how do i prevent that from haqppening?

 

[Charlie]

Perhaps the old worksheet had the gridlines turned off, in
the new worksheet go to tools/options/view and uncheck
gridlines.

Charlie O'Neill

-----Original Message-----
I pasted some data from one worksheet into another and

the new worksheet gave me 65k rows and an unknown but
large number of columns. This made the file exceedingly
large. how do i prevent that from haqppening?

 

[Frank Kabel]

Hi
to shring the file size you may have a look at
http://www.contextures.com/xlfaqApp.html#Unused