Under Collated, you can select how you want multiple copies to print. Print Selection to print just the cells you have selected. Print Entire Workbook to print all worksheets in the workbook. Print Active Sheets to print the worksheet that is currently active (or being displayed) in Excel. This allows you to print all, or just portions, of your file. Under Print Active Sheets, select what parts of your workbook you want to print. To prepare your workbook or worksheets for printing, first select your printer in the Printer section on the left. On the right side, you'll see the print preview. When you're finished adding headers and footers, go to the View tab, then click Normal view to exit out of Page Layout view. Now, you can scroll down your worksheet to add a footer:Ĭlick outside of the footer area, and your page number is added: When you add Headers & Footers, Excel takes you to Page Layout view.Īlso, when you add a header, the Header & Footer tools appear in the Ribbon.Īs you can see above, you can add page numbers, number of pages, date, time, sheet name, a picture, etc.Ĭlick outside of the header to apply it to your worksheet. This is what you'll see in your spreadsheet: To insert a header or footer, go to the Insert tab and choose Header & Footer.Ĭlick the Header & Footer button. Both can contain page numbers, and headers often contain the title of the worksheet, and perhaps the date. Headers appear at the top of a worksheet. To change this to totals, click the downward arrows, then select Value Field settings.īelow is our pivot chart. In the Values section in the Field list, we notice that it's showing a count instead of totals.
LEARNING PIVOT TABLES IN EXCEL 2013 HOW TO
To show you how to do this, let's refer back to our pivot chart in the last section. When creating pivot charts and tables, you may want to modify the fields listed in the Field list on the right so that the data that you want displayed is displayed in your pivot chart or pivot table. The only difference is you have two different categories: the axis and the legend.Ĭhanging Field Settings for Pivot Tables and Pivot Charts Now you can organize your pivot chart just as you did a pivot table. Next, select if you want it in a new or existing worksheet. We're going to just create a pivot chart. Select if you want to create just a pivot chart – or a pivot chart and table. You can also create a pivot chart from a table.Ĭlick the Pivot Chart button under the Insert tab.
Otherwise, Excel will only create the pivot table/chart up to the blank row or column. Tip: Make sure there aren't blank rows or columns before you begin. The totals in the pivot table reflect both salaries. Let's amend the chart to show you what we mean by adding another Account Manager.Īs you can see, we added another Account Manager to our table. If we had more than one salary per job description, it would total the salaries for us. Now we can see the salary by department and by job description. We want the values shown in the table to be salary, so we will drag and drop that to Values. We want Position to be a Row Header, so we drag and drop to Row Labels. Let's create a pivot table using the table above. Here's a better example because it shows you what a pivot table can do with your data. You can add a filter for any category: First Name, Last Name, or Phone number (in the case of our table).
We can also use the filter we created at the top to select a phone number to find out who it belongs to. Now we can see how many phone numbers we had for each person. Here's what we've done in the Field list on the right: You can always drag and drop to a different section if you want. Your pivot table will appear in your spreadsheet as you do this. Just drag and drop from the top part of the field list to the bottom part and place it in a category: Filters, Columns, Rows, and Values. If you look at your Pivot Table Field list on the right, you can drag and drop from the "Choose Fields to Add to Report" section down to the "Drag Fields Between Areas Below" section. This is what you should now see on your screen: The name field in our table would be arbitrary. In ours, that's the salaries.Īrbitrary fields are fields that are neither data or category. In ours, we grouped category fields by department and position.ĭata fields are fields that contain data that you can add, subtract, multiply, or divide.
This is a list of all fields in your table.Ĭategory fields are fields that you can group. On the right, you'll see the Field list open up. To do this, select the table, then go to the Insert tab and click Pivot table. We want a pivot table showing us how many phone numbers are on file for each employee. In tables, columns are fields and rows are records. The best way to learn about a pivot table is to see how to create one.
0 kommentar(er)
