Home » Questions » Computers [ Ask a new question ]

Is is possible to get Excel to insert an absolute reference when clicking on cells to build a formula?

Is is possible to get Excel to insert an absolute reference when clicking on cells to build a formula?

If you build a formula by clicking on a cell to insert its address into the formula, is there a way of making this reference absolute rather than relative?

Asked by: Guest | Views: 27
Total answers/comments: 1
Guest [Entry]

"Click the cell and then hit F4. As you keep hitting F4, it will cycle through various level of absolute.

Example:

Click the cell A1, type '=', then click the cell B1.
Hit F4. The reference to B1 becomes $B$1.
Hit F4 again. The reference becomes B$1.
Hit F4 again. The reference becomes $B1.
Hit F4 again. The reference returns to B1."