View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Want a percentages of a single cell divided by a column of cells

You need to make the cell reference for the second cell absolute - you
use the dollar symbol $ for this, for example:

=A2/A$1

When you copy this down it will become:

=A3/A$1
=A4/A$1

etc.

Hope this helps.

Pete

dbog wrote:

Want the symbol to make the formula repeat in each new cell, but keep the
second cell the same. Thought it was a karat, but that doesn't work.