Set print area in Excel 2010

1. Select the area you want to print

2. Click the Page Layout TAB

3. Click the Print Area icon,

    Two options will be displayed Set Print Area and Clear Print Area.

4. Click the Set Print Area

* * *

Disable Suggested Contacts in Outlook 2010

Stop Outlook accumulating contacts in the Suggested Contacts folder by clearing the checkbox of “Automatically create Outlook contacts for recipients that do not belong to an Outlook Address Book” located at the bottom of the Contacts page in Outlook Options.

 

 

Clear this checkbox

 

After the above steps, delete all contacts in the Suggested Contacts folder and from now on the folder will remain empty.



 

* * *

 

How to display Excel sheet columns Right-to-Left

In Excel 2010:

Click the File TAB, Options, Advanced

Roll down to Display options for this worksheet section

Click to select the checkbox Show sheet right-to-left (3^rd checkbox)

 

* * *

 

Insert filename in Word 2010 document header

1. Double click on the header area at the top of the open Word page.

- Design tab will open with Header & Footer Tools

2. Click the Insert tab.

3. Click the Quick Parts

- Pull-down menu will open

4. Click Field . . .

- Pop up window will display list of options to select

5. Scroll down and click Filename

6. Click the OK button

The filename will be displayed in the header

***

How to delete Device’s Port in Windows 7

Click Start, Devices and Printers.
Click on the Device.
Click the Printer server properties button, at the top of the window. A new window will open.
In the new window click the Ports tab.
Select the port you wish to delete and then click the Delete port button.

Delete all Calendar events in Outlook 2010

“Clean” your Outlook 2010 calendar by deleting all events:

1. Click the Calendar folder

2. Click the View TAB

3. Click the Change View button

4. Click the List button

5. In the main window select all events by Control+A

6. Delete the list of all events

* * *

View System Events in Windows 7

Reviewing Windows events is a good tool provides hints on SW and HW errors that the computer had faced, such as sudden restart or non-noticeable issues.

Two ways to see the event log:

(1) Click Start button , Control Panel, Administrative Tools, double-click the Event Viewer. The Event Viewer window will pop-up.
In the left list, click Windows Logs, System.

To see the events, scroll down in the main window at the center.
Error will be written in red. Details of the event is given in the window at the bottom.

(2) Click the Start button . In the Search box, type Event Viewer, double-click the Event Viewer in the result list. The Event Viewer window will pop-up.

* * *