cell editing

[megawatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

I have a workbook with 5 sheets. Each sheet is 700 lines,approx. At several locations on each sheet in the workbook I have a number entered in a cell and several cells that have that same number. Is there an easy way to change that particular number in all of the cells that contain that number at the same time?

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

I have a workbook with 5 sheets. Each sheet is 700 lines,approx. At several
locations on each sheet in the workbook I have a number entered in a cell and
several cells that have that same number. Is there an easy way to change that
particular number in all of the cells that contain that number at the same
time?

Link the dependent sheets to the cell you want to change. If it is the same
cell in the dependent sheets, select all the sheet tabs by command clicking
on the sheets, then click in the cell and type an equal sign, then click on
the master sheet and click in the cell containing the data. Press enter.