View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ManhattanRebel ManhattanRebel is offline
external usenet poster
 
Posts: 85
Default help with formula

when entering a formula, how can i designate a range for it to automatically
apply to?

I know I can enter a range in the "name" field to the left of the formula
bar (and use CTRL - Enter), but i want to know how to place the range in the
formula itself. For example, when entering this formula =a1+3, where exactly
do I insert the range?