excel course tate modern - excel absolute referencing

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

resolvedResolved · Low Priority · Version Standard

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?

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:

Applying and removing border from cell in Excel 2010

Did you know the shortcut key for applying and removing the outline border for a cell?

CTRL+SHIFT+& Applies the outline border to the selected cells.
CTRL+SHIFT_ Removes the outline border from the selected cells.

View all Excel hints and tips


Server loaded in 0.11 secs.