In the font list, click the font you want to apply.On the Home tab of the ribbon, in the Font group, click the Font arrow.Select the cell or cells you want to format.To change the font used to display cell contents The new standard font doesn’t take effect until you exit Excel and restart the app. To make your data labels or any other data stand out, you can change the format of the cells that hold your data.
Data labels give you and your colleagues information about data in a worksheet, but it’s important to format the labels so that they stand out visually.
Format cellsĮxcel worksheets can hold and process lots of data, but when you manage numerous worksheets, it can be hard to remember from a worksheet’s title exactly what data is kept in that worksheet. This chapter guides you through procedures related to changing the appearance of data, applying existing formats to data, making numbers easier to read, changing data’s appearance based on its value, and adding images to worksheets. If that percentage exceeds a threshold, Excel could display a red traffic light icon, indicating that the center’s performance is out of tolerance and requires attention. For example, you could create a worksheet that displays the percentage of improperly delivered packages from each regional distribution center. You might also want to specially format a cell’s contents to reflect the value in that cell. To save time, you can define a number of custom formats and then apply them quickly to the cells you want to emphasize. Changing how data appears on a worksheet helps set the contents of a cell apart from the contents of surrounding cells. Microsoft Excel 2016 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.
VIEW HEADERS IN EXCEL 2016 DOWNLOAD
For practice file download instructions, see the introduction.Įntering data into a workbook efficiently saves you time, but you must also ensure that your data is easy to read. For this chapter, use the practice files from the Excel2016SBS\Ch04 folder.
0 kommentar(er)
