Cutting and pasting data among cells is easy, you just click a cell, copy it, and then paste its contents, formatting and all, into another cell. In this video, discover a few different ways to copy formatting from one cell to another.
- [Instructor] Cutting and pasting data among cells is easy. You just click a cell, copy it, and then paste its contents, formatting it all into another cell. In this movie, I will show you a few different ways to copy formatting from one cell to another. My sample file is the CopyFormat workbook, and you can find it in the Chapter 6 folder of the exercise files collection. This workbook is an annoying mix of formats that are applied and not applied. Let's say that I want to copy the Monthly Sales format from cell A1, which is the large, blue header, to the total sales text in cell E1.
To do that, I can click cell A1, and, then on the Home tab of the ribbon, click the copy formatting or format painter button. So I'll click that and then I'll go over to cell E1, and click, and the formatting is applied. If I double-click the format painter button, then I will be able to paste a cell's formatting until I either press the escape key or click the format painter again. So, I will click cell A3, which has a month name in italics, and then I'll go up to the format painter and click it twice, and then I will drag from cells A4 through A10 to apply, And note that I can still apply the same format.
So I will drag from A11 to A14, click the format painter again, and I'm done. You can also drag the fill handle, and instead of extending values or extending a series, you can use it to apply formatting. I'll click cell A2 and then move the mouse pointer over the green square at the bottom-right corner of cell A2, that is the fill handle. I've got my black crosshair, and I'll drag to the right.
Note that it copied over Month along with its formatting, but that there is an options button to the right, Autofill Options. When I click that, I can either copy the cells, Fill Formatting Only, or Fill Without Formatting. In this case, I want the middle option, Fill Formatting Only, so I'll click that. And I get my original values back, but with the formatting from cell A2. There's probably some other formatting that I should do to this worksheet, but I think it looks a lot better than it did at first.
- Creating workbooks
- Manipulating cell data
- Sorting, filtering, and managing worksheets
- Using core functions and formulas
- Formatting worksheet elements
- Creating and managing conditional formats
- Working with charts
- Adding images and shapes
- Working with PivotTables
- Exporting workbooks
Skill Level Beginner
What you should know1m 11s
1. Getting Started with Excel
2. Managing Workbooks
3. Working with Worksheets, Cells, and Cell Data
4. Sorting, Filtering, and Managing Worksheets
5. Summarizing Data Using Formulas and Functions
6. Formatting Worksheet Elements
7. Working with Charts
8. Working with External Data and Objects
9. Exploring PivotTables
10. Reviewing and Sharing Spreadsheets
Further information1m 2s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.