excel

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

Excel

resolvedResolved · Low Priority · Version 2003

Alison has attended:
Excel Intermediate course

Excel

How do you make a cell constant

RE: Excel

Hi Alison,

Thank you for your question.

To change a cell in a formula to an absolute cell reference, click in the formula bar on the cell you require and press the function key F4.

Regards

Simon


 

Excel tip:

Quickly select a block of data

To quickly select a block of data make sure your active cell is somewhere whithin the block of data and then press Ctrl+* or Ctrl+Shift+8.

View all Excel hints and tips


Server loaded in 0.1 secs.