Features and Usages"
From Documentation
| Line 9: | Line 9: | ||
The above screenshot is Spreadsheet user interface, and each part of above is introduced as follows: | The above screenshot is Spreadsheet user interface, and each part of above is introduced as follows: | ||
# Toolbar | # Toolbar | ||
| − | #:The toolbar contains all commonly-used functions. It has 2 tabs, another tab is used to insert chart, image, and hyperlink: | + | #: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: |
| − | #: [[File:essentials-feature-toolbar.png | | + | #: [[File:essentials-feature-toolbar.png | 700px]] |
# Formula bar | # Formula bar | ||
| − | # | + | #: It displays editing text or formula of current selected cell and can be used to enter or edit a formula or data. |
| + | # Sheet Area | ||
| + | #: It displays the content of current selected sheet, and you can perform most editing operations in this area. | ||
# Sheet bar | # Sheet bar | ||
| + | #: A list of all sheets of this book. You can navigate to any sheet by clicking on it. Click [[File:essentials-feature-addSheet.png]] can add a new sheet and right click on a sheet can rename, delete, anc change order of it. | ||
# Context menu | # 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. | ||
| − | |||
| + | = Usage = | ||
| − | + | == Hot Key == | |
| − | + | The default supported hot keys are: ^X^C^V^D^B^I^U#del. | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | == Auto Fill == | |
Revision as of 01:29, 5 August 2013
Spreadsheet User Interface Overview
The above screenshot is Spreadsheet user interface, and each part of above is introduced as follows:
- 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:
- Formula bar
- It displays editing text or formula of current selected cell and can be used to enter or edit a formula or data.
- Sheet Area
- It displays the content of current selected sheet, and you can perform most editing operations in this area.
- Sheet bar
- A list of all sheets of this book. You can navigate to any sheet by clicking on it. Click
can add a new sheet and right click on a sheet can rename, delete, anc change order of it.
- A list of all sheets of this book. You can navigate to any sheet by clicking on it. Click
- 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.
Usage
Hot Key
The default supported hot keys are: ^X^C^V^D^B^I^U#del.