copy and paste into excel

[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??????

[[email protected]]

Hi, try copy data and paste them like: Edit/Paste Special/Values. It
does not change the size of the columns.

Marian

[wfcmark]

Hi,

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

Cheers,

Mark
copying+pasting into cells use autofit Wrote:
> 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??????


--
wfcmark