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 » excel word powerpoint courses london - Excel
excel word powerpoint courses london - Excel
Resolved · Low Priority · Version Standard
RE: Excel
It's where you put a $ in before a reference. This forces Excel to look at the very same cell no matter how far you drag out your formula
so if you were to put in C1 the following fomula: =A1+B1 and drag the formula down from C1 thru C100 the formula in those dragged out cells would be, for instance =A25+B25
but if you put =$A$1+B1 and drag it out, the formula in cell C25 would be =$A$1+B25
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:Change the Print button so it brings up the Print dialogue boxIf you want to bring up the Print dialogue box to check your print settings when you hit the Print button, do the following: |