Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Template
Resolved · Low Priority · Version 2007
Serap has attended:
Excel Intermediate course
Excel Advanced course
How do I customise invoice template
Hi Serap,
Thank you for your question;
In answer, when you open the stardard template INVOICE it is locked, you will need to unlock it by going to the Tools>Protection Menu command and choose Unprotect Worksheet. make your changes and if you require to: Lock it once more to maintain your changes... save it as a template with your own file name and you have a customised invoice template which you can use whenever you require to.. I hope that has helped ... Pete
Wed 10 Dec 2008: Automatically marked as resolved.
|
Excel tip:Reconciling a list to correspond with anotherMay have a list that needs to make but on another sheet one list seems to be out, eg. product list one sheet contains all product and inventory data, while the other contains pricing data. Both need to match with all products but there is more products in one list than the other. To find the disparaging product compare data in the two columns that need to match Make sure that order the same way. |
We'll call during UK business hours
Server loaded in 0.07 secs.