I have a worksheet with several columns on it. At the end is a total column.
The formula adds all the numbers across to make the total. I want to move
the total column to the front of the worksheet (left), erase the numbers that
made up the total, but not lose the total. How do I do that? I want to keep
the formula but not the numbers that are in the body of the sheet.

Thanks for any help I am given.

Gwen,

I don't really think that there is a way to do this.

There are a few things you might try:

1. Copy the Totals column and then select the column where you want it and Paste Special... Values (right-clickPaste Special... or
EditPaste Special...), then delete the columns with the numbers that make up the totals. You would not keep the formulas, but you
would have the totals.

2. Move the Totals column where you want it and then hide the columns that make up the totals. You would have the totals and the
formulas and the other columns would seem like they are not on the sheet with the totals (but they would still be there).

3. Move the Totals column to a new sheet, but you might have to update the formulas to reference the ranges on the other sheet that
make up the totals. You would have the Totals on a sheet all by themselves and the formulas would be similar (but they would
include a sheet name in them along with the cell/range references).

HTH,

Conan



"Gwen" wrote in message ...
I have a worksheet with several columns on it. At the end is a total column.
The formula adds all the numbers across to make the total. I want to move
the total column to the front of the worksheet (left), erase the numbers that
made up the total, but not lose the total. How do I do that? I want to keep
the formula but not the numbers that are in the body of the sheet.

Thanks for any help I am given.