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

formatting

ResolvedVersion 2010

Buket has attended:
Excel Intermediate course

Formatting

how do you make a template that is formatted by yourself?

RE: formatting

Hi Buket, thanks for your query. Microsoft have a collection of material regarding templates here:

http://office.microsoft.com/en-us/excel-help/about-excel-templates-HP005229286.aspx

Hope this helps,

Anthony

Thu 4 Aug 2011: Automatically marked as resolved.

Excel tip:

Hiding Formulae in the Formula Bar

It is possible to protect the contents of a cell reference(s) from amendment by applying cell protection. The contents of the cell reference can also be stopped from displaying in the formula bar.

Step 1: Select Format > Cells > Protection.

Step 2: Tick Hidden option. Ensure Locked is ticked

Step 3: Select Tools > Protection > Protect Sheet

(Ensure "Protect worksheet and contents of locked cells" is ticked)


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.