Can you turn off word wrap when pasting into Excel??

[Duke Carey]

Every time I paste data from an Access table or query into Excel Excel
formats each cell to turn wrapping on, so I have to manually re-format and
turn it off.

Is there a registry setting or some other trick to disable this behavior?

 

[DM]

once you paste, click on format, cell, alignment and uncheck the wordwrap
box (may appear as gray or highlighted if you select more than one cell).

 

[Duke Carey]

Thanks for the response, but it is exactly that sequence of steps I'm tired
of executing. It seems reasonable that there might be a registry hack to
override the standard behavior

 

[DM]

my apologies, my ole eyes skipped the last sentence of your first paragraph.

have you tried to export the query to excel instead of copy and paste? I
cant remember if you get the same result (wrapped text) as I quit working
with access to excel .

 

[Duke Carey]

My preference would be to link the query to Excel using parameters entered
into specific cells on the worksheet; however, the query has a sum of a
calculated column and Microsoft Query throws up on that column. That forces
me to go into Access, enter the query criteria in the query designer, run the
query, and copy-paste into Excel.

Eventually this will go into SQL Server 2005, and I'll manage the data
connections in VBA, but for now the client needs me to work with an Access db.

 

[Jake the Snake]

after copy, right click and select "paste special". select values only, and
u shouldn’t have any auto-format issues.

--



Most Sincerely,

Jacob Cardwell
District Manager - MD/E - DC

443.928.4765 Direct
410-823.3614 Fax
(e-mail address removed)

 

[mark]

.... Very old post, just a note on this:
Highlight the row or rows
Right click on the rows, select "row height"
--if you don't see "row height," try clicking on the row # on the left
Do not change the value in the little box - just hit "ok"
This is all you have to do - Excel will no longer auto-select the row height.