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

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

scotty wrote:
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

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

"Alan Beban" wrote:

scotty wrote:
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

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" wrote in message
...
if i want to change cell f5 on all sheets what formula would i use

"Alan Beban" wrote:

scotty wrote:
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

many thanks will try that

"Alan" wrote:

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" wrote in message
...
if i want to change cell f5 on all sheets what formula would i use

"Alan Beban" wrote:

scotty wrote:
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