Sorting cells with formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've a spreadsheet where I formatted certain cells with fills and borders.

When I sort the cells, the formatting stays and did not move with the cells.

Is it possible to sort the cells such that the format stays with the
specific cells?

Thanks.
 
Frank. I have sorted many excel spreadsheet where the formatting (ex.
colored cells) stays with that specific cell. So this is absolutely
possible. However, for the first time, today I encountered the same problem
that Derrick did and can't seem to figure it out.

Aideen
 
Derrick,

I have done this kind of sorting many times and up until today the
formatting (ex. colored cells) stayed with the cell. If you figure out how
to solve this, please let me know.

Aideen
 
Aideen

If the cells are colored due to Conditional Formatting, the color will stay
with the sorted cell.

Gord Dibben Excel MVP
 
Back
Top