Calculation sheet settings
The Sheet Settings dialog box lets you define settings for a particular sheet in a calculation. You can change the name of the sheet or change the function of the sheet between computation and workpaper.
- Open a calculation and select the sheet you want to work with.
- On the toolbar ribbon, select the Tools icon and selectSheet Settingsfrom the menu of options.
- TheNamefield shows the name of the currently selected sheet. To change the sheet name, enter the new name in theNamefield and selectOK.
- Users can reset the Name to the template name by selecting the refresh
button. - TheNavigation Parentarea corresponds to the list in the left pane. You can use the + and - selectors to collapse and expand this list.
- Select theComputation SheetorWorking Paperbutton to specify the purpose of the sheet.noteWhen you switch a sheet between computation and workpaper, the change will appear on the calculation history.
- SelectOK.