2.37 FAQ-473 What formatting capabilities are available for the worksheet?

Last Update: 2/1/2018

  • Rich Text Formatting (RTF): Worksheets support rich text formatting.
  • Use the Style and Format toolbar buttons to change font color, background cell fill color, font size, text alignment, bold, border line etc.
  • Use the Merge Cells button to merge worksheet cells. Value/Text in most upper-left corner cell will be displayed.
  • Use Dynamic Merge on Format tab of Worksheet Properties dialog to make adjacent cells with same value/text merged.
  • The Format Cells dialog box can be used to format a selected range of data. Right-click on the selected range and choose Format Cells from the context menu. In this dialog you can specify such things as Rich Text, Wrap Text, Disable Editing, etc.
  • Resize row height and column width.
  • Add gap above worksheet.
  • Show and Hide column/row header, column label rows and add user-defined column label rows.
  • Set worksheet to use Spreadsheet cell notation so simple column formula and cell formula notation can be used. E.g. A-B means column A minus column B; =total(A1:A10) set a cell value to be sum of cells from A1 to A10.

Keywords:color, font, alignment, wrap, theme, template