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