Hints and tips home » Excel hints and tips » Cycling through Absoulte cell references

Cycling through Absoulte cell references

If you are working with formulas in excel and need to convert your formula to an absolute formula, instead on manually adding in the $dollar signs you can highlight the specific part of your formula and press the F4 key.

You can cycle through all the absolute options by pressing the button (up to four times)

Added by Meenesh on 24th October 2006

More Excel hints and tips, like:

• Concatenating Results of Formulas
• Removing custom dictionary entries
• Generating simple column charts