Template:Rendering tips attribute spreadsheet
From TOI-Pedia
When you need to change properties for many objects, such as lights or shaders, it might get quite laborious to change every one of them individually.
The Attribute Spread Sheet can be quite useful. Go to Window > General editors > Attribute Spread Sheet to open it
Select all objects (geometry, lights, shaders, etc) you want to change; an easy way to do this for shaders, lights or cameras is using the Hypershade.
You can edit the values at once for all objects; you can select value columns, so you only need to enter values once.