Microsoft Office Tutorials and References
In Depth Information
Selecting and Naming a Worksheet
formulas as necessary whenever you modify a worksheet and automatically recalculates
formulas to ensure that the results are always up-to-date.
Perhaps each month you create an inventory worksheet in which you enter repetitive
information; all that changes is the actual data. By creating your own template, you can
have a custom form that is ready for completion each time you take inventory. Formatting,
formulas and other settings are already set up, so that you can begin working on the task at
hand. A template file saves all the customization you made to reuse in other workbooks.
Excel and Office comes with a variety of pre-made templates that you can use for your
own business and personal needs.
Selecting and Naming a Worksheet
Each new workbook opens with three worksheets (or sheets), in which you store and ana-
lyze values. You can work in the active, or selected, worksheet. The default worksheet
names are Sheet1, Sheet2, and Sheet3, which appear on the sheet tab, like file folder la-
bels. As you create a worksheet, give it a meaningful name to help you remember its con-
tents. The sheet tab size adjusts to fit the name’s length, so using short names means more
sheet tabs will be visible. If you work on a project that requires more than three work-
sheets, add additional sheets to the workbook so all related information is stored in one
Select a Worksheet
If necessary, click a sheet tab scroll button to display other tabs.
Click a sheet tab to make it the active worksheet.
Search JabSto ::

Custom Search