Posts Tagged ‘number’

Print Company and Client Telephone Directories in MS Outlook

Thursday, May 26th, 2011

MS Outlook is such a robust piece of software!  Did you know that you could print your company telephone directory or a client directory using Outlook?

The good news is that it is very easy to do and looks very professional.  The better news is that you can do it quickly using your Contacts list.

Follow the steps below to learn how:

  • Launch MS Outlook.
  • Click on Contacts, but if you have multiple e-mail accounts, be certain you go to the correct account unless you want to print a directory of all your contacts, in which case you can go to the section below.  But if you want to print only certain contacts in your directory, you will have to select them by clicking CTRL + those that you would to include.
  • In version 2003, click on File. In version 2007 click on the Office button or in version 2010, click on the File tab and click Print. As all of you know, I prefer using the quicker shortcut of CTRL + P.
  • In the Print Style list which is called Settings in version 2010, select Phone Director.
  • If you selected only certain contacts you want included, be certain that you go to Print Options and select the Only Selected Items radio button.

You can always choose to print a certain page or range of pages as well as more than one copy of your directory.

MS Outlook will create and print a very nice directory for you in alphabetic order. Each of your contacts will be listed in the order of last name, first name and phone number.  If your contact has multiple phone numbers, each will be listed with a description such as Office, Mobile or Home.

I think you are going to find this a real life save – quick and easy.  You will look like the office genius!  Let them think you figured it out all by yourself!  I won’t tell!

Create A Page X of Y Quick Part in MS Word 2010

Thursday, May 19th, 2011

A reader wrote to me recently telling me he was having an issue for Page X of Y in MS Word 2010. He said the choice did not show up on his Ribbon in any of the Groups.

So I told him how to create a Quick Part that would resolve his issue.

Follow the steps below to learn how:

  1. Open a new blank document
  2. Key in the word Page and click your spacebar once.
  3. Click Alt + Shift + P, which will insert a page number code for the current page and click once on your spacebar.
  4. Key in the word of and click your spacebar once again.
  5. Click Alt + I + F.
  6. When the field dialog displays, click on N as many times as necessary to more your cursor to NumPages, which is the code for the total number of pages in your document.
  7. Click OK.
  8. You should see “Page X of Y” where X represents the page number of the current pages and Y represents the total number of pages in your document.
  9. Select the text and codes and click Alt + F3. If you care to do it the long way (which I would never advocate), you can click on the Insert tab | Quick Parts | Save Selection to Quick Part Gallery, but if you do that, this method will place your new Quick Part in the BuildingBlocks.dotx template and you will not be able to use AutoComplete to expand the entry.
  10. When the Create New Building Block appears, key in an abbreviation that is intuitive for you, such as pxoy.
  11. Click OK.

Now to insert the Page X of Y entry:

  • Place your cursor where you would like the text and codes to appear, such as the footer of your document.
  • Key in your abbreviation.
  • Click F3 or if the AutoComplete prompt appears, click your Enter key.

Add AutoNumbering to your MS Excel Spreadsheet

Thursday, February 26th, 2009

Autonumbering will advance your numbered rows and keep them current, even if you should delete or add a row.

Unfortunately, MS Excel does not ship with an autonumbering feature like that found in MS Access, that increments a number each time you add a new row. In Excel 2003 and 2007 however, you can use the Row function to add your own autonumbering to a list.

Say you want to create a list of all of your school’s classes and their corresponding learning materials.

Follow the steps below to add autonumbering to the list:

  • In A1, enter the formula below:

=TEXT(Row(A1),”000-000″)

  • Enter the name of the first class in B1.
  • Enter the learning material of the first class in C1.
  • Copy cell A1 to A2.
  • Enter the name of the second class in B2.
  • Enter the learning material of the second class in C2.
  • Select A1:C2.
  • Go to Data | List and select Create List.

Data List Dialog Box

  • In Excel 2007, press CTRL + T and then click OK.

Notice, that when you type the name of the next class in B3 and press Tab, MS Excel will automatically provide the next number for you.

Autonumbered List