Thanks Roger - will give it a try


"Roger Govier" <roger@technologyNOSPAM4u.co.uk> wrote in message
news:%23wfoq0SNGHA.2788@TK2MSFTNGP11.phx.gbl...
> Hi Grant
>
> I don't have an Access or SQL table to test it on, but copying wrapped
> text from one sheet to another in Excel, straight Paste leaves it wrapped,
> but Paste Special>Values pastes it as unwrapped.
>
> If that doesn't work, maybe recording a macro for the steps you now take,
> and using that as you own "Paste Special" by adding to a button on your
> Toolbar would help.
>
> --
> Regards
>
> Roger Govier
>
>
> "Grant Morgan" <grantmorgan@noemail.noemail> wrote in message
> news:OgIpiQQNGHA.2828@TK2MSFTNGP12.phx.gbl...
>> This is what I'm currently having to do - over 10 to 20 times a day (ad
>> hoc spreadsheets are a major part of day to day work).
>>
>> What I'm looking for is a setting in excel, or the new workbook template
>> to allow pasting text without wrapping. ie. without having to re-format
>> after pasting
>>
>> Cheers
>> G
>>
>>
>> "Pete_UK" <pashurst@auditel.net> wrote in message
>> news:1140306301.709256.107590@g43g2000cwa.googlegroups.com...
>>> You can highlight the complete sheet by clicking the intersection of
>>> the row and column identifiers, then Format | Cells | Alignment (tab)
>>> and uncheck Wrap text - a few seconds' work.
>>>
>>> Hope this helps.
>>>
>>> Pete
>>>
>>
>>
>
>