Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Enter same text in mulitple worksheets at the same time
I have a workbook that has 109 worksheets in it, now I need to have the same
layout on each page is there a way to type it on wrksht 1 so that it will automactally enter the same text through out the rest of the wrkshts? Or is the old fashion way the only way out of this? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200701/1 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Enter same text in mulitple worksheets at the same time
Select the first sheet (click sheet tab), hold down shift and click the
last sheet tab to group the sheets, now enter the text, when done right click any sheet tab and select ungroup sheets Regards, Peo Sjoblom Newbee via OfficeKB.com wrote: I have a workbook that has 109 worksheets in it, now I need to have the same layout on each page is there a way to type it on wrksht 1 so that it will automactally enter the same text through out the rest of the wrkshts? Or is the old fashion way the only way out of this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't enter break mode at this time | Excel Discussion (Misc queries) | |||
Multiple text sheets into a master worksheet as you enter data | Excel Worksheet Functions | |||
enter text in cell and have value change in all worksheets; with l | Excel Discussion (Misc queries) | |||
Text to time convert | Excel Discussion (Misc queries) | |||
shading a rowwhen a time is entered but no shading when 0 is enter | Excel Worksheet Functions |