How to Create a Cover Page in Microsoft Word 2007

When you create reports, books and other long documents in Microsoft Word, you may want to include a cover page at the beginning of the document. A cover page usually includes a title, author, purpose of the document, date created and/or other general information. The use of a cover page adds a professional touch to the document. In older versions of Microsoft Word, you had to manually create your cover page by figuring out how to place the text, and add your own borders if desired. However, Microsoft Word 2007 has a very nice cover page feature with several pre-formatted options to make it really easy to create a nice, professional cover page.

Easy Instructions

1. Step 1
Open your document in Microsoft Word 2007.
2. Step 2
Select the "Insert Menu." In the "Pages" section on the left-hand side, click on "Cover Page."
3. Step 3
A menu will pop up with a number of pre-formatted cover pages. Scroll through them using the scroll bar on the right until you find one you like that suits your purpose.
4. Step 4
Click on the cover page template you want. Your cover page will appear at the beginning of your document.
5. Step 5
Click on each field, designated by brackets with descriptions such as "Title" and "Abstract." With one click, the whole field will be highlighted. Simply start typing what you want to appear there. When you click on the date or year field, if there is one on the template you chose, a down-pointing arrow will appear on the right. Click on that, and a calendar will appear. Click on the date you want. You should make all your changes to the fields before you click "Save," because they will be converted to text.
6. Step 6
Customize your text as you normally do with any other text. Change the size and color, add bold or underline. Microsoft Word 2007 uses text boxes and tables for some of the templates, so click on the "Format Menu" that appears when you are on the cover page. This will enable you to adjust things like the size and shapes of the text boxes or the "Design Menu" to change the look of the tables.
7. Step 7
When you are finished making changes to your cover page, click "Save" and continue working in your document as needed. The cover page will convert to text and become a part of your document.

Shortcut Commands 101

CTRL combination shortcut keys---Shortcut Command

CTRL+SHFT+( Unhides any hidden rows within the selection. + –
CTRL+SHFT+) Unhides any hidden columns within the selection. + –
CTRL+SHFT+& Applies the outline border to the selected cells. + –
CTRL+SHFT_ Removes the outline border from the selected cells. + –
CTRL SHFT ~ Applies the General number format in Microsoft Excel. + –
CTRL+SHFT+$ Applies the Currency format with two decimal places (negative numbers in parentheses). + –
CTRL+SHFT+% Applies the Percentage format with no decimal places. + –
CTRL+SHFT+^ Applies the Exponential number format with two decimal places. + –
CTRL+SHFT+# Applies the Date format with the day, month, and year. + –

Microsoft Excel 2007
CTRL+SHFT+( Unhides any hidden rows within the selection. + –
CTRL+SHFT+) Unhides any hidden columns within the selection. + –
CTRL+SHFT+& Applies the outline border to the selected cells. + –
CTRL+SHFT_ Removes the outline border from the selected cells. + –
CTRL SHFT ~ Applies the General number format in Microsoft Excel. + –
CTRL+SHFT+$ Applies the Currency format with two decimal places (negative numbers in parentheses). + –
CTRL+SHFT+% Applies the Percentage format with no decimal places. + –
CTRL+SHFT+^ Applies the Exponential number format with two decimal places. + –
CTRL+SHFT+# Applies the Date format with the day, month, and year. + –

CONCATENATE

Joins several text strings into one text string.

Syntax

CONCATENATE (text1,text2,...)

Text1, text2, ... are 1 to 30 text items to be joined into a single text item. The text items can be text strings, numbers, or single-cell references.
Remarks

You can also use the ampersand (&) calculation operator instead of the CONCATENATE function to join text items. For example, =A1&B1 returns the same value as =CONCATENATE(A1,B1).

Example
The example may be easier to understand if you copy it to a blank worksheet.
How to copy an example
1. Create a blank workbook or worksheet.
2. Select the example in the Help topic.
Note Do not select the row or column headers.

Selecting an example from Help
3. Press CTRL+C.
4. In the worksheet, select cell A1, and press CTRL+V.
5. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode.

1
2
3
4
A
Data
brook trout
species
32
Formula Description
=CONCATENATE("Stream population for ",A2," ",A3," is ",A4,"/mile")
Concatenates a sentence from the data above (Stream population for brook trout species is 32/mile)

Start numbering on the second page with 1 (WORD 2007)

1. Follow the steps for removing the page number from the first page.
2. On the Insert tab, in the Headers & Footers group, click Page Number, and then click Format Page Numbers.
3. In the Start at box, type 0.

Organize Your Records the Way You Want Them in Excel

You can customize how you sort your records by using a filter. To activate a filter:
1. In Microsoft Office Excel 2007, click Filter on the Data tab.

2. To choose your sorting options, click the filter arrow on the column that you want to sort, point to Sort by Color, and then click Custom Sort.

3. Create a customized sort order.
a. In the Sort dialog box, under Column, click the drop-down arrow next to Sort by, and choose the field that you want to be sorted. Values should appear in the Sort On field.
b. In the Order field, click Custom List. This will open a window that offers an entirely custom sort list.
c. In the left pane, list the values (each separated by a comma) in the order that you want them to be sorted, and then click Add.
d. In the right pane, select the list you've created, and then click OK.
e. In the Sort dialog box, click OK.

From now on, your records will be sorted according to your customized list.

Easy Filtering of Data in a Microsoft PivotTable View

There is a better way to select multiple report filters than dragging the filter down to a row. It is quicker to select additional filters directly from the original filter.

1. Select the filter, and then click multiple items at the bottom.

2. The filter selection changes to check boxes. Simply select the boxes you require.

Change the Default File Location

Many users find that they tend to open workbooks from the same folder on their computer. If that Windows Vista folder isn't Documents (My Documents in Windows XP), you can change the folder that Microsoft Office Excel 2007 displays when you want to open or save a workbook. Here’s how:
1. Click the Office button.
2. Click Excel Options.
3. In the left column, click Save.
4. Type the desired location in the Default file location box.