Things You'll Need:
- Excel Book
- Microsoft Excel
-
Step 1
Use multiple worksheets when creating spreadsheets for several related groups of information.
-
Step 2
Don't use multiple worksheets if your spreadsheets aren't related - create a new workbook instead.
-
Step 3
Don't use multiple worksheets to create "what if" scenarios for the same group of information (for example, best case, worst case, and most likely scenarios for one budget); use the Scenarios command in the Tools menu instead.
-
Step 4
To go to a new worksheet, click its tab at the bottom of the spreadsheet window.
-
Step 5
To use data from one worksheet in another worksheet's formula, just select the cells you want to refer to and paste them in the formula as you would other cells.







Comments
jtrue said
on 1/2/2009 Interesting