You can drag fields onto any PivotTable area. After you drag a field to the layout diagram, you can customize how it summarizes the data by double-clicking the field.When you place numeric fields in the DATA area, the PivotTable subtotals them as a sum. When you place text fields in the DATA area, they are summarized as a count of the rows that contain data.
You can copy a chart's data and formats to another chart. Select the chart, copy it, select the other chart, and then paste. ...
You can create a chart on its own sheet so you can print it independently. Select the data to chart, click the Chart Wizard ...
You can delete more than one sheet at a time. Hold down COMMAND while you click the sheet tabs, and then choose Delete Sheet ...
You can display more than one line of text in a cell. Choose Cells from the Format menu, and then select the Wrap Text check ...
You can drag fields onto any PivotTable area. After you drag a field to the layout diagram, you can customize how it summarizes ...
You can enter carriage returns in a cell to make the text easier to read. To enter a carriage return, press COMMAND+OPTION+RETURN. ...
You can extend the selection from the active cell to another cell on the sheet by holding down SHIFT while clicking that ...
You can filter your database to show a subset of the records. Point to Filter on the Data menu, then choose AutoFilter. Click ...
You can format a cell so that a number is treated as text. Click Cells on the Format menu, and then select Text on the Number ...