Format Painter Trick

Double-click Format Painter (paintbrush icon) to transfer cell formatting to multiple non-contiguous cells; press Escape when complete.