102k views
2 votes
What is the fastest way to copy the format from one cell to multiple other cells?

User Tom Miller
by
7.1k points

1 Answer

4 votes
Select the cell with the formatting you want to copy.
Select Home > Format Painter.
Drag to select the cell or range you want to apply the formatting to.
Release the mouse button and the formatting should now be applied
User Iguramu
by
7.6k points