sorting list that includes merged cells

shammer · Apr 16th, 2002, 12:21 PM

Any tips out there on how to easily unmerge or delete cells that are included in a list that I would like to sort? The data that I am interested in are not included in the merged cells, so I do not care if those cells are completely lost or not.

Aladin Akyurek · Apr 16th, 2002, 12:31 PM

Quote:

On 2002-04-16 11:21, shammer wrote:
Any tips out there on how to easily unmerge or delete cells that are included in a list that I would like to sort? The data that I am interested in are not included in the merged cells, so I do not care if those cells are completely lost or not.

Free ASAP-Utilities has an option to unmerge selected cells, downloadable at:

asap-utilities.com

if your OS is Windows.

[ This Message was edited by: Aladin Akyurek on 2002-04-16 12:18 ]

Jack in the UK · Apr 16th, 2002, 12:47 PM

its notgoing to lilike merge cells... suggest un merge first or add col and sort...

Apr 16th, 2002, 12:47 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	its notgoing to lilike merge cells... suggest un merge first or add col and sort... __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

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

Apr 16th, 2002, 12:21 PM	#1
shammer New Member Join Date: Feb 2002 Posts: 25	Any tips out there on how to easily unmerge or delete cells that are included in a list that I would like to sort? The data that I am interested in are not included in the merged cells, so I do not care if those cells are completely lost or not.