Copyright

Ch 5: Format Cells & Ranges in Excel

About This Chapter

This set of instructional Excel videos will show you how to format cells and ranges. Use our step-by-step guides to learn how to format cells and ranges in Excel.

Format Cells & Ranges in Excel: Chapter Summary

Get started on the path to creating effective Excel spreadsheets by first learning how to format cells and ranges. This chapter will give you all the tips you need to make changes to cells in a spreadsheet, including lessons that teach you how to merge cells, change cell styles and modify cell alignment. You'll get instructions on making changes to font, enhancing your text with word art and more.

The engaging video lessons are taught by subject matter experts who provide you with the info you need in small chunks, making it easier for you to retain the knowledge you acquire on formatting cells and ranges. Our lessons help you quickly learn how to make changes to cells in Excel, and each lesson comes with a quiz so you can test your knowledge of the concepts you've just studied.

As you make your way through the lessons in this chapter, you'll learn about topics including:

  • Merging cells
  • Modifying cell alignments and indentations
  • Choosing fonts and font styles
  • Using the format painter
  • Wrapping text within cells
  • Changing the number format
  • Highlighting cells in Excel
  • Applying and modifying cell styles
  • Changing text to WordArt

(Note: All demonstrations in this chapter will be using Microsoft Excel 2013. Certain features, tools or displays may be different in other versions.)

Excel is a trademark of the Microsoft Corporation, which is not affiliated with Study.com.

9 Lessons in Chapter 5: Format Cells & Ranges in Excel
Test your knowledge with a 30-question chapter practice test
How to Merge Cells in Excel

1. How to Merge Cells in Excel

MS Excel has two features that allow you to join multiple cells. You can Merge cells or Combine cells. This lesson will discuss the two features, explain the difference and show you how to use these commands.

How to Modify Cell Alignment & Indentation in Excel

2. How to Modify Cell Alignment & Indentation in Excel

Cell alignment is a key feature when giving your spreadsheet a more organized and consistent look. This lesson will review the six different alignment short-cut commands and explain how to align numbers and text within a cell.

Fonts and Font Styles in Excel

3. Fonts and Font Styles in Excel

Similar to Microsoft Word and PowerPoint, you can change the font and font size of your numerical data and text in an Excel worksheet. The ability to change fonts can help you make your worksheets easier to read, as well as look more professional.

How to Use the Format Painter in Excel

4. How to Use the Format Painter in Excel

This lesson explains the Format Painter tool in MS Excel. The command works similarly to the Copy/Paste command; however, it only copies the formatting of the cell, for instance numerical formatting, highlighting and borders.

Wrapping Text in Excel: How to Wrap Text within Cells

5. Wrapping Text in Excel: How to Wrap Text within Cells

What if you could convert a long line of text entered on a spreadsheet to multiple lines? It would fit better for printing and be easier to read. This lesson will guide you through formatting cells to accommodate wrapped text.

The Number Format in Excel: Options & Properties

6. The Number Format in Excel: Options & Properties

Since Excel is normally used to display numbers, the way they are displayed becomes a necessity in order to differentiate between just numbers, percentages and dollar amounts. This lesson will review the different number-formatting options in Excel.

How to Highlight Cells in Excel

7. How to Highlight Cells in Excel

Highlight is a term that can be used two ways in Excel. You can highlight or select cells that you want to edit, or you can highlight cells by adding a background color to draw attention. This lesson will explain and demonstrate both.

Cell Styles in Excel: Applying & Modifying Styles

8. Cell Styles in Excel: Applying & Modifying Styles

If you are looking for a quick and easy way to change the look of a cell or a range of cells, applying a predesigned style is the way to go. This lesson will help you understand Cell Styles and discuss how to apply Cell Styles to your numbers and text in a worksheet.

How to Change Text to WordArt in Excel

9. How to Change Text to WordArt in Excel

A great way to add fancy text to your MS Excel spreadsheet is using the WordArt command. This lesson will show examples of WordArt and explain how to add and modify WordArt graphics in MS Excel.

Chapter Practice Exam
Test your knowledge of this chapter with a 30 question practice chapter exam.
Not Taken
Practice Final Exam
Test your knowledge of the entire course with a 50 question practice final exam.
Not Taken

Earning College Credit

Did you know… We have over 160 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.

To learn more, visit our Earning Credit Page

Transferring credit to the school of your choice

Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.

Support