answersLogoWhite

0

In the furmula bar function box or the destination cell type = followed by the sheet name you are calling the information from then ! then the source cell containing the information. Click the formuls bar tick box. The destination cell will automatically update when the source cell is modified. Example in cell H9 on a sheet called Leadership I have typed =Results!C25 thus every time the source cell (C25 on the Results sheet) is modified, the destination cell (Leadership H9) is updated. The quick way is to type = in the destination cell, change sheets and left click on your source cell. Go back to your destination sheet and click on the formula bar tick box (above the upper left of the spreadsheet, to the left of fx).

User Avatar

Wiki User

16y ago

What else can I help you with?

Related Questions

Who created Microsoft Excel?

Microsoft Excel was created by Microsoft Corporation. It was first released in 1985.


Is displayed in the title bar of the Excel screen when starting Excel?

As Excel starts you will see the words Microsoft Excel in the title bar. After a few seconds the first worksheet will appear and then in the title bar a hyphen and Book1 will also appear beside Microsoft Excel. So what you will see is this: Microsoft Excel - Book1


What happened when Excel spreadsheet was established?

Spreadsheets existed before Microsoft Excel. Visicalc was the first one, launched in 1979. The first version of Excel came out in 1985. All that really happened then was that Microsoft now had a spreadsheet application. Microsoft Excel is now the most popularly used of the many spreadsheet applications.


What is a correct way to gain access to Microsoft Excel?

You have to buy it. Go to the Microsoft website and download it from there.


What is a Microsoft Excel window?

If you want to buy Microsoft Excel, you must first buy an Office 2019 product. Then after installing Office 2019 you will Microsoft Excel You can buy Office 2019 from: Microprokey .com Don't Mis 30% Off Coupon Code: MO30KEY


How do you colour a certain block of cell in Microsoft Excel?

First, select the cells. Then press Ctrl - 1 to open the Format Cell dialog box. On the Fill tab or Patterns tab, depending on the version of Excel you have, you can choose to colour the cells.


Where was Microsoft Excel created?

Microsoft released the first version of Excel for the Mac in 1985, and the first Windows version (numbered 2.05 to line up with the Mac and bundled with a run-time Windows environment) in November 1987.


Which was first Lotus 1 2 3 or Excel?

Lotus 123 came before Microsoft Excel by about 2 years.


What was the first name given to Excel program?

It has always been called Excel. Microsoft had an earlier spreadsheet program called Multiplan, but this was not an earlier version of Excel.


Where can I learn how to use Microsoft Excel?

If you want to buy Microsoft Excel, you must first buy an Office 2019 product. Then after installing Office 2019 you will get Microsoft Excel You can buy Office 2019 from: Microsoftprokey


Who is the founder of Microsoft Excel?

The first computerised spreadsheet was launched by Dan Bricklin and Bob Frankston in 1979. It was called Visicalc. Microsoft were just one of several companies to bring out their own spreadsheet programs after that. Excel was first launched in 1985, but Microsoft had other ones before that, like Multiplan.


How does one get started with VBA in Microsoft Excel?

First a person will need the right software to get started with VBA in microsoft excel. Then a person needs to know the different types of languages of VBA just to start out.