microsoft excel courses - absolute referencing

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses - Absolute referencing

microsoft excel courses - Absolute referencing

resolvedResolved · Low Priority · Version Standard

Daniel has attended:
Excel Introduction course

Absolute referencing

What is the formula for this?

RE: Absolute referencing

Hi Daniel

Thanks for your question.

An absolute cell reference in a formula has $ signs in front of the column letter and the row number, e.g. $B$3

To create an absolute reference, press the F4 key after you have clicked on the cell to enter it into a formula.

Amanda


Server loaded in 0.08 secs.