The format painter allows you to copy format but not content for reuse in your spreadsheets. In this video you will utilize the format painter feature to copy various formats across your Excel project.
- [Instructor] If you want to copy format but not content,…there are a number of different approaches in Excel.…One handy way is to use a feature called the Format Painter.…It's on the Home tab, far left,…in the group called Clipboard.…We can also use the Format Painter indirectly…by copying formats when dragging, using,…typically, the right mouse button.…And when you copy a format, most of us are likely…to be thinking of color backgrounds, font colors,…the kind of font, that sort of thing.…And those are certainly included, but any use of bold,…italic, underline, any kind of alignment,…any kind of numeric format also gets copied.…
In column A, we see some formatting here.…Most obviously, we're seeing italicized blue text,…it's also bold, on top of a yellow background.…And we surely will be able to copy that look,…but also, there's a numeric format there.…The cells have never actually been formatted numerically,…but they have the default setting called General,…which doesn't show commas or anything.…So we could easily overlook that,…
- Controlling fonts, borders, colors, and alignment
- Adjusting numeric formats quickly
- Accentuating dynamic data with conditional formatting
- Adjusting rows and columns