Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
template

ResolvedVersion 2007

Serap has attended:
Excel Intermediate course
Excel Advanced course

Template

How do I customise invoice template

Edited on Thu 4 Dec 2008, 11:45

RE: 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:

Pivot table grouping

If you want to group items in a pivot table together, simply highlight the labels for the fields either with the shift key (if adjacent)or with the contral key if they are not next to each other.
Right click and choose group. Give the cell a name.

When you double click on this cell it will either expamd or collapse your grouped area

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.