Results 1 to 10 of 10
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Change text globally (Excel 2002)

    Hi

    Is it possible to change text globally, by this I mean I would like to adjust the text in cell G4 in 184 worksheets from Q12004 to Q12005.

    Thanks in advance

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Change text globally (Excel 2002)

    Hi Braddy,

    If the sheets are in the same WB, you can rightclick on any sheet tab and select all sheets. Once the sheets are selected, select cell G4 and type the new text entry!
    This is only effective if all the sheets need to be changed in the workbook. (Else a macro is best to use to change the text in certain sheets!)
    Regards,
    Rudi

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Change text globally (Excel 2002)

    As an addition to Rudi's reply, if you don't need to change G4 in all worksheets in a workbook, you can select some of them as follows:
    - Click one sheet tab, then Shift+click another sheet tab to select the two sheets plus all in between. If necessary, you can use the arrows to the left of the sheet tabs to scroll the sheet tabs.
    - Ctrl+click an individual sheet tab to add it to the selection or to remove it from the selection.

  4. #4
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Change text globally (Excel 2002)

    Hi Rudi

    Thanks to you and Hans for your reply, simple but very effective.

    Braddy
    If you are a fool at forty, you will always be a fool

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Change text globally (Excel 2002)

    You could also hit control-h, type your string to find, type the string to replace, then hit the Find All button.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  6. #6
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Change text globally (Excel 2002)

    Just a minor detail you forgot to mention:
    From the Within: dropdown, select Workbook!
    Jeez Pieterse, i've been working in Excel for mega-years and this is the first time I actually notice that!!! I may have seen it in the past, but never taken it to mind! It will stick now, as I tried it and it worked well...
    thanx
    Regards,
    Rudi

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Change text globally (Excel 2002)

    The option to search within the entire workbook was introduced in Excel 2002, I think, so it hasn't been around for "mega-years".

  8. #8
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Change text globally (Excel 2002)

    OK... that makes sense then. <img src=/S/bingo.gif border=0 alt=bingo width=15 height=22>
    Regards,
    Rudi

  9. #9
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Change text globally (Excel 2002)

    No it hasn't. My Flexfind utility has though, which enables search and replace in objects too...
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  10. #10
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Change text globally (Excel 2002)

    Neat utility...can come useful! <img src=/S/ribbon.gif border=0 alt=ribbon width=15 height=15>
    Regards,
    Rudi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •