If you’ve ever done some Excel formulas, you know the power of Absolute references of Rows/Columns.
Just go to cell A1 in Excel, and type =B2
Then press F4.
You’ll see this:
Press F4 again:
And once again:
I believe this is Shift+F4 in openoffice calc. I’ll confirm later today.
[tags]daily-shortcut, productivity, accesskeys, openoffice-calc, excel[/tags]