How do I get one cell to type the same thing as another cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

For Eample: I want to type a name into cell B13 and I want to same thing to
automatically appear in cell E15.

Does anyone know how to do this???

I have tried E15 = B13, but that doesn't get me anywhere. all it does is put
=B13 in the E15 cell. I can't get it to disappear and put the name in there.
 
E15 is formatted as text. You'll have to format it as General or something
similar, then re-enter your formula
 
Astrowalker,

In cell E15 put:
=B13

Now, whatever you put in B13 will be copied to E15.

Henry
 
Go to cell E15 and enter
=B15
into it.

HTH. Best wishes Harald

Astrowalker said:
For Eample: I want to type a name into cell B13 and I want to same thing to
automatically appear in cell E15.

Does anyone know how to do this???

I have tried E15 = B13, but that doesn't get me anywhere. all it does is put
=B13 in the E15 cell. I can't get it to disappear and put the name in
Click to expand...
there.
 
this might work. Press CTRL & the "~" key. It look like you are in a
edit mode that shows the formulas and not the formula results. th
CTRL ~ combo toggles this functionalitry on and off
 
Back
Top