formating a range of cell to have the = function

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

How do I "program" a range of cells to all have the =
sign in them so I don't have to type it in every time? I
will be adding 4 different numbers together in each of
about 540 cells and want the total to be displayed in
each selected cell when I press enter.
 
Hi!

If you select a range of cells then type = then hit ctrl+shift+enter
each of the selected cells will have an = sign in it. Is this what you
want?

Doesn't seem to work with non-contiguous ranges.

Alf
 
You don't need to array enter that, select a range (contiguous or not)
type =, press ctrl + enter, that will place an equal sign in all of the
cells.
I doubt the OP wanted that though.. However I don't understand what
the OP wants?
 
This dosen't work because even though all the cells have
the = sign in them when I add the numbers and hit enter
it dosen't total them up, it just skips to the next cell,
with each number standing with a plus sign in between
them in the cell I wanted added up in.
 
Hi

Somethin like this
=IF(OR(A2="",B2="",C2="",D2=""),"",SUM(A2:D2)
and copy down for 540 or 5400 or whatever cells.
 
Back
Top