Microsoft Office Tutorials and References
In Depth Information
Chapter 4: Changing workbook appearance
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 2013 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 several 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.
In this chapter, you’ll change the appearance of data, apply existing formats to data, make
numbers easier to read, change data’s appearance based on its value, and add images to