In Microsoft Excell How do I make text typed in a cell on one sheet automatically appear in a cell on a diff?

Go to the second Cell where you want the text to appear and hit equal sign ( = ) then move your cursor to the first cell where you already have the original text click on that cell and then hit enter.

Tip: Do not click on anything else once you choose the source cell just hit enter!

Always feel free to ask any excel questions! send email

Go to the sheet with the target cell where you want the value to appear.

Click on the target cell

Hit the equal '=' key

Go to the sheet where the source cell is.

Click on the source cell.

Hit 'Enter'

in the 2nd worksheet, place your cursor where you want the text to begin.

Hit the shift and then the + key at the same time and bring your cursor to the original text in the first worksheet and hit enter. Easy as that.