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:
=$B$2
Press F4 again:
=B$2
And once again:
=$B2
I believe this is Shift+F4 in openoffice calc. I’ll confirm later today.
[tags]daily-shortcut, productivity, accesskeys, openoffice-calc, excel[/tags]
