microsoft excel training - how does absolute cell

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 training - How does absolute cell referencing work?

microsoft excel training - How does absolute cell referencing work?

resolvedResolved · Low Priority · Version Standard

Donna has attended:
Excel Introduction course
Excel Intermediate course

How does absolute cell referencing work?

Thanks
Donna

RE: How does absolute cell referencing work?

Hi Donna,

A relative cell reference in a formula, such as A1, is based on a relative position of the cell that contains the formula and the cell the reference refers to. If the position of the cell that contains the formula changes, the reference is changed.

An absolute cell reference in a formula, such as $A$1, will always refer to a cell in a specific location. If the position of the cell that contains the formula changes, the absolute reference remains the same.

Hope that helps Tracy


 

Excel tip:

Hiding a worksheet in Excel

Want to circulate an Excel workbook file but keep certain worksheets hidden from your colleagues' view?

You can do so by bringing up the sheet you wish to hide on your screen; then going to Format - Sheet - Hide.

It will not be immediately obvious that a sheet is hidden from view unless perhaps the sheet are still labelled Sheet 1, Sheet 2 etc.

To display the sheet again, you can go to Format - Sheet - Unhide on any of the other sheets in the workbook. A dialogue box will appear, allowing you to select the hidden sheet/s. Click OK to make the sheet/s reappear again.

View all Excel hints and tips


Server loaded in 0.08 secs.