move Excel cell boundary using sort ?

[william]

Wanting to sort rows and want the cell boundary definitions (primarily lines)
to likewise move/sort along with its data content. Using Excel 2000. Can this
be done?

 

[Bernard Liengme]

Suppose you have data like this in A1:B5
name no
John 5
Mary 7
Jane 8
Jack 4

Select the data (all of it); use the Data | Sort command (do not use the A>Z
or Z>A tools);
this opens a dialog where you can specify you want the No column sorted. The
numbers get sorted and each name stays with its number.

Any help?

 

[william]

Interesting effect - but not what I'm after -but thanks anyways.
I'm trying to strip excess rows/details from a financial statement which has
many, many subtotals which were all given cell boundary attributes (lines)
for highlighting.

Here is my problem (simplified). Enter a series of numbers running down a
column (say A1 to A4) - and create a subtotal at cell A5. I normally enhance
the appearance of my subtotals (cell A5) by making the A5 cell boundary
top=bold line and bottom = bold line. If I do a sort of rows A1 to A5 (**note
I am deliberately including the subtotal cell: A5 within the sort), the
A5-subtotal cell contents will move and I want the special A5 boundary
attributes to move with/to the after-sort-subtotal cell-destination.
-- thanks William

 

[Bernard Liengme]

Cell "borders" are attached to the cell not to the value in the cell

 

[Shane Devenshire]

Hi,

Excel, even version 2007, does not sort the formatting with the data. You
could probably write a vba program to do this but is it worth it?

A quick manual way might be:
after a sort

1. Select all the cell and clear the borders
2. With the entire range selected, Press F5, Special, choose Formulas and
click OK
3. Add borders

If this helps, please click the Yes button

Cheers,
Shane Devenshire

 

[Gord Dibben]

Borders remain at the point at which they were created.

i.e. borders on A5 will stay with A5 independent of cell contents and
sorting.

If you format A5 to bold with double accounting underline, that will move
with the cell contents.

Or use drawing Toolbar to draw lines within the cell.


Gord Dibben MS Excel MVP

 

[Spiky]

Interesting effect - but not what I'm after -but thanks anyways.
I'm trying to strip excess rows/details from a financial statement which has
many, many subtotals which were all given cell boundary attributes (lines)
for highlighting.

If you can form the subtotal rows with an outline, you can roll up the
outline to get rid of detail.

 

[william]

thanks, I will try this.
--
thanks William

If you can form the subtotal rows with an outline, you can roll up the
outline to get rid of detail.

 

[william]

thanks, I will try this
--
thanks William

Borders remain at the point at which they were created.

i.e. borders on A5 will stay with A5 independent of cell contents and
sorting.

If you format A5 to bold with double accounting underline, that will move
with the cell contents.

Or use drawing Toolbar to draw lines within the cell.


Gord Dibben MS Excel MVP

 

[william]

Thanks, I will work with this.