updating multiple cells in Excel at the same time - question?

[QueBert]

So I Googled this and see CRTL+ENTER thing. Here's what I want to do, I have one with 2 sheets, and I'd like to link everything in a column in the 1st to a column on the 2nd sheet. So, if I edit B1 in sheet1 B1 in sheet2 gets updated. These are text only there's no formula in there. I'm assuming this is do-able with a formula, but I'm clueless and my Googling isn't turning up anything.

 

[IronWing]

Sheet1 cell B1 contains "stuff"

Formula for Sheet2 cell B1 is =Sheet1!B1

Sheet2 cell B1 will show whatever is in Sheet1 B1. To create the formula in Excel you can either type it in the cell or type an equals sign <=> in the destination cell (Sheet2 B1 in this case) and then click on cell B1 in Sheet1 and hit <enter>.