Work with Data

You can use mouse to select the range of data in the spreadsheet. You can also use the keyboard (Shift + key up/down/left/right) to select the range of data.

Format as table

See Format as table for details.

Apply cell style

Cell style in the spreadsheet makes it easier for user to decorate the cell with different colorful view. You can select Edit menu and click Cell style... to process. You can also click style icon from sidebar to implement.

Select a range of cells and click one of cell style to apply your format.

Validation

See Data Validation for details.

Create an in-cell dropdown list

You can create dropdown lists in the cell by choosing Insert menu -> Dropdown list button. A popup window appears for you to create and edit dropdown list.

You can also force user select only the value from dropdown list. Or you can allow users to enter data in the cell with dropdown list. After a dropdown list is created, you can apply it to the cells to build in-cell dropdown list.

Create an in-cell Checkbox

Select a range of cells and you can create checkbox in the cell by choosing Insert menu -> Checkbox button.

Create an in-cell Radio button

Select a range of cells and you can create radio button in the selected range of cells by choosing Insert menu Radio button.

Filter and sort data

See Filter and sort data for more details.

Auto Fill data

See Auto Fill data for more details.

Find and replace

In the Edit menu, select Find and Replace... button to let you easily find the information in your sheet. You can also replace the content by select replace function.

Increase or decrease the decimal places

For numbers that are already entered on a worksheet, you can increase or decrease the number of places that are displayed after the decimal point by using the toolbar buttons.

• Select the cell or range of cells that contains the numbers for which you want to change the decimal places.
• On the toolbar, click Increase Decimal to display more digits after the decimal point. Click Decrease Decimal to display fewer digits after the decimal point.