Summing work hours in Excel

Excel cell with the regular Time format hh:mm counts or sums up to 24:00 hours therefore to sum and display amount of hours greater than 24 hours, the format of the cell must be customized.

In order to sum the total work hours accumulated after several days, the format of the cell containing the total sum of the hours, should be changed to the Custom format type [hh]:mm.

Formatting cell G7 to [hh]:mm in 3 clicks:

* * *

How to create new *.PST file

Outlook 2010 enables to keep Contacts/Calendar/Notes folders in an external file.

The file format is filename.PST.

To create a new PTS file, on the Home TAB click New Items, More Items, Outlook Data files . . .

* * *

Use portrait and landscape pages in the same doc

In order to change page orientation from portrait to landscape in the same Word 2010 document, section break must be inserted at the end of the text on the page that precedes the page with the modified orientation.

For example in document with four pages we would like that pages 1 and 2 will be in portrait orientation and pages 3 and 4 will be in landscape orientation, section break must be inserted at the end of the text on page 2.

Do the following:

1. Click once at the end of the text on page 2 to place there the courser.

2. Click the Page Layout TAB then click the Breaks icon.

   

    These options will be displayed

3. Click the Next Page under the Section Breaks options

 

    After this, the courser should be placed on page 3 of the document.

 

4. Click the Orientation icon on the Page Layout TAB

    The Portrait and Landscape options will be displayed.

 

5. Click the Landscape option.

    This will change the orientation of page 3 and all subsequent pages, to Landscape.

    * * *

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

***