Sunday, October 20, 2013

How to shade every other row in Excel 2007 or Excel 2010

To use the Conditional Formatting option to shade rows in a worksheet, follow these steps:
  1. Open the worksheet.
  2. Select the cell range that you want to shade, or press Ctrl+A to select the whole worksheet.
  3. Click the Home tab.
  4. In the Styles group, click Conditional Formatting, and then click Manage Rules.
  5. Click New rule.
  6. Click Use a formula to determine which cells to format.
  7. In the Format values where this formula is true box, type =MOD(ROW(),2)=1, and then click Format.
  8. On the Fill tab, click the color that you want to use to shade every other row, and then click OK.
  9. Click OK to close the New Formatting Rule dialog box.
  10. Click Apply, and then click OK to close the Conditional Formatting Rules Manager dialog box.

To use the Format as Table option to shade rows in a worksheet, follow these steps:
  1. Open the worksheet.
  2. Select the cell range that you want to shade, or press Ctrl+A to select the whole worksheet.
  3. Click the Home tab.
  4. In the Styles group, click Format as Table, and then click the style of formatting that you want.
  5. In the Format as Table dialog box, click OK.

Thursday, October 10, 2013

How to import .nk2 files into Outlook 2010

To import .nk2 files into Outlook 2010, follow these steps:
  1. Make sure that the .nk2 file is in the following folder:
    %appdata%\Microsoft\Outlook
    Note The .nk2 file must have the same name as your current Outlook 2010 profile. By default, the profile name is "Outlook." To check the profile name, follow these steps:
    1. Click Start, and then click Control Panel.
    2. Double-click Mail.
    3. In the Mail Setup dialog box, click Show Profiles.
  2. Click Start, and then click Run.
  3. In the Open box, type outlook.exe /importnk2, and then click OK. This should import the .nk2 file into the Outlook 2010 profile.

    Note After you import the .nk2 file, the contents of the file are merged into the existing nickname cache that is currently stored in your mailbox.
Note The .nk2 file is renamed with a .old file name extension on the first start of Outlook 2010. Therefore, if you try to re-import the .nk2 file, remove the .old file name extension.


nk2 file locations
  • Windows XP
    Drive:\Documents and Settings\Username\Application Data\Microsoft\Outlook
  • Windows Vista and later versions
    Drive:\Users\Username\AppData\Roaming\Microsoft\Outlook
  • http://support.microsoft.com/kb/980542#LetMeFixItMyselfAlways
  • Friday, May 24, 2013

    Stop Windows from Restarting Your Computer After Updates

    Click on Start menu or screen and type "regedit" (no quotes). Start the Registry Editor that pops up.

    Navigate to:

    HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate\AU

    If "WindowsUpdate" does not exist, create it. To create it, right-click on the "Windows" key in the sidebar and go to New > Key. Name the key WindowsUpdate, then right-click on that key and create a new one called AU.
    Click on the AU key and, in the right pane, right-click on the empty space and choose New > DWORD (32-bit) Value.
    Name the new DWORD:

    NoAutoRebootWithLoggedOnUsers

    Double-click on the new DWORD and give it a value of 1.

    Reboot your machine.

    Download Reg file

    Tip from http://www.howtogeek.com/139993/prevent-windows-8-from-restarting-your-pc-after-windows-updates/

    Wednesday, May 22, 2013

    Clean Install Windows 7 With Upgrade Media and Product Key

    Retail version of Windows 7 has two main primary type of licenses – full or full package product (FPP) and upgrade, where the most obvious differences between full and upgrade versions are different prices for full and upgrade license, and customers have to possess an existing Windows license to be eligible for upgrade license.

     Clean Install and Activate Windows 7 with MediaBootInstall Registry Hack
    1. After booting up, ensure that no Windows Updates pending task which requires a system reboot to finish installing.
      Tip: Normally, an orange-colored shield icon will be displayed next to Shutdown button in the Start Menu Power Button or at notification tray area if a restart is required.
      If reboot is required, restart the computer to allow any pending updates is installed.
    2. Run Registry Editor (RegEdit).
    3. Navigate to the following registry key:
      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Setup\OOBE
    4. In the right pane, change the value data for MediaBootInstall from 1 to 0.

    5. Open an elevated command prompt as administrator.
      Run the command below to reset Windows 7 activation status:
      slmgr -rearm

    Tip from 

    Transfer Autocomplete Outlook 2010 from one pst to another pst


    The autocomplete list in Outlook 2010 is stored in folder

    C:\Users\"username"\AppData\Local\Microsoft\Outlook\RoamCache

    in the "Stream_Autocomplete_0_"numbers/Guid".dat" file.

    When you get the new profile created in Outlook, open a new message and send it to someone then close Outlook and reopen it and close it.
    This will create a new Stream_Autocomplete_0_"numbers/Guid".dat file. You can tell by the size because it will be very small like 8 kb or less.
    Copy the Stream_Autocomplete_0_.dat file from the old PC to the new one and rename it to have the same name as the new empty file and Outlook will use and they have their autocomplete list back. You must close, reopen and reclose outlook before replacing the file.
    You can also still edit the list with NK2Edit from nirsoft.net and you can convert entries in the list that are EX "Exchange" entries to SMTP entries.


    Friday, October 19, 2012

    How to install an IPA without iTunes using USB

    Download and install the iPhone Configuration Utility from Apple.

    You can get it for mac or windows here (look for "iPhone Configuration Utility")
    http://www.apple.com/support/iphone/enterprise/

    Here's some basic steps on how to use it:

    To install an app using iPCU:

    - Connect your iPhone/iPod to your computer via USB cable.
    - Close iTunes, if it is open, before launching iPCU
    - Launch iPCU. You should see your device appear in the “Devices” section on the left side of the window.
    - (I didn't have to do this step... i think you can skip it if you've ever installed anything to your device before.) Add the provisioning profile (mobile provision) to the iPCU Library: Click on “Provisioning Profiles”, then drag the .mobileprovision file into the Provisioning Profiles pane.
    - Add the application to the iPCU Library: Click on “Applications”, then drag the app into the Applications Pane. On Windows, the app will be a folder, named something like YourAppName.app. On Mac OS X, the app will be a single application file.
    - Access your device: Click on your device in the list of devices on the left. You should see five tabs appear in the main window: “Summary”, “Configuration Profiles”, “Provisioning Profiles”, “Applications”, and “Console”.
    - (I didn't have to do this step) Install the Provisioning Profile: Click on the “Provisioning Profiles” tab of your device. You should see your Ad Hoc Provisioning Profile in the list of profiles. In the “Install” column you should see either a button that says “Install” or a button that says “Remove” (if you’ve installed this profile previously).
    - Install the app: Click on your device’s “Applications” tab. You should see your app in the list of applications. In the “Install” column you should see either a button that says “Install” or a button that says “Uninstall” (if you’ve already installed the app).
    - If you've installed this app before, just click the button named "uninstall" then "install" to reinstall the app.
    - If not, then just click the button named "install".