ExcelBanter - copy and paste into excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - copy and paste into excel (https://www.excelbanter.com/excel-discussion-misc-queries/58717-copy-paste-into-excel.html)

copying+pasting into cells use autofit

copy and paste into excel

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]

copy and paste into excel

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

Quote:

Originally Posted by copying+pasting into cells use autofit

All times are GMT +1. The time now is 06:32 AM.