R-click sheet tab and pick Select All Sheets. Now Edit A8, all sheets
will have the edit. R-click Tab, select Ungroup

IVUSKA wrote:

I have a workbook with large amount of sheets and I need to replace in cell
A8 in each sheet its content with text XXX, but the former content of the A8
is not the sam, in each cell is different. Is there anyway how to do it at
once so i dont have to do it for one sheet by one? Is it possible to replace
with a formula? Is it possible to replace like this range of cells?

thank you in advance for your help