98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » $ signs
$ signs
Resolved · Low Priority · Version Standard
Mia has attended:
Excel Introduction course
Excel Intermediate course
PowerPoint Introduction course
PowerPoint Intermediate Advanced course
$ signs
Please can I have more info on $ signs
RE: $ signs
Hiya Mia
How are you today hope you enjoyed the training course on Monday
To give you more explaination on the use of dollar signs will be as follows
when you need dollar signs there is a reason, this is so you can always look in one place for that part of the formula here is an example of using the dollars =d4+h7*f6+$h$25
You will then be using this cell for any copied formulas to other cells
you can have have the dollar signs in four different way these are below
H25 - relative, means will change when copied
$H$25 - permanent cell, means this will remember the cell
$H25 - permanent column, means will remember the column
H$25 - permanent row, means will remember the row
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please click reply or post it as a new question and we should be able to answer that!!
Hope this helps
Mark East
mark@stl-training.co.uk
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Find cells that match a formatIn Excel you may wish to find cells that contain a specific formatting such s colour. |