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 » Locking Cells $
Locking Cells $
Resolved · Low Priority · Version 2007
Michael has attended:
Word Advanced course
Locking Cells $
Is there an automatic or shortcut way to lock a cell when inputting a formula.
i.e. I want the forumula to be:
=$B$4*B12
Must I type the $ or is there short cut?
RE: Locking Cells $
Dear Michael
Thank you for attending Word Adv course. I hope you enjoyed the course and benefited from it.
The shortcut key for making your cells absolute is pressing the F4 key on the keyboard.
Please ensure that your cursor is blinking on the cell you wish to make absolute (dollar signs)
I hope this helps!!
Please mark the post as resolved if it has helped in answering yiour query.
Many thanks
Kindest Regards
Rajeev Rawat
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:Number format shortcutCtrl+Shift+! applies the Number format, with two decimal places |