Share via

Cell formatting does not move with Sorting

Anonymous
2011-01-26T21:19:44+00:00

Is there a way to make the formatting of a cell stay with that cell when i sort a list of data?

IE:  I have a price list that has item number, description, cost, and minimum pack.  If I BOLD and BOLD OUTLINE the prices that have changed, then sort them by item number, the BOLD and BOLD OUTLINE stay in the actual cells, but the data moves to where it should be in the sort.   This never happened in previous versions.....

Any ideas?  I looked for a setting but could not find anything.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-01-27T00:50:07+00:00

    In my experience, in all versions, borders stay put but Bold travels with the cell.

    Just tested in 2003, 2007 and 2010.

    Only if the border formatting was caused by conditional formatting based on the cell's value then I would expect it to travel with the cell.

    Bill Manville. Excel MVP, Oxford, England. www.manville.org.uk

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments