I created a workbook that has sheets for 100 clients, unfortunately I made the same formatting error on each sheet. If I wanted to format cells A1:D4 to be centered bold and colored black is there any way I could do that globally without having to unlock each individual sheet and reforming the same cell field for each sheet?

I'm not sure if I could take any more copy pasting... Thanks!