referances in difernt sheets same work book

B

bradwestleyPB

hiw do i use refferance a cell in a differnt shet for formular i rember my
teachure teling me in collage but cant find it any book i know it has some
thing to do with absolute cell reffeerances and the $ key
 
J

Jim Cone

Maybe the word you are trying to look up is not spelled correctly.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"bradwestleyPB"
<[email protected]>
wrote in message
hiw do i use refferance a cell in a differnt shet for formular i rember my
teachure teling me in collage but cant find it any book i know it has some
thing to do with absolute cell reffeerances and the $ key
 
G

Gord Dibben

In any cell of sheet1 enter =sheet2!A1

You don't need absolute references but if you did want them, highlight the A1 in
the formula bar and cycle through by hitting the F4 key.


Gord Dibben MS Excel MVP
 
Top