sorting cell borders

Russ · May 9th, 2002, 03:36 PM

When sorting a spreadsheet in MS Excel XP, is there a way to sort cell borders with the original rows and columns they were applied to? Thanks!

Mark W. · May 9th, 2002, 03:37 PM

No. Sorting shuffles the contents of a cell... not the cells themselves.

Juan Pablo González · May 9th, 2002, 04:38 PM

Altough Mark IS right... maybe, depends on your spreadsheet, you could use Conditional Formatting to "tie" the formatting with the values.

Nimrod · May 9th, 2002, 04:42 PM

Though before sorting you could hide a column with the row values in it .. which could later then be used to refer to the orginal order.

Russ · May 10th, 2002, 02:17 PM

Thanks for the help everyone!

May 9th, 2002, 04:38 PM	#3
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Altough Mark IS right... maybe, depends on your spreadsheet, you could use Conditional Formatting to "tie" the formatting with the values. __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 03:36 PM	#1
Russ New Member Join Date: May 2002 Posts: 2	When sorting a spreadsheet in MS Excel XP, is there a way to sort cell borders with the original rows and columns they were applied to? Thanks!

May 9th, 2002, 03:37 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	No. Sorting shuffles the contents of a cell... not the cells themselves.

May 9th, 2002, 04:42 PM	#4
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	Though before sorting you could hide a column with the row values in it .. which could later then be used to refer to the orginal order.

May 10th, 2002, 02:17 PM	#5
Russ New Member Join Date: May 2002 Posts: 2	Thanks for the help everyone!