copy and paste into excel

  • Thread starter copying+pasting into cells use autofit
  • Start date
C

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

korenie.cierne

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

Marian
 
W

wfcmark

Hi,

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

Cheers,

Mark
 
Top