locking cells

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Locking Cells $

Locking Cells $

resolvedResolved · 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


 

Excel tip:

Number format shortcut

Ctrl+Shift+! applies the Number format, with two decimal places

View all Excel hints and tips


Server loaded in 0.08 secs.