Excel: delete shortcut - how it works

You can quickly and easily delete links between several cells in Excel. In our instructions, we show in detail how to do this.

Delete links in Excel

Excel often notifies you when you open a table that links are missing. How to delete them:

• Linked formulas: If a formula is specified in the cell that is marked on several cells, you can simply delete the content including links with [Del].
• Linked workbook: If the data relates to a workbook, you can delete it via "Data"> "Edit links"> "Source" by clicking on the link.
• Linked name: After you have removed a link, the name often remains. With "Formulas"> "Name Manager" you can click on the name and delete it.
• Tip: All links with missing data records are marked with "#BEZUG!" characterized.

On the next page we show how you can automatically round off in Excel.