what is the formula for changing the same cell on different sheet.

scotty · Nov 17, 2004

i want to change the same cell on many sheets in one go can anyone give me
the formula for this

Alan Beban · Nov 17, 2004

scotty said:
i want to change the same cell on many sheets in one go can anyone give me
the formula for this

Select all the sheets; then insert the formula in the appropriate cell
in the active sheet.

Alan Beban

scotty · Nov 17, 2004

if i want to change cell f5 on all sheets what formula would i use

Alan · Nov 17, 2004

No need for a formula, as Alan Beban advised, hold down the shift key and
select all the sheets, then enter whatever in F5

scotty · Nov 17, 2004

many thanks will try that

Alan said:
No need for a formula, as Alan Beban advised, hold down the shift key and
select all the sheets, then enter whatever in F5