+ Reply to Thread
Results 1 to 2 of 2

Cutting and Pasting

  1. #1
    Registered User
    Join Date
    10-31-2016
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    32

    Cutting and Pasting

    I was wondering if there is a way to paste from excel without the cell background color and borders

    what I normally have to do is cut from excel, paste into word, use the paste options on the bottom left "text only" - select all text - reduce line spacing to 1 - cntrl H - More - Special - White Space - put one space in the "replace with" box, hit replace all, copy from word into my PO..

    This is a pain.... any help would be greatly appreciated

    Sorry all my images are gigantic - 1st image is pasting from excel with format - 2nd image is after doing all the stuff in word - 3rd image is pasting it into my PO.

    Thanks,

    Mike
    Attached Images Attached Images

  2. #2
    Forum Contributor
    Join Date
    11-27-2009
    Location
    Austin, Texas
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    409

    Re: Cutting and Pasting

    mmmm, why not just copy the data range in excel and then on your word document select no spacing from the style menu and then right click and paste text only, this way there is no background color.
    Thanks
    ==========
    Bigroo1958
    Austin, Texas
    ==========

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Cutting and pasting nightmares
    By OrderedChaos in forum Excel General
    Replies: 6
    Last Post: 07-18-2014, 08:54 AM
  2. cutting and pasting data
    By heathiep in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2012, 07:37 PM
  3. cutting and pasting in VBA
    By ben5496 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-27-2011, 05:07 PM
  4. Cutting and Pasting Cells
    By ross88guy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-16-2010, 11:12 AM
  5. Cutting and pasting cells
    By Hitch75 in forum Excel General
    Replies: 3
    Last Post: 08-19-2010, 07:45 AM
  6. Automatic cutting and pasting
    By gdelreal99a in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-27-2007, 09:38 PM
  7. Replies: 13
    Last Post: 08-14-2005, 06:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1