Common features

After accessing a workbook, you can Undo, Redo, Cut, Copy, and Paste data content. See the following figure.



Condition rules

By clicking Set Conditional Formatting on the toolbar, you can add rules for data results. For example, you can highlight data within a certain range. See the following figure.



Add hyperlinks

The Workbook provides the Add Hyperlink icon, which helps you create more beautiful charts with richer content. See the following figure.



Add drop-down lists

You can click Drop-Down List on the toolbar to add labels for data entries.
Note
Multiple labels must be separated by commas (,).


Text format

The text format feature enables you to adjust text in charts. This feature supports the following operations:

  • Set the font, color, and background of text.
  • Set the size and style (such as bold, italic, underline, and strikethrough) of text.
  • Set the format of cells (such as text alignment, text wrapping, indentation, and cell merging).
  • Set the format of text (such as general, number, text, percentage, date, and custom settings).

Table attributes

The table attribute feature enables you to adjust table attributes. This feature supports the following operations:

  • Insert rows, insert columns, delete rows, delete columns, autofit row height, and autofit column width.
  • Group, ungroup, hide rows, hide columns, freeze rows, and freeze columns.
  • Set borders.
  • Sort, filter, and set table styles.