Training >> Browse Articles >> Applications


10 Excel Secrets Every Admin Should Know

AdminSecret and Richard Rinyai

5. Link Different Excel Pages

Have you ever wondered how you can link information between files in Microsoft Excel? For example, you want to show last year’s sales figures on this year’s sales figures spreadsheet, but your boss wants you to have two separate files for each.

Here are the 4 simple steps on how to do this:

1. Open or create the new spreadsheet with the destination cell (such as this year’s sales figures).

2. Click on the particular cell that you want the information to go to, then type “+” without the quotes, on either the new spreadsheet or on the particular sheet that you want to copy the information to (sheets are tabs at the bottom of your Excel spreadsheet).

3. Click on the cell that has the source information (such as last year’s sales figure) and hit enter.

4. Make sure to save the new or opened file. Now when you open it, make sure to click “Update” as this will update any changes to the original file (where you had your last year’s sales figures).

You can do this for as many cells and as many files as you like. Just make sure not to delete the originating file, since the link will be broken at that point, since Microsoft Excel can’t read the source data.

AdminSecret School Finder

Save time in your search for a degree program. Use AdminSecret's School Finder to locate schools online and in your area.

* In the event that we cannot find a program from one of our partner schools that matches your specific area of interest, we may show schools with similar or unrelated programs.

Recent Activity

romanico received the quiz result of "21-50% correct: Good effort", about 2 years ago.
tmiller received the quiz result of "Satisfactory", about 2 years ago.
new2admin gave a thumbs down to The Article "6 Ways Finding a Dream Job Is Like Finding Your Soul Mate", about 2 years ago.
kinsh1987 received the quiz result of "Legal Secretary ", about 2 years ago.
LoraJ commented on: "Lora Coats", about 2 years ago.