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.
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 external links in excel with Shortcuts in external sheet
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.
1. Select the data tab.
2. Select Edit Links.
3. Select Break Link.
4. Again Select Break Link.
5. Finally Select Close.