Features and Usages

From Documentation


Features and Usages




Spreadsheet User Interface Overview

Essentials-feature-ui.png

The above screenshot is Spreadsheet user interface, and each part of above is introduced as follows:

  1. Toolbar
    The toolbar contains all commonly-used functions including setting cell's style, alignment, border, background color, font, font color, merging (and unmerging) cells, sorting, auto filter, protection and grid line visibility. It has 2 tabs, another tab is used to insert chart, image, and hyperlink:
    Essentials-feature-toolbar.png
  2. Formula bar
    It displays editing text or formula of current selected cell and can be used to enter or edit a formula or data.
  3. Sheet Area
    It displays the content of current selected sheet, and you can perform most editing operations in this area.
  4. Context menu
    Right click on any cell pops up a context menu. It contains many options like a toolbar and menu which works like a shortcut.
  5. Sheet bar
    A list of all sheets of this book. You can navigate to any sheet by clicking on it. Click Essentials-feature-addSheet.png can add a new sheet and right click on a sheet can rename, delete, anc change order of it.

Usage

Hot Key

The default supported hot keys are: ^X^C^V^D^B^I^U#del.


Auto Fill