Excel 2013: Formatting Cells

TL;DR

Learn how to make your Excel worksheet more visually appealing and easier to read with formatting tips.

Transcript

In Excel 2013, the look and feel of your worksheet has a lot to do with the formatting choices you make. If we added some formatting to this fitness chart, for example, we could make it easier to read and more visually appealing. I'd like to start by selecting the cell that contains "Fitness Progress Chart" and making the text bigger, like a proper... Read More

Key Insights

• ❓ Font size, style, and color can be easily modified in Excel 2013 to enhance the visual appeal of a worksheet.
• 🧍 By giving cells unique fill colors and adding borders, you can make headers and data stand out.
• 🫠 Excel 2013 offers various alignment options to make text and charts easier to read.
• 💁 Automatic date and number formatting in Excel is a useful feature that can save time and improve data representation.

Questions & Answers

Q: How can you change the font size and style in Excel 2013?

To change the font size, select the cell and go to the Font group on the Home tab. Click the drop-down arrow next to Size and choose a desired size. To change the font style, click the drop-down arrow next to Font and select from the list.

Q: How can you add color to text in Excel 2013?

Click the arrow next to the Font Color command in the Font group. Choose a color from the theme colors or click More Colors for more options. Select a color to apply it to the text.

Q: How can you make header rows distinct in Excel 2013?

To make header rows distinct, select the cells and open the menu next to the Fill Color command. Choose a fill color to apply to the cells. You can also change the color of the text to create a contrasting effect.

Q: How can you add borders to an Excel worksheet?

Click the drop-down arrow next to the Borders command in the Font group. Choose from different border options, such as top and bottom border or thick outside border. To add borders around the outside and between the cells, select All Borders.

Summary & Key Takeaways

• Formatting choices in Excel 2013 can greatly improve the look and feel of your worksheet.

• You can change font size, style, and color to make text stand out and add visual appeal.

• Giving cells unique fill colors and adding borders can make headers and data distinct.