Enter same text in mulitple worksheets at the same time

  • Thread starter Newbee via OfficeKB.com
  • Start date
N

Newbee via OfficeKB.com

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?
 
P

Peo Sjoblom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top