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

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!
 
F

Frank Kabel

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
 
H

hgrove

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?

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"
 

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