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
|