Friday, November 7, 2008

Ch.7--"Worksheets and Workbooks"

When you open Microsoft Excel you have a spreadsheet in front of you and in the lower left-hand corner there are other sheets called worksheets. A workbook is a collection of all those worksheets. To transfer from one worksheet to another all you have to do is click on the worksheet you want to work on. To help identify which worksheet is which you can change its name by double clicking on it and typing what you wish to call it and you can change its color by going into Format then Sheet then Tab Color. You are able to link things from different cells of one worksheet to another. First you have the cell selected enter = then click on the worksheet you wish to link to that spot. Now that worksheet is opened. Finally to link you click the cell in that sheet to your first sheet you just click on it and hit enter. Excel transfers it. You can add cells from different sheets using the same technique except you need an addition sign. Working with different worksheets is made simple in Excel.

No comments: