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: 175

Total answers/comments: 1

Comments display order:

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."