how to break links in excel and keep values

how to break links in excel with Shortcuts on the same sheet

In the following example, we assume we have a table like the one below.

We want the value of cell E11 to be copied without the formula being copied and only the value being displayed.

how to break links in excel With Shortcuts on the same sheet.

Method 1:

1. Select E11 cell

2. Press (CTRL+C) simultaneously

3. Select the cell where you want the desired value copied. (ex: E13)

4. Press (ALT+CTRL+V) simultaneously

5. Then press the V button.

6. Click Ok.

how to break links in excel With Shortcuts on the same sheet excel

how to break external links in excel with Shortcuts in external sheet

Method 2:

We want the value of cell E11 (in Student Sheet) to be copied in Cell E11 (in Student-copy Sheet) without the formula being copied and only the value being displayed.

Method 2:how to break external links in excel With Shortcuts in the external sheet.

1. Select the data tab.

2. Select Edit Links.

3. Select Break Link.

how to break external links in excel With Shortcuts

4. Again Select Break Link.

5. Finally Select Close.

how to break external links in excel With Shortcuts

Leave a Reply

Your email address will not be published. Required fields are marked *