Inserting Section Breaks in a Word Document

Section breaks can be used to control the layout and formatting issues in a document, such as different margins on specific pages or different page number formats. To insert section breaks do the following:

Make sure your cursor is located where you would like to place the Section Break.

  1. Select the Page Layout Ribbon Tab (Fig 1).
  2. Select the drop down arrow next to Breaks in the Page setup Group (Fig 1 and Fig 2).
  3. Choose the type of Section break you want (Fig 2).

 

Figure 1-The Page layout Tab and Breaks Tool Button

Figure 2-The Breaks drop down list

Two of the most commonly used Section Breaks are the Next Page Section Break (Fig 2) which creates a new section and forces everything below it to the next page, and the Continuous Section Break (Fig 2)  which creates a new section without forcing everything below it to the next page.

Thanks for visiting this blog page, I hope this helps you understand how to insert Section Breaks in a Word document. Stayed tuned for more posts on this subject and other important Microsoft Office tips!

Posted in Microsoft Office tips, Word tips | Tagged , , , | Comments Off

Inserting a different header on the first page of a Word document

To insert a different header on the first page of a document than on the rest of the pages, activate the header section on the first page of the document.  Double click near the top of the first page to do this.

 

Figure 1

 

Once the header is active, you will see a Header & Footer Tools Ribbon Tab at the top of the screen. Select the check box for Different First Page. If you select this box when your First Page Header is active, you will then be able to put one header on the first page and a different header on all the subsequent pages.

 

Thanks for visiting this blog page, I hope this helps you understand how to create a different first page header in a Word document. Stayed tuned for more posts on this subject and other important Microsoft Office tips!

Posted in Microsoft Office tips, Word tips | Tagged , , , | Comments Off

Creating an Excel PivotTable

Creating a PivotTable

If you have a data list or table, and the data can be grouped by one or more fields in that list, you can dissect your data with an Excel PivotTable. The PivotTable is a powerful tool that can help you view your data in many ways.

To create a PivotTable (Figure 1):

    1. Select any cell in your list.
    2. Select the Insert Tab.
    3. Select the PivotTable Tool Button on the left side of the Insert Tab to open the Create PivotTable Dialog Box.

Figure 1: The Main Data List


The Create PivotTable Dialog Box (Figure 2):

  1.  Verify the Table/Range that contains your data is correct.
  2. Choose where you would like to place your PivotTable. Putting it in a New Worksheet makes it easier to work with.
  3. Select OK to create your PivotTable.

 

Figure 2 – The Create PivotTable Dialog Box

Manipulating your PivotTable:

  1.     Select the fields you want to use from the PivotTable Field List. (Figure 3)
  2.     The data is grouped and totaled in this example. (Figure 4)

  

Figure 3 – The PivotTable Field List

 

Figure 4- The PivotTable

Thanks for visiting this blog page, I hope this helps you create a basic PivotTable. There is a lot more that Excel can do with your data in a PivotTable. Stayed tuned for more posts on this subject and other important Microsoft Office tips!

 

Posted in Excel tips, Microsoft Office tips | Tagged , , , , , | Comments Off