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.
Format cells and ranges
From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Format cells and ranges
- [Instructor] Let's take a look at some options we have for formatting cells and ranges in our worksheets. After watching this video you'll know how to merge and unmerge cells, how to wrap text within a cell, how to modify Cell Alignment, Orientation and Indentation. Let's jump right into our Format Cells workbook and get busy. First of all, we have a title up in row one, that is currently in cell A1, we are going to take this title and merge the cells from A1 over to F1. And once the cells are merged and we have one cell for our title, we can then center that both horizontally and vertically within the cell. With that range selected, on my home tab I'll go to Merge and Center. Now let's take a look at our four options under this menu. We can merge and center the information. That means all of those cells will be merged together, and the title Travel Expenses will be centered within our resulting cell. We can choose Merge Across, which would keep the text left aligned, yet merge all…
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
-
-
-
-
-
-