How to Print Gridlines and Row and Column Headings in Excel 2010

1 Click the Page Layout tab in the Ribbon.

 

 

Notice the check boxes in the Sheet Options group.

2 Click the Print check box in the Gridlines column of the Sheet Options group.

Check this option to print the gridlines surrounding each cell in the worksheet. By default, these gridlines do not print.

3Click the Print check box in the Headings column of the Sheet Options group.

When this option is selected, the column letters and row numbers will print along with your data.

Preview the worksheet before printing, to see the effect of displaying gridlines and/or column and row headings.

Remember to deselect both Print check boxes to return them to their default settings, as necessary.

Fix a Problem Where Folders Open in New Window Every Time in Windows 7

When you open Windows Explorer and double-click a folder, it may open a new explorer window rather than showing the folder contents in the existing window. This may happen although "Open each folder in the same window" setting is selected in Control Panel -- Folder Options.

This could happen after installing certain versions of VaultClient software, and issue can be resolved by registering a DLL file. Use these steps:

Open an elevated Command Prompt window. To open an elevated Command Prompt, click Start, click All Programs, click Accessories, right-click Command Prompt, and then click Run as administrator. Type the following command and hit ENTER:


Command for Windows 7 32-bit :

regsvr32.exe "%Programfiles%\Internet Explorer\ieproxy.dll"



Command for Windows 7 64-bit (Registering the 32-bit module) :

regsvr32.exe "%Programfiles(x86)%\Internet Explorer\ieproxy.dll"



You should see a similar message as below, in the output window:

DllRegisterServer in ieproxy.dll succeeded.

Set a startup password for Microsoft Outlook

Some computer users who work in an office or on a PC with other roomates or kids would like to password protect their email, calendar, contacts, etc in Microsoft Outlook. Until today, I didn’t know how to do that. As you know, when I learn something new, I pass it on to you. Remember, this tip is for OUTLOOK users NOT Outlook Express users:

1. Start Microsoft Outlook
2. RIGHT Click the Outlook Today icon on the left or the "Personal Folders" icon
3. Click Properties
4. Click the Advanced button
5. Click the "Change Password" button
6. Leave the "Old Password" box blank since you never had one
7. Type the password you want to use in the "New Password" box
8. Type the password again in the "Verify Password" box
9. DO NOT check the "Save this password…" option
10. Click OK on all three open screens

The next time you open Outlook, you will be prompted for the password you just set thus protecting access to your Outlook data.