What do you do to the format printer button and then drag through the nonadjacent to paint the format to the ranges?

To use the format painter in programs like Microsoft Excel or Word, first, click the format painter button (often represented by a paintbrush icon). Then, hold down the Ctrl key (or Command key on Mac) while clicking and dragging through the non-adjacent ranges you wish to apply the formatting to. This allows you to "paint" the formatting from one selection to multiple other selections simultaneously. Release the mouse button and the Ctrl key to apply the formatting.