From the course: Excel 2016: Advanced Formatting Techniques

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Copy formats quickly using dragging techniques and the Format Painter

Copy formats quickly using dragging techniques and the Format Painter

From the course: Excel 2016: Advanced Formatting Techniques

Start my 1-month free trial

Copy formats quickly using dragging techniques and the Format Painter

“

- There are times when you want to copy not the content of cells but the format of cells. In this worksheet called FormatPainter, we're going to be using a tool called Format Painter. But before using that, let's point out a few facts about formatting. In the cells that we're looking at in cells A2 to A7, we're seeing that that's italicized. It's a bluish text on top of a yellow background. And we might want to copy the look of that, the format of it, to some other cells. Maybe I want to copy this into the Texas column, or maybe all these cells here. What we might not be thinking about is the fact that there is also a numeric format here, even though we're not seeing it. These are text entries. All cells have general format unless you've applied a different format. General format doesn't use commas. It doesn't use any kind of decimals unless they're specifically typed. So, when we copy this format, we will be seeing a different look of the numbers as well. We're not always thinking of…

Contents