Sync Excel Spreadsheets Using the Paste Link Feature

Configurare noua (How To)

Situatie

The Paste Link functionality in Excel provides a simple way to sync Excel spreadsheets. In this example, we want to create a summary sheet of sales totals from multiple different worksheets.

Solutie

Pasi de urmat

Start by opening your Excel spreadsheet, clicking on the cell that you want to link to, and then selecting the “Copy” button on the “Home” tab.

Select the cell that you are linking from, click the “Paste” list arrow,then select “Paste Link.”

The address that the cell it is synced to is shown in the Formula Bar. It contains the sheet name followed by the cell address.

Tip solutie

Permanent

Voteaza

(10 din 17 persoane apreciaza acest articol)

Despre Autor

Leave A Comment?