View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Zilla[_2_] Zilla[_2_] is offline
external usenet poster
 
Posts: 51
Default Formula editor???

Is there a formula "editor" in Excel, except for the
little window in the toolbar? For example, I may have
a long formula for one row that repeats $C$10. Now
I want to copy this formula for another row, but want
to change $C$10 to $C$15 for example. I just can't
leave it C10 since I copy the value for multiple columns
for the same row - I want it $C$10 for all columns of
that row. I can always use a text editor, but that'll
be silly.

--
- Zilla
(Remove XSPAM)