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

Discussion in 'Access General' started by Duke Carey, Mar 14, 2008.

  1. Duke Carey

    Duke Carey Guest

    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?
     
    Duke Carey, Mar 14, 2008
    #1
    1. Advertisements

  2. Duke Carey

    DM Guest

    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).
     
    DM, Mar 14, 2008
    #2
    1. Advertisements

  3. Duke Carey

    Duke Carey Guest

    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
     
    Duke Carey, Mar 14, 2008
    #3
  4. Duke Carey

    DM Guest

    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 .
     
    DM, Mar 14, 2008
    #4
  5. Duke Carey

    Duke Carey Guest

    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.
     
    Duke Carey, Mar 14, 2008
    #5
  6. 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
     
    Jake the Snake, Mar 14, 2008
    #6
  7. Duke Carey

    Guest

    .... 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.
     
    , Apr 17, 2013
    #7
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.