Creating Excel Invoice Template

[Sasha K]

I have been trying to customize a downloaded template but was frustrated so
trying to create my own invoice. My question is once I input the formulas
how do I keep/save them ???? when I enter the first calcualtions all is well,
but if I go back and edit in the cell where the formula resides I lose the
formula ??? I am a relative newbie to this so any help will be greatly
appreciated. I have searched this site and cannot find a link to creating an
invoice worksheet.
Sasha

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...f-9507e824398e&dg=microsoft.public.excel.misc

 

[Don Guillett]

http://www.google.com/search?source...FRD_en___US219&q=excel+invoice+templates+free

 

[Gord Dibben]

Post the URL of the downloaded template.


Gord Dibben MS Excel MVP

 

[zvkmpw]

My question is once I input the formulas

how do I keep/save them ???? when I enter the first calcualtions all is well,
but if I go back and edit in the cell where the formula resides I lose the
formula ???

It's usually best to think ahead and decide (a) which cells are to
contain constant values to be edited and (b) which are to contain
formulas depending on the constants (and on other formulas).

Typically, one wouldn't replace a formula with a constant.

In the case at hand, perhaps two cells are needed:
- one to be edited for each calculation, and
- a second with a formula doing some calculation.