From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Apply styles to cells and ranges
From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Apply styles to cells and ranges
- [Instructor] We can quickly apply formatting to a cell or a range of cells by using the great built-in cell formats. After watching this video, you will know how to use the Format Painter to copy formatting and paste it on to another cell, or a range of cells. How to use the built-in number formats, the built-in cell styles, and how to clear the formatting from a cell or a range of cells. Let's jump right into our Styles Workbook. And we'll take a look first at our column headings in Row Four. To make these stand out more, let's apply some formatting. Now, I'll start with the name cell in A4, and I could use my format options in Font, but there are some great built-in cell styles that we can use. Let's go over to our Styles group, and click the Cell Styles menu. These are my recently used ones, but we have good, bad, and neutral and all that really means is, it'll be red, green, or yellow. We also have a normal setting, that's just your normal default font for this workbook and a…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
Paste data using special paste options6m 28s
-
(Locked)
Fills cells by using AutoFill4m 16s
-
(Locked)
Insert and delete columns, rows, and cells3m 15s
-
(Locked)
Format cells and ranges5m 39s
-
(Locked)
Apply styles to cells and ranges6m 44s
-
(Locked)
Define and reference named ranges5m 18s
-
(Locked)
Insert sparklines5m 35s
-
(Locked)
Summarize data visually with built-in conditional formatting5m 3s
-
(Locked)
Challenge: Manage data, cells, and ranges27s
-
(Locked)
Solution: Manage data, cells, and ranges4m 23s
-
-
-
-
-
-