moving cell lines/frames together with content when sorting

NickLe

New Member
Joined
Dec 4, 2005
Messages
1
When a table is made up with some cells framed in or underlined the structure seems to be static and does not move along with the content when sorting. Is it possible to really attach frames/ lines to a cell so it will move along? The content of the cells are not numerical.
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

XLGibbs

Well-known Member
Joined
Feb 25, 2005
Messages
2,446
I don't believe the borders property will move with the cells after sorting, however, if you wanted the action to be done via VB macro, it could be handled...but in the standard scope of using excels sorting feature, it simply reorganizes the contents of the cells (i.e. the Value or Formula property of the cell) whereas the border is a different property and is anchored to the specific cell address.

You can move the border using cut and paste, but that will not work real well with sorting unless you are doing it manually via the cut and paste.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,018
Messages
5,834,974
Members
430,331
Latest member
Syed Yasir Hannan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top