# Working with Cells

## **Copying, Cutting and Pasting Cells**

### **Copying Cells**

To **copy** a cell, you should take the following steps:

1\) Select a cell or a range of cells you want to copy.

2\) Right-click on it and select the **Copy** option in the context menu.

![Copying, Cutting and Pasting Cells](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LEEOWDArdNNgipO8mVJ%2Fuploads%2Fnkdna0qsGzYFBO6m2Ca0%2Fcut_copy_paste.png?alt=media\&token=51d6ea01-6860-4663-b8e0-893fcbe2b562)

You can also copy the cell(s) via the **"***Ctrl+C / Command+C***"** shortcut.

### **Cutting Cells**

To **cut** a cell, you should take the following steps:

1\) Select a cell or a range of cells you want to cut.

2\) Right-click on it and select the **Cut** option in the context menu.

You can also cut a cell via the **"***Ctrl+X / Command+X***"** shortcut.

### **Pasting Cells**

To **paste** the copied/cut cell(s), you should take the following steps:

1\) Select the cell(s) you want to paste into.

2\) Right-click on it and select the **Paste** option in the context menu.

You can also paste a cell via the **"***Ctrl+V / Command+V***"** shortcut.

When you copy or move the cell(s), you also copy or move styles, applied formulas, and conditional formats with it.

### Special Paste

The widget allows you to perform a special paste. In this case, you can paste the following elements into the cell:

* **values** - paste only the values from the copied cell(s)
* **formulas** - paste only formulas, without values
* **styles** - paste only cell styles
* **conditional formats** - paste only the conditional formats.

To perform the **special paste**, you should take the following steps:

1. Copy a cell or a range of cells.
2. Select the cell you want to paste into.
3. Right-click on it and select the **Special paste** option in the context menu.
4. Select the paste option you need\*\*.\*\*

## Fill a Cell Range Automatically <a href="#page-header" id="page-header"></a>

You can use the selection handle to fill a range in a certain direction. The range is filled with values that were either copied from the initial selected cell or determined by the pattern of selected cells. To fill in the data, you should take the following steps:

1\) Select the cell that contains the formula or the values that you want to fill in the cells next to it.

2\) Hover over the bottom right corner so that the cursor changes to a plus sign (**+**),

3\) Drag the selection handle across the cells you want to fill.

4\) When you let go, the data is automatically filled in cells.

<figure><img src="https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LEEOWDArdNNgipO8mVJ%2Fuploads%2FJ3FCaJAUf5Lthzvs6nXR%2Fdrag_copying_spreadsheet.gif?alt=media&#x26;token=1b82d44d-efa9-429a-beb5-06fa7642eb1f" alt=""><figcaption><p>Fill Data Automatically</p></figcaption></figure>

### Automatic Fill for Days and Months

You can also automatically fill in days of the week and month names. Both short and full formats are supported (e.g., Mon/Monday, Jan/January). Autofill for days and months is locale-based, meaning it depends on the current locale settings.

Autofill considers the case of the input. If the day or month name is entered entirely in lowercase or uppercase, the same casing is applied to the auto-filled cells. For all other input variations (e.g. MOn, MoNDay), casing follows the default formatting rules of the locale.

<figure><img src="https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LEEOWDArdNNgipO8mVJ%2Fuploads%2Fgit-blob-233e9c1c398ad2c469c2bdbebba9f59402bb4462%2Fspreadsheet_days_months.gif?alt=media" alt=""><figcaption><p>Autofill for Days and Months</p></figcaption></figure>

## Sorting Data in a Range

You can sort data in a selected range of cells in both ascending and descending directions. There are two ways to do that:

1\) Select a range of cells that contain data to be sorted.

![Selecting Cells for Sorting](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LF7ykJdhiZBZQkZ0PHR%2F-LF1lKLCkMbVi_4ET43y%2Fselect_for_sorting.png?generation=1529159029265047\&alt=media)

2\) Make use of the corresponding button in the **Edit** section to sort data in either ascending or descending order:

* Click the **Sort A to Z** button to sort data in the descending order:

![Sort in Descending Order](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LF7ykJdhiZBZQkZ0PHR%2F-LF1lKLF6vpsaaaw-IUg%2Fsort_desc.png?generation=1529159032926737\&alt=media)

* Click the **Sort Z to A** button to sort data in the ascending order:

![Sort in Ascending Order](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LF7ykJdhiZBZQkZ0PHR%2F-LF1lKLHWBJkMMXbofKR%2Fsort_asc.png?generation=1529159032431010\&alt=media)

Or:

1\) Right-click the cell/cells with data to be sorted to call the context menu.

2\) Select *Sort*->*Sort A to Z*, or *Sort*->*Sort Z to A* option, depending on the desired sorting direction.

![Sorting via Context Menu](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LF1lIxCBo7ZjOfLbwYW%2F-LF1lKLJBNpgQAarHYrY%2Fsort_via_menu.png?generation=1529054857541913\&alt=media)

In the image below the range is sorted in the ascending order. Pay attention that the values in the **Total** column are recalculated accordingly:

![Sorted Column](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LF7ykJdhiZBZQkZ0PHR%2F-LF1lKLLSkXe3pvDYj1h%2Fsorted_range_of_cells.png?generation=1529159031829783\&alt=media)

## Adding Filters and Dropdown Lists into Cells

### Adding a Filter

You can add filters for cells of a column. While selecting an option in the added filter, the whole grid data will be filtered according to the value of this option.

![Filtering Cells](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LF7ykJdhiZBZQkZ0PHR%2F-LF1lKLNChr8LbQkb2SD%2Fcell_with_filter.png?generation=1529159030650388\&alt=media)

To filter data:

1\) Select the necessary range of cells in a column.

![Selecting Cells for Filtering](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LF7ykJdhiZBZQkZ0PHR%2F-LF1qtzS8fOn5RJOxYTz%2Fselect_for_filtering.png?generation=1529159028790612\&alt=media)

2\) Choose one of the following options:

* Click the **Create filter** button in the **Edit** section to add a filter into the top cell of the selected range.

![Create Filter Button](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LF8BGstE65DcvH5ASNw%2F-LF1lKLPGjvZI0NIkHyD%2Fcreate_filter_button.png?generation=1529162577605253\&alt=media)

* Right-click the selected range and select the *Create filter* option in the context menu.

![Create Filter Option](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LF7ykJdhiZBZQkZ0PHR%2F-LF1qtzVVe40j07LpHpm%2Fcreate_filter_option.png?generation=1529159028788090\&alt=media)

A filter with options (cells' values from the range) will appear in the top cell of the selected range.

3\) Click on any filter option to filter data in the grid.

The image below shows a table filtered by the *Europe* option from the filter.

![Filtered Table](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LF7ykJdhiZBZQkZ0PHR%2F-LF1lKLUnR70Q_2-7ihM%2Ffiltered_sheet.png?generation=1529159031848718\&alt=media)

### Adding a Dropdown List

You can add a dropdown list with arbitrary options into a cell of a sheet.

![Adding Dropdown List](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LF1lIxCBo7ZjOfLbwYW%2F-LF1lKM1et1rHZ2h_zjp%2Fadd_cell_editor.png?generation=1529054848318860\&alt=media)

It's really easy to do:

1\) Select a cell to add a dropdown menu into.

2\) Click the **Add dropdown** button in the **Edit** section.

![Add Dropdown](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LF1lIxCBo7ZjOfLbwYW%2F-LF1lKM1et1rHZ2h_zjp%2Fadd_cell_editor.png?generation=1529054848318860\&alt=media)

3\) In the appeared popup add the range of cells the values of which will be used as options of the dropdown menu. There are two ways for that:

* Type the reference to the range as a pair of the starting and ending cells as A2:A5
* Select a range of cells in a sheet and the reference will appear in the input automatically

4\) To add an empty option to your list, check the **Empty** **option** checkbox.

<figure><img src="https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LEEOWDArdNNgipO8mVJ%2Fuploads%2FxXSGdIRVwUxo0PtFn2fv%2Fadd_dropdown_spreadsheet.png?alt=media&#x26;token=586a6b61-0072-4876-b60c-b14400c6fe00" alt=""><figcaption><p>Add Dropdown Popup</p></figcaption></figure>

5\) Click the **Save** button to add a dropdown list into a cell.

### Removing Filters and Dropdown Lists

To remove a filter/filters:

1\) Select cells with filters/dropdown lists.

2\) Click the **Clear** button in the **Edit** section of the toolbar.

3\) Select the *Clear dropdowns and filters* option in the dropdown list.

![Clear Filters via Toolbar](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LF7ykJdhiZBZQkZ0PHR%2F-LF7ym-H3T_cYJX0ZTRV%2Fclear_dropdowns_filters_button.png?generation=1529159035667254\&alt=media)

Or:

1\) Select cells with filters/dropdown lists.

2\) Right-click the selected cell/cells to call the context menu.

3\) Select *Clear*->*Dropdowns and filters*.

![Clear Filters via Context Menu](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LF7ykJdhiZBZQkZ0PHR%2F-LF7ym-K-txUR2ApZQs2%2Fclear_dropdowns_filters_option.png?generation=1529159035680961\&alt=media)

## Locking a Cell

You can lock a cell to forbid editing its content. Locked cells will be marked with small orange locks in the bottom right corner. You can neither set the mouse cursor inside of them, nor change their values.

To lock/unlock cells, you can use one of the two available ways:

* Select a cell or several cells you want to lock and click the **Lock/unlock cell** button in the **Edit** section.

![Locking Cells via Toolbar](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LF7ykJdhiZBZQkZ0PHR%2F-LF1lKLn3-yAJWEYNu5l%2Flock_cell_button.png?generation=1529159031817507\&alt=media)

* Right-click a selected cell or a range of cells and choose the **Lock/unlock cell** option in the context menu.

![Locking Cells via Context Menu](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LF1lIxCBo7ZjOfLbwYW%2F-LF1lKLp4xkuqrFttwCw%2Flock_cells_option.png?generation=1529054854280459\&alt=media)

## Adding Link into a Cell

It is possible to add a link to an external resource or a specific cell.

![Adding Link to a Cell](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LF7ykJdhiZBZQkZ0PHR%2F-LF1lKLrwZkYQIgUO20d%2Fcell_with_link.png?generation=1529159032468751\&alt=media)

To insert a link into a cell:

1\) Select a cell to add a link into.

2\) Choose one of the following options:

* Click the **Add link** button in the **Edit** section:

![Adding Link via Toolbar](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LF7ykJdhiZBZQkZ0PHR%2F-LF1lKLtAkuWqeQrksRE%2Fadd_link_button.png?generation=1529159030659700\&alt=media)

* Right-click a cell and select the **Add link** option in the context menu.

![Adding Link via Context Menu](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LF1lIxCBo7ZjOfLbwYW%2F-LF1lKLva6eDyr6Zybwr%2Fadd_link_option.png?generation=1529054854998764\&alt=media)

3\) In the appeared popup enter the text of the link in the first line and insert the link into the second line:

![Add Link Popup](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LF7ykJdhiZBZQkZ0PHR%2F-LF1lKLxkr7MIskAQvZQ%2Fadd_link_popup.png?generation=1529159033528473\&alt=media)

If you want to add the link to a specific cell, use "#" before the cell reference:

<figure><img src="https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LEEOWDArdNNgipO8mVJ%2Fuploads%2FUdygEJBAGOYV9mWYofEg%2Flink_via_hashtag.png?alt=media&#x26;token=6d2e1f70-972a-47e6-8939-21d4970f7a72" alt=""><figcaption><p>Link to a Specific Cell</p></figcaption></figure>

4\) Click the **Save** button to apply changes.

## Adding Image in a Cell

You can add an image into a cell to illustrate data in the spreadsheet.

To insert an image into a cell:

1\) Select a cell to add an image into.

2\) Click the **Image** button in the **Insert** section:

![Adding Image](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LP0G2SNTiumYd6_We6e%2F-LP0G34IjAHquzVet68W%2Fimage_button.png?generation=1539767029780804\&alt=media)

3\) In the appeared popup insert a link to the image or select a file from the computer:

![Add Image Popup](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LP0G2SNTiumYd6_We6e%2F-LP0G34KsWAqVVNE0cOY%2Fadd_image_popup.png?generation=1539767028252242\&alt=media)

4\) Click the **Save** button to apply changes.

## Adding Sparkline in a Cell

You can add a graph (sparkline) into a cell to display tendencies of data values changing in a range of cells.

To insert a graph into a cell:

1\) Select a cell to add a graph into.

2\) Click the **Graph** button in the **Insert** section:

![Adding Sparkline](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LP0G2SNTiumYd6_We6e%2F-LP0G34MPsq0YY9Rnda5%2Fgraph_button.png?generation=1539767028276733\&alt=media)

3\) In the appeared popup enter sparkline configuration:

* choose the type of the line
* set the cell range
* select the color of the graph (except for the Pie type) or two colors (for positive and negative values) for the Bar type

![Add Sparkline Popup](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LP0G2SNTiumYd6_We6e%2F-LP0G34OtdbGn_kQ5xHH%2Fadd_graph_popup.png?generation=1539767036948844\&alt=media)

4\) Click the **Save** button to apply changes.

## Adding Comments in a Cell

You can add comments for a cell. To insert comments into a cell:

1\) Select a cell to add comments into.

2\) Choose one of the following options:

* Click the **Comment** button in the **Insert** section:

![Adding Comments](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LP0G2SNTiumYd6_We6e%2F-LP0G34QcWkyRykeFF9Y%2Fcomments_button.png?generation=1539767028649183\&alt=media)

* Right-click a cell and select the **Comment** option in the context menu.

![Adding Comment via Context Menu](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LP0G2SNTiumYd6_We6e%2F-LP0G34SnUAoFc5qBTb9%2Fadd_comment_option.png?generation=1539767036947083\&alt=media)

3\) In the appeared popup enter a text of the comment:

![Add Comments Popup](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LP0G2SNTiumYd6_We6e%2F-LP0G34Uc8mXpyC0-54A%2Fadd_comment_text.png?generation=1539767028311572\&alt=media)

4\) Click any cell outside the textarea to save the comment.

You can change the size of the comment popup by dragging the resizer handle in the right bottom corner.

![Resize Comment Popup](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LP0G2SNTiumYd6_We6e%2F-LP0G34W1rdRstZHJXOB%2Fcomment_resizer.png?generation=1539767028758061\&alt=media)

## Adding Checkboxes and Radio Buttons into a Cell

You can add checkboxes and radio buttons into cells.

<figure><img src="https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LEEOWDArdNNgipO8mVJ%2Fuploads%2FMYUgZH6yXav7TpEql95V%2Fcheckbox_radio.png?alt=media&#x26;token=463bbdb7-4233-484f-adf4-a248922460e1" alt=""><figcaption><p>Adding Checkboxes and Radio Buttons</p></figcaption></figure>

To insert a checkbox or a radio button into a cell:

1\) Select a cell to add a checkbox or a radio button into.

2\) Choose one of the following options:

* Click the **Controls** button in the **Insert** section of the toolbar and select **Add checkbox** or **Add radio group**:

<figure><img src="https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LEEOWDArdNNgipO8mVJ%2Fuploads%2FGbyLJJQvJqSDW5VRoVsv%2Fcontrols_button.png?alt=media&#x26;token=4939c915-3376-4dd5-b917-f570254f6a46" alt=""><figcaption><p>Adding Checkboxes and Radio Buttons via Toolbar</p></figcaption></figure>

* Click the **Insert** option in the menu and select **Controls->Add checkbox** or **Add radio group:**

<figure><img src="https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LEEOWDArdNNgipO8mVJ%2Fuploads%2FuJ1p1mhVVWLIAAceAZRf%2Fmenu_controls_1.png?alt=media&#x26;token=4fdb8b88-48cd-46b1-87ca-26f670179989" alt=""><figcaption><p>Adding Checkboxes and Radio Buttons via Menu</p></figcaption></figure>

## Validating Cells Content

You can add a validation rule for the content of a cell. A validation rule can be added to a cell via the **Validation** button on the Toolbar:

<figure><img src="https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LEEOWDArdNNgipO8mVJ%2Fuploads%2Fa52YflV4emajkwInmNiR%2Fadding_validation_toolbar.png?alt=media&#x26;token=54ccfc4d-7a09-46fe-a046-d90a9133c359" alt=""><figcaption><p>Validation Button Options</p></figcaption></figure>

or via the Menu or Context Menu options. A click on the "Add data validation" option will open a dialog popup:

<figure><img src="https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LEEOWDArdNNgipO8mVJ%2Fuploads%2FeWmzfg9oRkqRl5Kgn1aL%2Fvalidation_rules_dialog.png?alt=media&#x26;token=f659c24a-9c07-4c21-b326-cb2e7777d832" alt=""><figcaption><p>Validation Rules Dialog</p></figcaption></figure>

This popup contains a set of validation rule types and their attrubutes. After you add a validation rule to a cell, a click on it will call a textarea with the rule details:

<figure><img src="https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LEEOWDArdNNgipO8mVJ%2Fuploads%2FbqpF2sMN6y7pTeAnjiGz%2Fvalidation_cell_popup.png?alt=media&#x26;token=db1e519c-8e38-46e0-bf1a-72c8d3ef4f1c" alt=""><figcaption><p>Validation Cell Popup</p></figcaption></figure>

A validation rule can have one of the following types:

* "any" (a cell can have any content)
* "date"
* "number"
* "text"
* "textLength"
* "range" (to validate data among a range of cells)

Depending on the **type** of the rule, it can have the following attributes:

* **Integers only** - (for the *number* type) for accepting only integer numbers
* **Ignore empty** - to ignore/ not ignore empty cells
* **Condition** - the condition that will be applied. Depending on the rule type, may include the following values:
  * greater
  * less
  * greater or equal
  * less or equal
  * equal
  * not equal
  * between
  * not between
  * contains
  * not contains
  * begins with
  * not begins with
  * ends with
  * not ends with
* **Value** - a value or an array of two values (for the rules like "between/not between") that should be compared to the value of the specified cell
* **Input message** - a popup with the text specified in this property will be shown on selection of a cell
* **Error handle** - the way of handling an error (in the corresponding confirm box):
  * "stop" - doesn't allow setting an incorrect value
  * "warning" - allows cancelling the set value
  * "information" - an box informing that the value is not valid
* **Error title** - the header of the confirm box with an error
* **Error message** - the text of the confirm box with an error

## Searching for and replacing data in cells

You can search for and replace data in cells. To provide the necessary parameters for searching and replacing data, click the **Find and Replace** button on the Toolbar and fill in the corresponding fields in the dialog popup:

<figure><img src="https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LEEOWDArdNNgipO8mVJ%2Fuploads%2FlUzVXFw8vsIrNQyMLfTW%2Ffind_replace_feature.png?alt=media&#x26;token=5948ecc8-5146-469a-a4ff-ec775b166ff6" alt=""><figcaption><p>Find and Replace Dialog</p></figcaption></figure>

The results of search are rendered in the lower part of the dialog window.

You can adjust the following searching criteria:

* search for data within a sheet or the whole book
* search among values or formulas
* search for results that match the case and/or match the entire cell contents

To replace data in a cell:

* select the necessary cell
* click the **Find and Replace** button and fill in the **Replace with** field
* click the **Replace** button

To replace data in all cells:

* click the **Find and Replace** button and fill in the **Replace with** field
* click the **Replace** **all** button