View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default Statement of Account

Lou

You can't sort because there are merged cells in the selection.

Select A11

FormatCellsAlignment. Uncheck "Merge Cells"

Doesn't harm the worksheet and you can use "Center across selection" if you
want to re-format the look of the "brought forward" in row 11


Gord Dibben Excel MVP

On 17 Dec 2005 17:03:03 -0800, "Lou" wrote:

I need to reconcile some data for a hockey team and am in need of a "
Statement of Account " spreadsheet. I don't know how to draft my own
so does anyone have a template? I tried to use the one on the Microsoft
web site the problem is I can't seem to be able to sort the Description
column alphabetically??? help