View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
karthik karthik is offline
external usenet poster
 
Posts: 48
Default referencing a cell in another worksheet

you might have pressed Ctrl+~ key. Try pressing it again.
--
Karthi


"Shannan" wrote:

Hi,
I want cell F55 in worksheet "January" to display what is typed in cell B6
of worksheet "Sheet 1". These two worksheets are in the same workbook. I've
typed "=Sheet1!B6" in cell F55, but instead of displaying "Jan. 4" which is
what is typed into cell B6 it is showing me the forumla that i typed. What am
i doing wrong/ how do i fix this?