MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Format to duplicate text in multiple cells?


Posted by Jeff on January 04, 2002 12:15 PM

Novice here. I can format cells so that a number appears in multiple cells on multiple pages within my workbook. How can I format text to do the same thing, so I don't have to keep copying and pasting? (please answer like you're talking to a dummy)


Posted by Scott on January 04, 2002 1:09 PM

Hi Jeff. I'm not sure what you are looking for, but I'll take a stab at it. If you hold the shift key down and select the end tab (sheet) they will all highlight. What ever you type in Sheet 1 will also type in every sheet highlighted. If you only want select sheets, you can hold the Ctrl Key and click on only the ones you want. Once highlighted, you can release the Cntrl Key and type. To un-highlight, simply click on another sheet.

Posted by Jeff on January 04, 2002 2:07 PM

Scott,
Thank you very much for the info. I'm sure I didn't explain myself well. Although what you told me did help, I never realized I could do that. I have created a monthly workbook with several different types of report sheets inside it. What I was hoping to do, was to format certain (but different) cells on these sheets. So that if I typed "December" in a cell on one sheet, then it would automatically show up in different cells on different sheets of this monthly workbook. Is this even possible?
Thanks again, Jeff

Posted by Scott on January 04, 2002 2:47 PM

I think what you need to do is create a linked cell to the first worksheet. You can do this by typing in =Sheet1!A1 (Change sheet and cell as they apply to you) in all of the sheets, or you can copy the cell (where you wanted to type the info) and then go to each page and select Edit-Paste Special and then select "Paste Link".

Let me know if this helps.

Posted by Jeff on January 05, 2002 4:55 AM

I guess I'm still doing something wrong. The first sheet tab in my workbook is named "Weekly No. 1" and the second one is "Weekly No. 2" (later on there are other reports besides weeklies)

But on Weekly No.2, I clicked on cell F9 and typed in "=Weekly No.1!F9" but then when I type something in on weekly no.1 in the F9 cell, it doesn't do anything to the F9 cell on weekly no.2

I'm probably doing something pretty stupid here. I really know nothing about creating a linked cell that will transfer text. Both of these cells are formatted for "Text" plus I tried doing this on cells that were formatted "General" also.

If anything stands out to you, please let me know, but please don't go to any trouble.........and thank you either way, Jeff