How to Make Information Automatically Move to a New Tab in Excel

Link cells on different tabs in Excel so you don't have to change the information manually.

Microsoft Excel spreadsheets help you keep track of information, facts or finances. If you link cells within a single Excel file, whether they're on the same tab or different tabs, it allows you to change information in one cell and have it automatically move to the other. Linking different cells in Excel cuts down on the time you need to edit spreadsheets that you use often, as well as the potential for errors if you have to change the same information in multiple places.

Instructions

1. Open Excel. Click the "Open" option on the toolbar and open the workbook you want to edit.

2. Click the cell that has the information in it that you want to move to the new tab. Push the "Copy" button with the icon of the two pages on it in the toolbar at the top of the Excel window.

3. Click the tab at the bottom of the spreadsheet window to the far right of the other tabs with a plus sign icon and a blank sheet on it to create a new tab. Click the new tab to navigate to it.

4. Click the cell on the new tab where you want to move the information. Click the "Paste" button on the toolbar, which is the icon of the clipboard with a page on it. Then click the "Paste Options" button next to the "Paste" button and click the "Link" check box. Change the information in the cell on either tab and press "Enter"; it automatically changes in the other tab.

Tips & Warnings

• You can also link other files and workbooks to specific cells inside your workbook.

References

• Microsoft Office: Create a Link to Another Cell, Workbook or Program

Resources

• Microsoft Office: About Linking to Another Workbook or Program