I have many categories and instead of applying new settings to all categories one by one, i would like to know if this is possible to apply new settings to all categories at once?

This thread will show you how to use SQL to change all of the categories globally.