In: Root » » Microsoft office » Rearranging labels in a pivot table using Excel 2007
Creating a pivot tablePivot tables use the column headings of a spreadsheet to organize data in a table. Ideally, each column in the spreadsheet should identify a different type of data, such as the name of each salesperson, the sales region he or she works in, and the total amount of sales made. After you design a spreadsheet with multiple columns of data, follow these steps to create a pivot table: 1. Select the cells (including column labels) that you want to include in your pivot table. 2. Click the Insert tab. 3. Click the PivotTable icon in the Tables group. 4. (Optional) Select the cells that contain the data you want to use in your pivot table. You only need to follow Step 4 if you didn’t select any cells in Step 1, or if you change your mind and want to select different cells than the ones chosen in Step 1. 5. Select one of the following radio buttons: • New Worksheet: Puts the pivot table on a new worksheet • Existing Worksheet: Puts the pivot table on an existing worksheet 6. Click OK. Excel displays a PivotTable Field List pane. 7. Mark (select) one or more check boxes inside the PivotTable Field List pane. Rearranging labels in a pivot tableA pivot table organizes data according to your spreadsheet’s column headings (which appear in a pivot table as row labels). Each salesperson’s amounts are further divided by sales region, and the names of the products sold. However, you may be more interested in seeing the sales organized by sales region. To do this, you can modify which column heading your pivot table uses to organize your data first. To rearrange column headings in a pivot table, follow these steps: 1. Click the pivot table you want to rearrange. The PivotTable Field List pane appears. 2. Click the downward-pointing arrow of a label that appears under the Row Labels group. • Move Up: Moves the label one level closer to the beginning • Move Down: Moves the label one level down to the end • Move to Beginning: Makes the label the dominant criteria for sorting data • Move to End: Makes the label the last criteria for sorting data Modifying a pivot tableRow labels let you organize data according to different criteria, such as sales per region and then by product. For greater flexibility, you can also turn a row label into a column heading. To turn row labels into column headings in a pivot table (or vice versa), follow these steps: 1. Click the pivot table you want to modify. The PivotTable Field List pane appears. 2. Click a heading. A pop-up menu appears. 3. Choose Move to Column Labels (or Row Labels). Filtering a pivot tableThe more information your pivot table contains, the harder it can be to make sense of any of the data. To help you out, Excel lets you filter your data to view only certain information, such as sales made by each salesperson or total sales within a region. To filter a pivot table, follow these steps: 1. Click the pivot table you want to filter. The PivotTable Field List pane appears. 2. Click a heading in the Row Labels or Column Labels group in the PivotTable Field List pane. A pop-up menu appears. 3. Click Move to Report Filter. 4. Click in the filter list box at the top of the pivot table. 5. Click an item to filter your data. If you mark the Select Multiple Items check box, you can select two or more items to filter your data. 6. Click OK. Summing a pivot tableA pivot table not only displays information, but it can also count the number of occurrences of information, such as the number of sales per sales region. To display a count of data, you need to move a heading in the Values group inside the PivotTable Field List pane by following these steps: 1. Click the pivot table you want to modify. The PivotTable Field List pane appears. 2. Click a heading that you want to count in the PivotTable Field List pane. A pop-up menu appears. 3. Click Move to Values. |
legal disclaimer
Our website is not responsible for the information contained by this article. Web-articles is a free articles resource.
Suggestion: If you need fresh, daily updated content for your website, feel free to use our service. Click here for more information.
related articles
Cutting, copying, and pasting data may be handy within the same file, but Office 2007 also gives you the ability to cut, copy, and paste data between different programs, such as copying a chart from Excel and pasting it into a PowerPoint presentation. Using the Office Clipboard When you cut or copy any data, Windows stores it in a special part of memory called the Clipboard. This Windows Clipboard can only hold one item at a time, so Office 2007 comes with its own Clipboard called t...
The whole purpose of Microsoft Word is to let you type text and make it look pretty so you can print or send it for other people to read. So the first step in using Microsoft Word is learning how to enter text in a Word file, called a document. In every document, Word displays a blinking cursor that points to where your text will appear if you type anything. To move the cursor, you can use the keyboard or the mouse. Moving the Cursor with the Mouse ...
3. Creating text in Word Office 2007
Text can consist of a single sentence, multiple sentences, or several paragraphs. Text always appears indented underneath a heading (or subheading). To create text, follow these steps: 1. Move the cursor to the end of a heading or subheading. This is the heading (or subheading) that your text will be attached to if you move the heading (or subheading). 2. Press Enter. Word creates a blank heading. 3. Click the Demote to Body Text button....
4. Proofreading Your Document Office 2007
Besides checking for spelling or grammatical mistakes, Word can also proofread your document to highlight other possible problems, such as misplaced commas or correctly spelled words that may be used incorrectly. To make Word proofread your document, follow these steps: 1. Click the Proofing icon at the bottom of the document window. Word highlights a possible error and displays a pop-up menu offering options. 2. Choose one of the following: • ...
5. Changing Colors and Justifying Text Alignment in Office 2007
Color can emphasize text. There are two ways to use color: Change the color of the text (Font color). Highlight the text with a different color (Text Highlight color). Changing the color of text When you change the color of text, you’re physically displaying a different color for each letter. Normally, Word displays text in black, but you can change the color to anything you want, such as bright red or dark green. If you choose a light color for your text, it may be hard to re...
6. Creating a new document from a template using Word Office 2007
The easiest time to use a template is before you’ve typed any text. To create a new document from a template, follow these steps: 1. Click the Office Button and then choose New. A New Document window appears. 2. Click one of the following in the left pane of the New Document window: • Installed Templates: Displays templates installed on your computer • Any category under the Microsoft Office Online heading, such as ...
7. Microsoft office 2007 Creating a table by highlighting rows and columns
Organizing Text in Tables Tables organize text into rows and columns, which can make it easy to type, edit, and format text while spacing it correctly in your document. Tables organize text in cells, where a cell is the intersection of a row and a column. Word provides four ways to create a table: Click the Insert tab, click the Table icon, and then highlight the number of rows and columns for your table (up to a maximum of eight rows and ten columns). Use the Inse...