Share your knowledge
  • Create video guide
  • Import video guide
  • Embed video guide
  • Create text guide
Start Page / Office applications / Microsoft Excel / Excel 2007 / Link cells with a formula
ComAround published this guide
01 January 2008
Microsoft® Translator
43445 80 % 2

If you work with several worksheets in your workbook, you can access data from the various worksheets by linking cells. This saves time, because you don't need to enter the values manually.

Here's how

1. Select the cell you shall retrieve data to.

2. Enter: =<Worksheetname>!<Cellname> (Worksheetname is the name of the worksheet you will retrieve data from and cellname is the name of the cell you shall retrieve data from).

Example: =Sheet3!D4

3. Press Enter


Share this guide
Helpful guide?
No Yes

Add comment

Comments

REPORT ABUSE
Missy
08/02/2011 11:52:05
you can also link more than one worksheet when u need data coming from different worksheets.

how to?
type = then click on the cell on every worksheet that you need
example: =+IFERROR(VLOOKUP(A3,Sheet2!$M:$N,2,FALSE),"NA")

tip: you can also link up files

REPORT ABUSE
malekachol
29/01/2011 08:01:40
Mai! What a beautiful lesson!


Add comment

Missing a guide in ComAround Free?

Please specify your request here:
?
Request guide

Most helpful in Excel 2007

Excel 2007
By waqas
11855 60 25
Excel 2007
By ComAround
11290 31 10
Excel 2007
By Praveen Verma Potturi
5031 20 8
Excel 2007
By ComAround
5537 14 3
Excel 2007
By Praveen Verma Potturi
3630 10 4


Most viewed in Excel 2007

Excel 2007
By ComAround
43445 4 2
Excel 2007
By waqas
11855 60 25
Excel 2007
By ComAround
11290 31 10
Excel 2007
By ComAround
5537 14 3
Excel 2007
By Praveen Verma Potturi
5031 20 8