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.
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,670
Messages
5,573,558
Members
412,537
Latest member
Mohamed_5966
Top