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

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
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.
 
Upvote 0

Forum statistics

Threads
1,214,772
Messages
6,121,456
Members
449,033
Latest member
Kcolwell16

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
Back
Top