Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating Excel Invoice Template
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/comm...lic.excel.misc |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating Excel Invoice Template
Post the URL of the downloaded template.
Gord Dibben MS Excel MVP On Sat, 28 Nov 2009 13:46:01 -0800, Sasha K wrote: 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/comm...lic.excel.misc |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating Excel Invoice Template
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Invoice Template | Excel Discussion (Misc queries) | |||
Excel Template Invoice | Excel Discussion (Misc queries) | |||
How do I generate a new invoice number when creating new invoice? | Excel Discussion (Misc queries) | |||
How do I change the invoice number assigned in Invoice template... | Excel Discussion (Misc queries) | |||
Excel 98 Invoice Template | Excel Worksheet Functions |