​

Working with multiple worksheets

​

 

Related worksheets in a workbook can be linked through formulas. When entering a formula that references another worksheet, you must include the appropriate worksheet name (and exclamation point) with the cell coordinates, for example:

 

=April!B5+May!B5+June!B5

 

If you use the pointing method to specify cells, the worksheet names, as well as the exclamation points, are entered automatically.

 

Reflection Activity
•Which feature (paste links or typing =) you like the most? Why?

​

 

Paste Special

 

Microsoft Excel 2010 normally copies all the information in the range of cells you select when you paste the data. Use Excel's Paste Special command to specify other options, such as pasting only the cell contents (without the formatting) or only the formatting (without the cell contents).
To paste particular parts of a cell selection, click the Paste button arrow on the Ribbon's Home tab. Then, click Paste Special on its drop-down menu to open the Paste Special dialog box.

 

Reflection Activity
•Which tool does the same than the copy formats feature?

 

 

​