+ Reply to Thread
Results 1 to 3 of 3

How Do I Alphabetize a column but move the data in the row with it?

  1. #1
    Registered User
    Join Date
    04-12-2014
    Location
    Texas, USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    How Do I Alphabetize a column but move the data in the row with it?

    Hi. I am using Excel 2010. I am making a list of vinyl records and their value. I have my columns set by the artist, ebay price, popsike.com price, and my listing price. I have summed my listing prices together so that I know my total estimated value of all the albums.

    My question is that I would like to alphabetize this list by artist. This will make it easier for me to locate the albums in my list. However, I want to keep the entire row linked together when it moves, and not lose my sum formula for my listing prices. How would I accomplish this?
    Last edited by excelastrid; 04-12-2014 at 04:37 PM.

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,964

    Re: How Do I Alphabetize a column but move the data in the row with it?

    If you select all the data (excluding the cells containing the sum formulae) when sorting, the rows should all move together and the sum total not be affected.
    Martin

    If my solution has saved you time and/or money, please consider sponsoring my run in the 2020 London Marathon in aid of Cancer Research UK.

    https://uk.virginmoneygiving.com/MartinRice

  3. #3
    Registered User
    Join Date
    04-12-2014
    Location
    Texas, USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: How Do I Alphabetize a column but move the data in the row with it?

    Worked like a charm! Thanks so much.

+ 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. How do I alphabetize a column or cell?
    By momluvs3ido in forum Excel General
    Replies: 5
    Last Post: 07-25-2015, 05:36 PM
  2. [SOLVED] How to lock values so I can re-alphabetize a column
    By XoddaM in forum Excel General
    Replies: 1
    Last Post: 10-21-2013, 02:24 AM
  3. [SOLVED] Alphabetize data by inner column
    By PLEASEHELPASAP in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-02-2012, 07:45 PM
  4. Alphabetize list by column B
    By BShane in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-27-2011, 11:44 PM
  5. Replies: 3
    Last Post: 11-27-2008, 12:02 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