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

The following sections will introduce usages of some noticeable features.


Supported Hot Key

Hot Key
Action
Ctrl+B bold
Ctrl+C copy
Ctrl+I italic
Ctrl+U underline
Ctrl+V paste
Ctrl+X cut
Delete clear content

Special Paste

Custom Sort

Filter

The Filter can screen out data you don't want quickly and easily. We usually select the cells we want to filter first and select "Filter" on the toolbar.

Essentials-feature-filter-enable.png


Then each column will have a drop-down button. Click the drop-down button to select data to filter.

Essentials-feature-filter.png


Those rows that contain the unchecked item will not appear in the original table unless you check them back.

Essentials-feature-filter-after.png

If you insert more data after applying a filter, you can select "Reapply" on the toolbar to apply same criteria to new data.

Auto Fill

Auto fill is a handy feature to fill cells with data in particular pattern based on selected cells. Text will be copied and numbers and dates will be increased (or decreased).

To use this, You should select one or more cells and drag the fill handle across or down the cells that you want to fill.

Essentials-feature-autoFill-select.png

Fill cells after dragging right.

Essentials-feature-autoFill.png


Format Cell

Insert Hyperlink