Microsoft Office Tutorials and References
In Depth Information
4 Changing Workbook
In this chapter, you will learn how to
✔ Format cells.
✔ Define styles.
✔ Apply workbook themes and Excel table styles.
✔ Make numbers easier to read.
✔ Change the appearance of data based on its value.
✔ Add images to worksheets.
Entering data into a workbook efficiently saves you time, but you must also ensure
that your data is easy to read. Microsoft Excel 2010 gives you a wide variety of ways
to make your data easier to understand; for example, you can change the font, character
size, or color used to present a cell’s contents. Changing how data appears on a
worksheet helps set the contents of a cell apart from the contents of surrounding cells. The
simplest example of that concept is a data label. If a column on your worksheet contains
a list of days, you can easily set apart a label (for example, Day ) by presenting it in bold
type that’s noticeably larger than the type used to present the data to which it refers. To
save time, you can define a number of custom formats and then apply them quickly
to the desired cells.
You might also want to specially format a cell’s contents to reflect the value in that cell.
For example, Lori Penor, the chief operating officer of Consolidated Messenger, might
want to create a worksheet that displays the percentage of improperly delivered packages
from each regional distribution center. If that percentage exceeds a threshold, she could
have Excel display a red traffic light icon, indicating that the center’s performance is out
of tolerance and requires attention.