Read a computer book in TM library

Copy a worksheet

1) Find the worksheet you want to copy and click its sheet tab.

2) Click the Home tab.

3) Click Format button.

4) Select Move or Copy Sheet.

Analysing data with a PivotTable

1) Click anywhere in the table.

2) Click the Insert tab.

3) Select PivotTable.

4) From the dialogue box, click the Select a table or range option.

5) Select the New Worksheet option.

Page breaks control the arrangements of data on worksheets that are larger than a printed page. If you do not like the location of the automatic page break, you can set your own. To insert a horizontal and vertical page break at the same time, click the cell below and to the right of where you want the break to occur.

To create a cell comment

1) Click the cell to which you want to add a comment.

2) Click the Review tab.

3) Click the New Comment button.

Holden, G. (2010). Excel 2010 in simple steps. Prentice Hall.