Re: Fixing cell sizes for cut and paste?

Try the "Paste Special" feature...use the text option.  It's much
easier than reformatting after each paste.

using mouse: right click on the destination cell, click Paste Special,
click text, then OK.

using keyboard: Alt...e...s...t...Enter

To answer your questions, changing the cell options will not force
future pastes to conform to your style.  When you paste, the cell
takes the charasteristic of the source, not the destination.  The only
way to preserve the formatting is by using the Paste Special function.
 There are two different dialog boxes that appear depending on whether
you are pasting from inside or outside your active Excel session. 
>From inside your excel, you can paste values.  From outside, text is
the option you should use.



Tmuld wrote:
> Hello,
> 
> I have to create a spreadsheet with addresses from the web.  I am
> going from site to site putting in Names, Contacts, Email and URL.
> 
> The problem is when I cut and paste from certain sites - the cell size
> becomes huge and overwrites other data in the record.
> 
> I selected all the spread sheet - right clicked - chose format cell -
> chose the alignment tabl - selected GENERAL for hoizontal alighnment,
> left veritcal blank, and only had 'shrink to fit' checked off.
> 
> Should this not now force all cut and pasted items to shrink to fit in
> every cell?
> 
> This is what I want to do.
> 
> Thanks,
> 
> Tmuld.