Once a reference is selected or the cursor is in it, pressing F4 one or more
time cycles to the four combinations.

billbrandi wrote:
Is there a quick way to convert fixed cell references ($row$column) to
eliminate the $ without editing the formula and deleting the $ one keystroke
at a time? Sure would save me a lot of time.

Thanks
Bill Falzone

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200707/1