About This Chapter
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Earning College Credit
Did you know… We have over 95 college courses that prepare you to earn credit by exam that is accepted by over 2,000 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.
Other chapters within the Intro to Excel: Essential Training & Tutorials course
- Creating Worksheets & Workbooks in Excel
- Formatting Worksheets & Workbooks in Excel
- Customizing Options & Views in Excel
- Configure to Print & Save in Excel
- Insert Data in Cells and Ranges in Excel
- Filter and Sort a Table in Excel
- Order & Group Cells & Ranges in Excel
- Create a Table in Excel
- Modify a Table in Excel
- Use Cell Ranges & References for Formulas & Functions in Excel
- Summarize Data with Functions in Excel
- Functions with Conditional Logic in Excel
- Format & Modify Text with Functions in Excel
- Create a Chart in Excel