Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?
1
Use Ctrl to select all three cells, then click the paste button on the standard toolbar
2
Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify
3
Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to
4
All the above
5
None of the above