# Bulk Edit

Many applications only allow for single edits, such as inserting, updating, or deleting one row at a time. However, EDITable offers the 'bulk edit' feature that enables you to edit and delete values across multiple cells simultaneously.&#x20;

With bulk editing, you can consistently update a common attribute across all entities, ensuring data integrity.&#x20;

1. To edit multiple cells, select the required cells.&#x20;

<figure><img src="https://608526116-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdpYgiTFFEktmDlcxUGTv%2Fuploads%2F2C9kQY8MtTeUbwJ0n33f%2Fimage.png?alt=media&#x26;token=01a1ced6-7a17-41c0-a17c-53096511b4ba" alt=""><figcaption><p>Select the cells</p></figcaption></figure>

To remove the selection or to select all the rows in the table, click on the selector at the header.

<figure><img src="https://608526116-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdpYgiTFFEktmDlcxUGTv%2Fuploads%2FrGIqwAbUlCi4n99KBrtO%2Fimage.png?alt=media&#x26;token=4ac6a505-7636-4151-9d73-70226df1069c" alt=""><figcaption><p>To select all cells</p></figcaption></figure>

2. After selecting the rows, click on **Bulk Editor** to open it.

<figure><img src="https://608526116-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdpYgiTFFEktmDlcxUGTv%2Fuploads%2FWeaj410ex8bXomcWWt8S%2Fimage.png?alt=media&#x26;token=154fd3a7-68dc-444d-91c9-08a3764a0d34" alt=""><figcaption><p>Click 'Bulk Editor'</p></figcaption></figure>

3. The Bulk Editor pop-up opens where you can specify the new value for the required field. Let us assume you want to edit the 'TargetBonus' value to 0.5 for the selected three rows. You can enter the value *0.5* in the *TargetBonus* field.

<figure><img src="https://608526116-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdpYgiTFFEktmDlcxUGTv%2Fuploads%2Ft1slAzq9WsJMCKIlvyvt%2Fimage.png?alt=media&#x26;token=3ceda0c4-73b2-45c8-a083-3a0302bf4832" alt=""><figcaption><p>Bulk editing a field</p></figcaption></figure>

4. You can also update other fields as required and then click **Apply.**

<figure><img src="https://608526116-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdpYgiTFFEktmDlcxUGTv%2Fuploads%2Fw8u7qMW7ZdvAITfx4hG0%2Fimage.png?alt=media&#x26;token=f936ce72-eb1e-47ca-8934-836875243439" alt=""><figcaption><p>Apply changes</p></figcaption></figure>

5. The values are updated as shown below. Click on **Save** and then **Proceed** to save the changes and sync to the source database.

<figure><img src="https://608526116-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdpYgiTFFEktmDlcxUGTv%2Fuploads%2FR3wj4Qm6JSPyjSoEWL4k%2Fimage.png?alt=media&#x26;token=6f8bb780-f862-4514-87d5-507275ad1a0e" alt=""><figcaption><p>Save changes</p></figcaption></figure>

6. The source table is now updated as shown below.

<figure><img src="https://608526116-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdpYgiTFFEktmDlcxUGTv%2Fuploads%2FJl16ZzMnc5IDJap6sMZO%2Fimage.png?alt=media&#x26;token=a55a1f83-d524-4d94-b906-b19b8b35aa58" alt=""><figcaption><p>Changes updated</p></figcaption></figure>

In this way, you can edit multiple cells/rows simultaneously using bulk editing.
