+ Reply to Thread
Results 1 to 3 of 3

Copying names without borders

  1. #1
    Registered User
    Join Date
    05-11-2017
    Location
    Belgium
    MS-Off Ver
    2010
    Posts
    22

    Copying names without borders

    I want to copy names without disturbing the borders. As you can see in the example the names in red are copied to below and the line comes along. How can I prevent this from happening?
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    04-17-2017
    Location
    Mexico
    MS-Off Ver
    2016
    Posts
    48

    Re: Copying names without borders

    There is a option to copy it with no borders, right click in the area where you want to copy, select paste special and look for paste with no borders, is the icon number 5.

  3. #3
    Registered User
    Join Date
    05-11-2017
    Location
    Belgium
    MS-Off Ver
    2010
    Posts
    22
    Quote Originally Posted by JesusTello View Post
    There is a option to copy it with no borders, right click in the area where you want to copy, select paste special and look for paste with no borders, is the icon number 5.
    I know. But when you have to right click 2000 times a day. It's not very productive. I want it standard.

+ 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. Not Copying Borders of range
    By noobsesher in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2015, 04:11 PM
  2. copying defined names
    By mmcksmith in forum Excel General
    Replies: 2
    Last Post: 01-12-2015, 04:03 PM
  3. [SOLVED] Auto change borders to thick borders
    By Pierce Quality in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-22-2013, 11:17 PM
  4. Replies: 9
    Last Post: 04-17-2013, 08:57 AM
  5. Replies: 3
    Last Post: 02-20-2012, 05:09 PM
  6. copying mp3 file names
    By reenad99 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-29-2010, 03:49 PM
  7. [SOLVED] How do I secure borders, make them unaffected by copying or draggi
    By sebds70 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-21-2005, 09:06 AM

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