98.1 % recommend us More live stats... RSS feeds What's this? All hints and tips:

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:

• Showing all menu items
• Shared Conditional Formatting
• Hiding and unhiding columns using the keyboard