When you sort data in Excel, any cell borders that you have applied are maintained. This can be helpful if your data contains column headers with cell borders that you want to keep in place. However, there may be times when you want the cell borders to move along with the data. For example, you may have a worksheet with cells that contain both text and numbers, and you want the cell borders to move so that the numeric values are always next to each other.
To have Excel move the cell borders when you sort, follow these steps:
To sort by more than one column, click (Add Level), and then repeat step 3.
To specify how blank cells should be sorted, click (Options), and then select an option under (Blank cells). By default, blank cells are sorted below all nonblank cells.
|"Sorted By Column A" "Then By Column B" "Then By Column C"|