Format Worksheets


To add formatting to the cells in your worksheet…

  1. In WinTOTAL’s worksheet tool, select the appropriate cells, then click the Format Cells button. Or, right-click and choose Format Cells from the pop-up menu.
  2. From the Format Cells screen, you can change several options. Click the desired tab at the top of the screen to change the Number formatting, cell Alignment, Font, cell Borders, fill Patterns or Protection. In addition, you can restrict the data entered in a cell by using the Validation tab.

      Note:  The cell formatting options are similar to the options found in MS Excel and most other spreadsheets. For specific help in using any of these options, consult your spreadsheet software manual.  
  3. Click OK to save your formatting changes.
  Hint:  Worksheets are not intended for print. Instead, these formatting options can be applied to make your worksheets easier to use. For example, since linked fields are colored red and yellow, you might color data entry cells blue. Also, to preserve your formulas from being accidentally overwritten or deleted, use the protection formatting. Finally, remember that formatting applied in the worksheet does not transfer up to the form.