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]
There’s a small deviation on OpenOffice and Excel for this shortcut.
Microsoft Excel: ALT+O, H, R.
OpenOffice Calc: ALT+F, H, R.
Alt+O/F (depending on if you’re using OpenOffice or Excel) will take you to the “Format” menu. “H” will take you to the “Sheet” submenu, and “R” will issue the rename command. [click for full image]
After pressing “R”, you can just type in the new worksheet name. Don’t forget to press enter when you’re done typing in the worksheet name.
[tags]daily-shortcut, productivity, accesskeys, excel, openoffice, openoffice-calc[/tags]
Go to cell A1 in Excel/OpenOffice-Calc.
Type “234567″. Then press CTRL+$ (CTRL+SHIFT+4) – “234567″ magically becomes “$234,567.00″. I love spreadsheet shortcuts.
[tags]daily-shortcut, productivity, accesskeys, excel, openoffice-calc[/tags]
If you have a spreadsheet with multiple worksheets, CTRL+PageDown will take you from left to right and CTRL+PageUp with take you from right to left.
Example:
In the screenshot posted, CTRL+PageUp will take me to Sheet3 and CTRL+PageDown will take me to Sheet2
This shortcut works with Microsoft Excel and OpenOffice.org Calc.
[tags]daily-shortcut, productivity, accesskeys, excel, openoffice-calc[/tags]
