In the same light as yesterday’s post, insert your current system time into Excel and Access by pressing CTRL+:. (CTRL+SHIFT+;)
[tags]daily-shortcut, productivity, accesskeys, access, excel[/tags]
a shortcut a day keeps the mouse away
Archives for category: excel
This one’s really useful:
In any cell, just press CTRL+; and today’s current date (mm/dd/yyyy) will be inserted.
[tags]daily-shortcut, productivity, accesskeys, excel, access[/tags]
This one is a little difficult to explain, but oh so useful.
CTRL+SHIFT+* in Excel will select a block of the spreadsheet until it finds surrounding whitespace. Kind of hard to understand, so here’s a demonstration…
If you’re playing at home: I’m running Excel 2003, and I went File > New > General Templates > Spreadsheet Solutions > Loan Amoritzation > OK. Tools > Protection > Unprotect. Whew. Now that’s out of the way…
Go to Cell D7.
Press CTRL+SHIFT+*.
Enjoy =)
[tags]daily-shortcut, productivity, accesskeys, excel[/tags]
Not sure if there’s an openoffice equivalent… but in Excel, just press Shift+F11 and you’ll get a new worksheet.
[tags]daily-shortcut, productivity, accesskeys, excel[/tags]
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]
