Revision as of 01:38, 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.
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.
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.

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

@@ Line 15: / Line 15: @@
 # Sheet Area
 #: It displays the content of current selected sheet, and you can perform most editing operations in this area.
+# 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.
 # 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
-#: 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 =