Online sheet  ->  Work with Data

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 styl icon from side bar 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 choose Insert menu -> Dropdown list button. A popup window appears for your to create and edit dropdown list.

You can also force user only select the value from drop down list. Or you can allow user 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 choose 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 choose Insert menu Radio button.


Filter and sort data


See Filter and sort data for more detail.


Auto Fill data


See Auto Fill data for more detail.


Find and replace


In the Edit menu, select Find and Replace... button to let your easy 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.