View Single Post
  #2   Report Post  
wfcmark wfcmark is offline
Junior Member
 
Posts: 7
Default

Hi,

What about 'format cells' 'Alignment' and check "shrink to fit"? That is under Text Control - is that any use???

Cheers,

Mark
Quote:
Originally Posted by copying+pasting into cells use autofit
I am trying to set up a sheet into which i can copy and paste various items
into a group of cells? and upon being pasted into the group the item will be
automatically shrunk to fit the size of the cells it was pasted into, rather
than expanding them to fits its size.
Any ideas anyone??????