View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default f4 to make constant

Click on the cell containing the formula, then, in the *formula bar*,
select the cell that you wish to make absolute, then hit <F4.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"xololady" wrote in message
...
I am trying to do a spreadsheet and keep one cell as a constant number for
my
formula. Where do I put my cursor to hit f4?

Karen