excel.advanced.course - absolute reference

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel.advanced.course - Absolute Reference

excel.advanced.course - Absolute Reference

resolvedResolved · Low Priority · Version Standard

Adenike has attended:
Excel Introduction course
Excel Intermediate course

Absolute Reference

How do Icreate an an absolute renference

RE: Absolute Reference

Hi Adenike

Thank you for your question.

You can make a cell in a formula into an absolute reference by doing the following:

When you click on a cell to put it into the formula, press the F4 key once immediately afterwards. This will insert two $ signs, one before the column letter and another between the column letter and the row number. This is now an absolute reference which means that if the formula that the cell is in is copied to another location in the spreadsheet, this cell remained fixed or locked into the formula (in other words the cell reference does not change).

I hope this helps.
Amanda


 

Excel tip:

Jumping Between Sheets in a Book

PgDn and PgUp keys scrolls up and down a screen page in most applications.

Ctrl+PgDn and Ctrl+PgUp keys jump from one sheet in your workbook to the next, up or down through the pages.

View all Excel hints and tips


Server loaded in 0.08 secs.