HOW DUPLICATE TEXT ON ALL PAGES OF WORKSHEET FROM ONE CELL

S

Samantha Stevenson

I would like to enter text [title, client etc] on the cover page of my
document, and have the information copy to corresponding cells on all the
attached worksheets. Which function will allow me to do that?
 
A

Anne Troy

Well, you can enter it into, for instance, cell A1 of sheet1 and then in
other sheets, type =Sheet1!A1, or you can put it in sheet1, select it, and
Insert-->Name-->Define and call it CoName. Then in other sheets, put
=CoName. Or you can just hold the shift key and select all the sheets you
want it on, click on the cell and type it in, then remember to ungroup the
sheets... many options for you, Sam.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com
 
S

Samantha Stevenson

Anne, Thank you so much! You are a lifesaver.
All the best,
Samantha

Anne Troy said:
Well, you can enter it into, for instance, cell A1 of sheet1 and then in
other sheets, type =Sheet1!A1, or you can put it in sheet1, select it, and
Insert-->Name-->Define and call it CoName. Then in other sheets, put
=CoName. Or you can just hold the shift key and select all the sheets you
want it on, click on the cell and type it in, then remember to ungroup the
sheets... many options for you, Sam.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


Samantha Stevenson said:
I would like to enter text [title, client etc] on the cover page of my
document, and have the information copy to corresponding cells on all the
attached worksheets. Which function will allow me to do that?
Click to expand...
Click to expand...
 
Top