What button copies multiple formats from selected cells to other cells?

Answer 1

The button that you can use to apply multiple formatting style to selected cell is called format painter (the icon is a little brush on the "standard" toolbar). The way it works is as follows:

1/ select an area of the spreadsheet that already have the formatting that you want to use.

2/ click on the format painter button on the standard toolbar.

3/ select the area of the spreadsheet where you want to copy the formatting.

That's all.

Note that if you want to apply the same formatting in several places, you can double click on the format painter button in step 2/ instead of a single click. Then you can do step 3/ several times. When you are finished, click again on the format painter button to deactivate it.

Answer 2

Format Painter button