answersLogoWhite

0

If you have a value in cell A1 on Sheet1 and you want it to appear in Sheet 2, you use a formula. So in a cell on Sheet2 type:

=Sheet1!A1

Sheet1 is the sheet name. The exclamation mark separates it from the cell reference. Now whatever is in the cell A1 on Sheet1 will appear in the cell with that formula.

User Avatar

Wiki User

14y ago

What else can I help you with?

Related Questions

How do you enter a new worksheet in excel?

by clicking on sheet 2 in bar at the bottom


What is the difference between the way Access saves a record and the way Excel saves a row in a work sheet?

the difference between the way Access saves a record and the way Excel saves a row in a worksheet. Answer


What is an excel function used to enter the system date in a cell in a worksheet?

The NOW function


What is worksheet in ms excel?

It is another name for spreadsheet. It is a single tab.


How do you get to A-1 in an excel worksheet?

Press Ctrl-G (Go To) and enter A1 in the reference, then click OK.


As a database in excel each row of a worksheet can store a record and each column can store a what?

A field.


Can I record my daily revenue on an excel worksheet?

Yes, you can use a computerized counting money worksheet to help record your daily and monthly income. One tool is using a spreadsheet software to document and calculate your money.


What allows data easy to summarize and charted in excel?

An Excel worksheet or spreadsheet allows data to be easily summed and charted.


How do you link tabs on an excel worksheet?

I am not sure what you are asking, since you link cells, and not tabs. But, if you want to know how to link to a cell on another worksheet, add the name of the worksheet with an apostrophe (!) before the cell name. If you want to reference cell B13 from Sheet1 on Sheet2, enter the following formula on Sheet2: =Sheet1!B13.


Is the statement true or false Excel automatically creates an empty row in a table so that you are ready to enter the first record in the table?

I do not understand what you are asking. When you create a new worksheet, all of the rows are empty.


Most Excel specialists who build Web queries use the worksheet returned from the Web query as an engine to supply data to another in the workbook?

Worksheet


What is the new of a new worksheet in Excel?

Create a blank worksheet.