I will preface this with the advice that you start doing things on a copy of
the worksheet.

Hold down the CTRL key and drag the worksheet to the right. A copy will be
created.

Alphabetically sorted means sorted in Ascending order.

As in a to z

In your case, sort on Column B(Description) in Ascending order.

NOTE: very important that you select all 5 columns A through E starting at
row 12.

Do not sort above that.

If you look in the cells in column E(account balance) there should be a
formula in each one that keeps track of the balance as you enter debits and
credits.

The one in E12 is this...............

=IF(ISERROR(IF(OR(C12,D12),((E11)+C12-D12),)),"",IF(OR(C12,D12),((E11)+C12-D12),))

If the others are gone, just enter and drag/copy down the column.

OR...........re-download the Template and start over.


Gord

On 17 Dec 2005 18:29:51 -0800, "Lou" wrote:

Sorry Gord, you are right I uncheck merged cells but I am still unsure
how to sort alphabetically, it soesn't seem to be an option under
sort. The second problem is the template seems to have dropped the
ability to add the balance column??