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 charts, images, and hyperlinks:
    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 usually perform most editing operations in this area.
  4. Context menu
    Right clicking on a cell, a column header, or a row header pops up a context menu. It contains most options of the toolbar and 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. Right clicking on a sheet pops a context menu: Essentials-feature-sheet-contextmenu.png and it allows you to delete, rename, protect, and move the clicking sheet.

Usage

Hot Key

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


Auto Fill