Auto type of text in other cells.

[Digihelix]

I'm new to Excel, and I am making a little project for myself to get familiarized with the program. How would someone create a formula, that will typing in one cell, appear in multiple cells.

So, If I typed the word "Hello" in cell A! it would also appear in B1, B2, B3, or/and C4, at the same time or after I hit enter.

I have tried to search for the answer, but I don't know what to call this function. Any help would be greatly appreciated.

LmB

[carsto]

just put =A1 in every cell you want the contents of A1 to appear in.

Here is a link to an overall excel tutorial you may find helpful:
http://www.excel-vba.com/excel-1-introduction-tips.htm

[starguy]

I'm new to Excel, and I am making a little project for myself to get familiarized with the program. How would someone create a formula, that will typing in one cell, appear in multiple cells.

So, If I typed the word "Hello" in cell A! it would also appear in B1, B2, B3, or/and C4, at the same time or after I hit enter.

I have tried to search for the answer, but I don't know what to call this function. Any help would be greatly appreciated.

LmB

put in all cells where you want to return data from cell A1
=A1
or with absolute reference like this
=$A$1