insert columbs

[pufatrain]

On my account worksheet in columb A is addresses in row 1 is weekly dates in columb B is amounts collected, columb C is the totals.I add all columb B and all rows so I know which custemer as paid and how much after a week I insert another columb but I have to format cells again to add everything up. Is there a way that the formating so when i insert a columb I dont have to drag all rows and columbs to include new columb if you know what I am on about. Cheers Pete train

[tuph]

Try copying an existing column, right click and click on insert copied cells.

[pufatrain]

Yes that works fine easy when you know how. Cheers Pete Train