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

formulas

ResolvedVersion Standard

Latisha has attended:
Excel Intermediate course

Formulas

what are dollar signs for?

RE: formulas

Hi Latisha, Thank you for your post, Welcome to the Forum, I hope you enjoyed your Excel Intermediate Course, in answer to your question, the dollar signs in a cell reference indicate that the reference is absolute, in other words it will not allow the formula to relatively update as the focus is moved to another cell, think of it as putting a pin through the cell reference to keep focus on it. I hope that answers your question, best regards Pete.

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

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.12 secs.