Change the format of one sheet for all sheets at once

[R1dd3R]

Hello everyone,

Is it possible to change format of all Sheets at once?

Lets say Sheet 1 is the Master Sheet. Sheet 2, Sheet 3 etc contain the same table just with a different values. I would like to add/delete column/row or change font or whatever just in the Master Sheet 1 and it would copy these formats in all other Sheets (2,3 etc) at once.

Thanks!

[AliGW]

This will need VBA, if it is possible - shall I move the thread for you?

Administrative Note:

Welcome to the forum.

Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

Thank you for helping us to help you.

[R1dd3R]

Sorry for placing the thread to the wrong section. Please move it

Location updated

[AliGW]

Thanks - thread moved.

[R1dd3R]

I probably found out the easy solution. Selecting multiple Sheets (using CTRL or SHIFT) and it will edit the others

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.