+ Reply to Thread
Results 1 to 2 of 2

Retaining cell borders when sorting

  1. #1
    Registered User
    Join Date
    07-22-2009
    Location
    Santa Cruz, CA (USA)
    MS-Off Ver
    Excel 2003
    Posts
    1

    Retaining cell borders when sorting

    I have a database I am making, each 2 rows have a cell broders in a certain format.

    I need to (once I am done entering all of the data) sort them ascending by name.

    I know how to sort, however, when I sort it will sorts the data but the cell borders stay in the same place.


    = How do I make it so that I can group 2 rows worth of cell together in a manner that would retain my border scheme when I decide to sort. I need the borders to move WITH the cell data, and I need both (2) rows to stay together when sorting, maybe by grouping them somehow.
    Last edited by sgreger1; 07-22-2009 at 02:47 PM.

  2. #2
    Registered User
    Join Date
    10-26-2011
    Location
    Cambridgeshire, UK
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Retaining cell borders when sorting

    Hi sgreger1,

    During sorting OpenOffice doesn't leave borders in the same place, but sorts them along with the rest of cell content.

    I am using Excel 2003, so those of you using more recent versions of Excel may need to save using 'save as' and change the version to an earlier version that OpenOffice opens.

    I made a second copy of my working file by clicking once on the file in ‘my documents’, then pressing CTR C (copy) followed by CTR V (paste). The reason for this 2nd copy, I wasn’t confident I would be happy with result so I created a backup.

    Then you opened the ‘copy’ in OpenOffice, then sorted the content, then saved it in original format so Excel can open it later. I am not confident that all your formats will translate, so a backup is important. My objective with making a back up was, I can copy just the work sheet where the sort occurred back into the original documents so to carry out as few edits as possible in open office.

    Disadvantages I noticed are:-
    OpenOffice doesn’t support patterns in cells, during the opening process the patterns are converted to a darker shade of the original back ground colour in the cell. The converted colour is unlikely to be a default colour in OpenOffice and can’t be added as back ground colour to another cell if you wish to continue editing in OpenOffice.

    OpenOffice is a free download. Hope this is useful to someone.

    Regards Rodney

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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