- Sheet tabs are located along the bottom of every Excel document. They look like tabs; when you open a new document, they will be labeled "Sheet 1," "Sheet 2" and "Sheet 3," and each document will be blank. Changing back and forth between sheets is simple; just click on the appropriate sheet tab.
- Sheet tabs are essentially virtual versions of a stack of papers, each labeled with a tab for easy organization and reference. Different sheets can be used for different aspects of a project. For example, if you use Excel to organize your home finances and budget, you may create a workbook entitled "Smith Household Finances." You can then create different sheets, with tabs labeled things like "Savings," "Budget," "Debt" and "Investments." The various sheets can then be easily and concisely saved in one document.
- To customize sheet tabs, simply right-click on the sheet tab you desire to change. You will have the option to insert a new tab or delete an existing one. You can rename individual sheets, rearrange sheet tabs or create an exact copy of an existing sheet, formulas and all. You can also change the colors on your sheet tabs, color coding them just as you might a binder.
- Worksheets within a workbook can be easily linked by clicking back and forth on different sheet tabs in an Excel document. Using the home finances example again, say you plan on saving 10% of your income each month. On your savings page, enter the multiplication formula, in the desired cell (=.1*). Then click on the sheet tab where your income information is found, and click on the appropriate cell. Hit "Enter." The two sheets will then be linked; if you change the information on your income page, the savings page will automatically update, as well.
- Advertisement -
- Advertisement -