Changing Text in Both An Excel Spreadsheet and a Spreadsheet's Cha

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

A co-worker of mine has a question pertaining to Microsoft Excel 97. She is
wondering if, if the same text appears in both an Excel spreadsheet and in a
chart within the spreadsheet, it can be changed all at once. For example, if
the text "summer" appears in the spreadsheet, and in a title of a chart in
the spreadsheet, and if someone wants to change "summer" to "fall" in all
locations in the spreadsheet and chart, can this be done with one command or
sequence of commands? Or, does the text have to be changed in the chart and
spreadsheet separately? Thanks for any help you can provide!
 
Hi
if you have a master sheet with this data simple reference this cell in
the master sheet in all your other sheets with a formula such as:
='sheet1'!A1
 
Alan Sexter wrote...
A co-worker of mine has a question pertaining to Microsoft Excel
97. She is wondering if, if the same text appears in both an
Excel spreadsheet and in a chart within the spreadsheet, it can
be changed all at once. For example, if the text "summer"
appears in the spreadsheet, and in a title of a chart in the
spreadsheet, and if someone wants to change "summer" to
"fall" in all locations in the spreadsheet and chart, can this be
done with one command or sequence of commands? Or, does
the text have to be changed in the chart and spreadsheet
separately?
Click to expand...

It could be done, but it requires prior setup. Edit > Replace doesn'
process text in charts, so if your colleague has entered chart title
manually, the only way to change them is manually.

The alternative is to have chart titles refer to cells on som
worksheet. See the following for details.

http://www.google.com/[email protected]

Then include that cell in any Edit > Replace action to change "summer
to "fall"
 
Back
Top