CenterPiece Discussions  > Feedback & Support  > Re: Sorting in Excel  
Previous Thread :: Next Thread 
 Author Thread: Sorting in Excel
smiller is not online. Last active: 9/21/2005 8:14:17 AM smiller
Top 50 Poster
Joined: 07 Jul 2004
Total Posts: 27
 
Sorting in Excel
Posted: 19 Jul 2004 09:27 AM
When I go into Excel from the statistics page, I keep getting an error message when I try to sort the spreadsheet. It says "This operation requires the merged cells to be identically sized." How can I fix this?

thanks!
brianp is not online. Last active: 12/28/2024 12:26:29 PM brianp
www.ekyros.com
Top 25 Poster
Forum Moderator
Joined: 01 Aug 2002
Total Posts: 1248
 
Re: Sorting in Excel
Posted: 19 Jul 2004 11:39 AM
You need to unmerge the labels in the left column of the stats report. In Excel, select the left most column of labels, then on the format toolbar click the [merge and center] button. it's the button that looks like: "<- a ->" on the toolbar. that should unmerge the cells. You should be able to sort the data.

hope that helps.

BTW:
the daily schedule for resources is coming a long really good. we should be able to ship it with the next release of CenterPiece coming out in about a week.


smiller is not online. Last active: 9/21/2005 8:14:17 AM smiller
Top 50 Poster
Joined: 07 Jul 2004
Total Posts: 27
 
Re: Sorting in Excel
Posted: 21 Jul 2004 08:38 AM
That helps a lot.

We are very excited about the next release! Thanks for all of your help.

Sarah
Previous Thread :: Next Thread 
Goto to page:  Prev Next
 
Forums  > CenterPiece Discussions  > Feedback & Support  > Re: Sorting in Excel