+ Reply to Thread
Results 1 to 3 of 3

Copy only borders and leave other formats

  1. #1
    Registered User
    Join Date
    02-11-2011
    Location
    Vilnius, Lithuania
    MS-Off Ver
    Excel 2016
    Posts
    83

    Copy only borders and leave other formats

    Hello friends, I have huge file with many columns. One of the column contains data and is surrounded with borders. I need to apply same borders on other columns, but if I use Format Painter - it also applies other formats like regular text. I need to keep original formats like bolded text and currency on other columns, but apply borders on top. Is there a way?

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Copy only borders and leave other formats

    sure, with vba
    your file will help a lot

  3. #3
    Registered User
    Join Date
    02-11-2011
    Location
    Vilnius, Lithuania
    MS-Off Ver
    Excel 2016
    Posts
    83

    Re: Copy only borders and leave other formats

    Thank You, I have found VBA online, will mark it as solved. Just wanted to know is there a way without VBA.

+ 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. Replies: 4
    Last Post: 10-01-2014, 03:18 PM
  2. [SOLVED] copy formulas en borders
    By Evolta in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-16-2014, 03:39 AM
  3. [SOLVED] PasteSpecial with number formats but without conditional formats or borders
    By bodhi808 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2013, 09:58 AM
  4. Loop with Paste Special Values, Formats but no Borders
    By John Vieren in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-04-2012, 10:07 AM
  5. Copy borders from another worksheet
    By alen in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-12-2009, 04:20 AM
  6. [SOLVED] How do I sort values only, and leave formats?
    By havocdragon in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-12-2006, 04:25 PM
  7. Preserve borders during copy and paste?
    By aarotu in forum Excel General
    Replies: 1
    Last Post: 07-11-2006, 01:35 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