View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid vezerid is offline
external usenet poster
 
Posts: 751
Default how to apply absolute cell referencing to multiple cells at once?

I tried a simple formula:

=A1+A2+A3+A4

I selected all cell refs and pressed F4. All of the refs turned to
absolute. This is as far as changing the references within *a single
formula*. If you change the refs in a single formula and then copy
this cell, the copied cell refs will inherit the refs of the original
formula.

Does this help?
Kostis Vezerides

On Oct 18, 7:12 pm, TheresaP
wrote:
Hi, I know that you press F4 to change the cell referencing to absolute,
relative or mixed. But is there a way to select a range of cells to apply the
change all at once instead of having to choose each one and pressing F4 for
each. Any help is greatly appreciated! Thanks!