+ Reply to Thread
Results 1 to 2 of 2

Custom Sort: cell contents move, borders do not

  1. #1
    Registered User
    Join Date
    05-25-2019
    Location
    Atascadero CA
    MS-Off Ver
    365
    Posts
    19

    Custom Sort: cell contents move, borders do not

    Running EXCEL 2010 File is *.xlsx

    I need to sort the entire spreadsheet referenced by Column B [A-Z] which contains text.

    Some of the cells out in the field [which only contain text] have borders, others do not. After the Custom Sort on Column B, the contents of all the cells sort properly but borders DO NOT move with their original cells. They remain in their original position.

    A friend with an earlier version claims this doesn't happen. Also doesn't happen with Open Office.

    HELP!

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,458

    Re: Custom Sort: cell contents move, borders do not

    Hi and welcome
    except for conditional formatting or VBA, the cell borders do not move when sorting/moving data.

+ 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. [SOLVED] How to move the contents of one cell based on the contents of another cell:
    By Chad Bateman in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-21-2015, 04:51 PM
  2. Custom Formatting of Cell Contents
    By walkitoff in forum Excel General
    Replies: 2
    Last Post: 03-19-2013, 04:58 PM
  3. [SOLVED] Move contents of a cell based on contents of another cell
    By djfscouse in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-06-2012, 10:31 AM
  4. [SOLVED] Adjust Multiple Cell Borders Based on Cell Contents
    By USFishin in forum Excel General
    Replies: 16
    Last Post: 04-10-2012, 12:56 AM
  5. Replies: 0
    Last Post: 03-09-2006, 08:10 PM
  6. Replies: 1
    Last Post: 07-01-2005, 10:57 AM
  7. Cell borders print default rather than custom setting.
    By Phil Hageman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-11-2005, 02:06 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