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.