Posted by jpluimers on 2012/11/30
In Excel I always got confused with named ranges, as I thought they were hard to track.
Not!
The F3 keyboard shortcut gives you a list of named ranges including name and location. Which makes it way easier to work with named ranges.
See the excellent post Show all named ranges in Excel: It even has an animated gif image that shows you F3 in action.
–jeroen
Posted in Excel, Keyboards and Keyboard Shortcuts, Office, Power User | Leave a Comment »
Posted by jpluimers on 2012/10/23
About 4 months ago, I missed the OCZ Octane SSD Review – Internal Hard Drives – CNET Reviews.
Too bad that at roughly USD 2400 (the lowest price vendor at CNET lying), it is about three times as expensive as the Google Shop search for Hard Drives Intel Solid State 600 GB that I already have.
–jeroen
Posted in Hardware, Opinions, Power User, SSD | 1 Comment »
Posted by jpluimers on 2012/10/19
Krishnan Sriram has a very nice list of New hotkeys for the Windows 8 Consumer Preview.
His lists starts with the shortcuts that stayed the same; these are the ones that are new:
Posted in Keyboards and Keyboard Shortcuts, Power User, Windows, Windows 7, Windows 8 | Leave a Comment »
Posted by jpluimers on 2012/09/30
Last week this was in HDD news:
I asked it before 6 months ago, and wonder: how long will it take for 12.5 mm 2.5 inch SATA HDDs to arrive on the market that have 1.5 TB or more capacity?
Yes, I know about the WD20NPVT, but the WD20NPVT is 2.5 inch and 15 mm high.
–jeroen
Posted in Hardware, Opinions, Power User, SSD, ThinkPad, W701 | Tagged: hard drive, hdds, sas, tb | 1 Comment »
Posted by jpluimers on 2012/09/28
| How | Upper | Lower | Comment |
|---|---|---|---|
| Keyboard | CTRL + SHIFT + U | CTRL + U | |
| Menu | Edit -> Advanced -> Make Uppercase | Edit -> Advanced -> Make Lowercase | |
| Command | Edit.MakeUppercase | Edit.MakeLowercase | |
| Versions | 2008, 2010, 11 | ||
–jeroen
Posted in .NET, Development, Keyboards and Keyboard Shortcuts, Power User, Software Development, Visual Studio 11, Visual Studio 2008, Visual Studio 2010, Visual Studio and tools | Leave a Comment »
Posted by jpluimers on 2012/09/21
The Ctrl+Alt+Delete keyboard shortcut equivalent for VMware View/Workstation/Player is very easy to remember: Ctrl+Alt+Insert.
While searching for the Ctrl+Alt+Delete keyboard shortcut equivalent in Remote Desktop (which is Ctrl+Alt+End), I came accross the via List of the keyboard shortcuts that are available in Windows XP.
It includes these lists:
I was after the Ctrl+Alt+End shortcut from the list below which works in any Windows version I tested so far. But the other lists are very useful too.
Posted in Keyboards and Keyboard Shortcuts, Power User, Windows, Windows 7, Windows 8, Windows Server 2000, Windows Server 2003, Windows Server 2003 R2, Windows Server 2008, Windows Server 2008 R2, Windows Vista, Windows XP | Leave a Comment »
Posted by jpluimers on 2012/09/20
Scott has been posting some really good entries lately.
This is one of them: Web Sites with Embedded Command Lines: You got your Command Line in my Internet – Scott Hanselman.
Being a keyboard addict, I love that!
–jeroen
Posted in Keyboards and Keyboard Shortcuts, LifeHacker, Power User | Leave a Comment »
Posted by jpluimers on 2012/09/17
Learned a few Excel keyboard shortcut pairs today:
| Shortcut | Action |
|---|---|
| Ctrl+Spacebar | Select columns |
| Shift+Spacebar | Select rows |
| Ctrl+; | Current date |
| Ctrl+Shift+: | Current time |
| Ctrl+Shift+2 | Format current cell as default date |
| Ctrl+Shift+3 | Format current cell as default time |
–jeroen
via:
Posted in Excel, Keyboards and Keyboard Shortcuts, Office, Power User | Leave a Comment »
Posted by jpluimers on 2012/08/27
Brilliant post on using the Window-key for shortcuts with Windows 8 (all Windows 7 Windows-key shortcuts work, plus many more): Windows 8 productivity: Who moved my cheese? Oh, there it is. – Scott Hanselman.
–jeroen
Posted in Keyboards and Keyboard Shortcuts, Power User, Windows, Windows 7, Windows 8 | Leave a Comment »
Posted by jpluimers on 2012/08/06
Cool: sites that allow you to do track prices, get history charts, get alerts for price drops, etc. Got there through SSD prices in steady, substantial decline – The Tech Report.
Your account works at all of our price tracking sites:
- camelbuy (Best Buy)
- camelcamelcamel (Amazon.com)
- camelcamper (Backcountry.com)
- camelegg (Newegg.com)
- camelsounds (Zzounds.com)
And your account will work at any new sites we launch!
The SSD price drop together with the HDD Prices Not Expected to Decline Until 2014 makes me think: if/when I should finally ditch my RAID 5 storage server and build an ZFS server with server hybrid storage (which is totally different from desktop hybrid storage).
Many of the great references at Understanding how to use SSD as Hybrid Storage Pools for ZFS point to the old sun.com site, and suffer from link rot. A few I found back: Read the rest of this entry »
Posted in Hardware, Internet, LifeHacker, Power User, SSD | Leave a Comment »
The Wiert Corner - irregular stream of stuff 