Pasting text from Access/SQL - word wrap problem

G

Grant Morgan

Hi

When I've copied data from an access or SQL table, and paste it into a new
excel 2003 document, it always wraps the text.

Is there a way to force it to paste normal (ie. non-wrapped) text?

Cheers
Grant
 
P

Pete_UK

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
 
G

Grant Morgan

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
 
R

Roger Govier

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.
 
G

Grant Morgan

Thanks Roger - will give it a try


Roger Govier said:
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.
Click to expand...
 
Top