Excel 2010 Bible

Chapter 6: Worksheet Formatting 119 Office 2007 introduced several new fonts, and the default font has been changed for all the ...

Part I: Getting Started with Excel 120 Tip If you plan to distribute a workbook to other users, you should stick with the standa ...

Chapter 6: Worksheet Formatting 121 FIGURE 6.4 You can choose many different font-formatting options for your worksheets. If you ...

Part I: Getting Started with Excel 122 Changing Text Alignment ................................................................. ...

Chapter 6: Worksheet Formatting 123 l (^) Center: Centers the cell contents in the cell. If the text is wider than the cell, the ...

Part I: Getting Started with Excel 124 Choosing vertical alignment options ..................................................... ...

Chapter 6: Worksheet Formatting 125 FIGURE 6.7 Merge worksheet cells to make them act as if they were a single cell. You can mer ...

Part I: Getting Started with Excel 126 From the Home ➪ Alignment ➪ Orientation drop-down list, you can apply the most common tex ...

Chapter 6: Worksheet Formatting 127 Using Colors and Shading ................................................................... ...

Part I: Getting Started with Excel 128 Adding Borders and Lines ................................................................ ...

Chapter 6: Worksheet Formatting 129 Another way to apply borders is to use the Border tab of the Format Cells dialog box, which ...

Part I: Getting Started with Excel 130 Adding a Background Image to a Worksheet................................................. ...

Chapter 6: Worksheet Formatting 131 Using Named Styles for Easier Formatting One of the most underutilized features in Excel is ...

Part I: Getting Started with Excel 132 Applying styles ......................................................................... ...

Chapter 6: Worksheet Formatting 133 The following sections describe these procedures. Modifying an existing style .............. ...

Part I: Getting Started with Excel 134 Creating new styles ..................................................................... ...

Chapter 6: Worksheet Formatting 135 Tip You may want to create a master workbook that contains all your custom styles so that yo ...

Part I: Getting Started with Excel 136 FIGURE 6.14 The elements in this worksheet use the default theme. Figure 6.15 shows the s ...

Chapter 6: Worksheet Formatting 137 Applying a theme ........................................................................... ...

Part I: Getting Started with Excel 138 Customizing a theme...................................................................... ...