Microsoft Office Blog by Chris Menard

Create odd and even headers/footers in Word for duplex printing

If you need to print two-sided or duplex printing, in Microsoft Word you should use Odd and Even Headers to align your page numbers.

Many to One Mail Merge in Microsoft Word

By default, Microsoft Word performs a mail merge and One to One, but you can use Graham Mayor's add-in to make Word perform a Many to One mail merge.

Create your own custom Watermarks in Microsoft Word

You can create your own text custom watermark in Microsoft Word. After creating the watermark, you can move it anywhere on your Word document.

Use Quickstarter to set up a great presentation in PowerPoint quickly

QuickStarter in PowerPoint is a fast way to build an outline and suggested sections, talking points, and properly attributed Creative Commons images.

Use the text function in Excel to add leading zeros

When you type in numbers in Excel, the leading zero will get dropped. Use the Text function in Excel to add back the leading zeros.

Conditional Formatting with two criteria using AND function in Excel

If you need to select an entire row using two conditions with Conditional Formatting in Excel, you need to write a formula using the AND function.

Create a data validation drop down list in Excel by Chris Menard

You can make a drop down list so only correct data is entered. If bad data is entered, sorting, filtering, pivottables, and other stuff will be incorrect.

Use absolute reference in Excel to keep a cell constant when you copy or autofill

If you need a cell to stay constant, you can make it an absolute reference cell to stay constant. Press the F4 function key to create an absolute reference.

Create your own custom sort in Excel

Excel already has built-in custom lists for sorting, but you can create your own custom sort list in case you don't want to sort alphabetically or A to Z.

Word - make headings 1 always show on a new page using Page break before setting

In a long Word document, it is often desirable to have Heading 1 styles show at the top of a new page and never have two headings 1 on the same page.

Delay or schedule sending email messages in Microsoft Outlook

When you click Send on an email, it is typically sent immediately, but you can have it sent at a later time by using delayed delivery in Outlook.

Create canned responses in Microsoft Outlook by using Quick Parts

Do find yourself typing the same message over and over in Microsoft Outlook? You can use Quick Parts in Outlook to create canned responses to emails.