Spreadsheet basics

Thinkfree Office Cell Online enables you to perform various calculations and arrange data using a web browser. Regardless of PC environment, you can view and edit data using a web browser whenever and wherever you are. The user-friendly UI and convenient editing features enhance your productivity and performance.

 

Undo

You can revert back from completed actions in while editing your document by canceling the previous command, deleting typed content, or retrieving deleted content.

  1. Type text or edit text.
  2. Perform one of the following.
    • Click the Undo icon_undo.png icon on the toolbar.
    • Click Edit-Undo.

Wrap text and undo

  1. Type lengthy text in a cell.
    Cell_unwrapped_text.png
  2. Click the Text Wrapping icon_wrap_text.png icon on the toolbar to display text in multiple lines.
    Cell_wrapped_text.png
  3. Click the Text Wrapping icon_wrap_text.pngicon or the Undo icon_undo.png  icon on the toolbar to cancel text wrapping.

 

Redo

You can redo commands or actions canceled by clicking Undo.

  1. Type text or edit text.
  2. Perform one of the following.
    • Click the Undo icon_undo.png icon on the toolbar.
    • Click Edit-Undo.
  3. Perform one of the following.
    • Click the Redo icon_redo.png icon on the toolbar.
    • Click Edit-Redo.

Note

When you undo one or more actions and then edit other contents of the document, the Redo feature is disabled so that you cannot redo the action which has been previously canceled.

 

Copy

You can copy the selected content to the clipboard and insert it to the desired location. If you click Copy, in contrast to the Cut feature, the selected content remains and is saved in the clipboard.

 

This feature is useful when you need to use the same content, such as text, table, picture, text box, in several locations.

Perform the following to copy data.
  1. Select a range of cells to copy.
  2. Press Ctrl+C.

 

Paste

You can paste the cut or copied content stored in the clipboard to the desired location.

Perform the following to paste copied or cut data into another cell.
  1. Copy or cut data from the sheet.
  2. Click a cell where you want to paste copied or cut data.
  3. Press Ctrl+V.

Cut

You can cut the selected content, move it to the clipboard, and then insert it into the desired location.

 

This feature is useful when you want to move content, such as text, table, and picture, to another location.

Perform the following to cut data.
  1. Select a range of cells to cut.
  2. Press Ctrl+X.

 

Select All

You can select the entire sheet at once. This function is useful for changing fonts or data formats in the entire document.

Perform the following to select the entire sheet.
  1. Click Edit-Select All to select the entire sheet.
  2. Click the Expand icon_expand.png icon in Font Name on the toolbar and select the font type from the font list.

Cell_font_selection.png

 

Find and Replace

This feature is used for searching for a specific word (or a string of text) and replace it with another one in the active document. You can quickly jump to a particular cell.

 

Find Particular Word

Perform the following to find particular word or data.
  1. Click Edit and then Find/Replace.
  2. Type text in the Find what field on the Find/Replace dialog box and then click the Find button.

 find.png

 

Replace Words

Perform the following to replace a particular word with another word.
  1. Click Edit and then Find/Replace.
  2. Type text in the Find what field on the Find/Replace dialog box.
  3. Type text in the Replace with and then click the Replace button.
    The Replace All button allows to change all the instances at once.

The following search options are available.

Match Case: searches for exactly matching English letters and also matching the case. For example, searching for "computer" will not find "Computer" or "COMPUTER."
Match entire cell contents: searches for a text string that matches the data entered in its entirety.
All Sheets: searches for the entire workbook for the data.
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.