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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel course tate modern - Excel absolute referencing

excel course tate modern - Excel absolute referencing

ResolvedVersion Standard

Wed 28 Nov 2007, 15:49 Delegate Pavlina said...

Pavlina has attended:
Excel Introduction course

Excel absolute referencing

Could you do referencing any other way than adding the $ sign to the cell reference? Is there a shortcut?

Thu 29 Nov 2007, 14:36 Trainer Stephen said...

RE: Excel absolute referencing

Hi Pavlina

Thankyou for thr question

If you type in your formula and press F4, then the reference will automatically become absolute. By repeatedly pressing F4 you can set only the columns and then the rows to be absolute

If you type the formula and press enter before you press F4 then you would have to select the cell with the formula and then highlight the formula's cell reference in the formula bar before pressing F4

Regards

Stephen

Excel tip:

Shared Conditional Formatting

In a shared workbook, conditional formats applied before the workbook was shared will continue to work; however you cannot modify the existing conditional formats or apply new ones.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

excel course tate modern - Excel absolute referencing

Excel absolute referencing

RE: Excel absolute referencing

Excel articles

Excel tip:

Shared Conditional Formatting