Archive for October, 2008

Windows Home Server (WHS) + HP = AWESOME!

mediasmart 201x300 Windows Home Server (WHS) + HP = AWESOME!The good folks at HP sent me one of there Windows Home Servers and I just got it up and running. Stay tuned for the wife and I to put it through our usual battering of tests. This terabyte of storage looks like a great place to store the media for my TiVo’s. I am loving the thought of the integrated iTunes aggregator, remote access and automagic client backups. Comments? Thoughts on integration into our lives?

Are you running a Windows Home Server? What Brand? Home Brewed?

Share Share Share!

_TheHomeServingAdmiN_

Hide Drives in My Computer

untitled Hide Drives in My Computer

Captain: Cloak drives (L, M and Y) in My Computer sector.
Lieutenant: But why captain?
Captain: The program acquires an access to some files on the network; we’ve mapped their folders as drives within My Computer. Now we don’t want the user to realize their existence, even if they do…they might mistake it with the local drives, and decide to work in it.

  • Note: you can use the next tip for both local and mapped drives, however, it will not prevent the access to the hidden drives
  • (If you hide the C drive, then Open explorer and type c: and it will still take you there)
    More >

    Excel 2007: Selecting Cells with numbers only in a sheet

    So you’ve spent a long time making this excel sheet and formulating it’s cells for your future needs.

    In the rush of work you’ve fed the empty cells with numbers and saved over the original file -the one for general purposes – and now you are busted in tears :’(

    Wipe your nose for God’s sake, there is actually a way to select only cells with numbers, skipping all cells with formulas and text:

    1) On your keyboard press (F5) or (Ctrl + g) and a (Go To) window will popup.
    2) Click on (Special) button.
    3) Click on (Constants) and uncheck everything from (Text) down to (Errors) leaving (Numbers) checked.

    Note: take a moment to see all the other selections you may need for other scenario’s, you never know when you’r gonna need them(Ex. like selecting all the formula’s of text).

    4) Click (Ok) and all the required fields are selected and with a one (Delete) press on your key board they are all empty again.

    Here are some hotchicks……Err, I mean hotkeys you might wanna know:

    • (CTRL+`): Switch between numbers-View and Formulas-View in all Cells.
    • (CTRL+` or F4): Repeats last possible command or action.
    • (CTRL+;): Enters the current date into selected cell.
    • (Alt+ Enter): For a new line within a cell (don’t be surprised a lot of people don’t know that).