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

Locking Cells $

ResolvedVersion 2007

Fri 17 Oct 2008, 13:48 Delegate Michael said...

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?

Fri 17 Oct 2008, 16:06 Trainer Rajeev said...

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 courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Manually rotating a 3D chart

To manually rotate a 3D chart;
Select the chart (edit mode) and click on one corner of the chart display area. A selection border will appear, using the left mouse button on one of the chart's "corners" (mouse pointer changes to a cross) drag the image which becomes a line representation of the chart (as you begin to drag) and rotate the chart to a view of your choice.
If you dont get it right first time, dont worry, the manoeuver is a little bit tricky.

View all Excel hints and tips

Locking Cells $

Locking Cells $

RE: Locking Cells $

Excel articles

Excel tip:

Manually rotating a 3D chart