Excel Lesson 2 Changing the Appearance of a Worksheet

1. Excel Lesson 2Changing the Appearance of a Worksheet

2. Changing the Size of a Cell • A series of (######) means that data is wider than the column. • Home tab>Cells group>Format Button>change column width or row height • Column—place the pointer on the right edge of the column heading until the pointer changes to a double-headed arrow and drag • Row—place the pointer below the row heading until the pointer changes to a double-headed arrow and drag

3. Changing the Size of a Cell • column should be wide enough to display the longest entry • AutoFit--best width for a column or the best height for a row • Double-click the row or column line to best fit

4. Positioning Data Within a Cell • Text—bottom-left • Numbers—bottom-right • Home tab>Alignment group>Alignment buttons

5. Positioning Data Within a Cell (continued) • Merge and Center—centers contents across several columns by combining into 1 cell • Home tab>Alignment group>Merge and Center button • Indented data—use the Increase or Decrease Indent buttons • Home tab>Alignment group>Increase or Decrease Indent

6. Positioning Data Within a Cell • Change the text orientation/rotating • Home tab>Alignment group>Orientation button • A menu of orientation options appears, with commands for angling the text at 45-degree angles clockwise or counterclockwise, stacking the text vertically, or rotating the text up or down.

7. Positioning Data Within a Cell • Text that is too long to fit in a cell is displayed in the next cell, if it is empty. • If the next cell already contains data, any text that does not fit in the cell is truncated, or hidden from view. • Wrap text—lets you see all text in a cell by making the row height larger • Home tab>Alignment group>Wrap text button

8. Changing the Appearance of Cells • You can modify the cell’s default font, font size, font style, font and fill colors, and borders. • The fonts and colors used in each workbook are part of a theme. • A theme is a preset collection of design elements, including fonts, colors, and other effects. • To change a workbook’s appearance, you can select a different theme, or you can format cells with other fonts and colors. • As you format cells, Live Preview shows the results of the different formatting options you can choose.

9. Changing the Appearance of Cells • Default font is Calibri. • Default size is 11 points. • Use font styles such as Bold, italic, and underline to add emphasis.

10. Changing the Appearance of Cells • The default font color is black. The default fill (or background) color of cells is white. You can change both of these colors. • You can add emphasis to a cell by placing a border (or line) around its edges. • Border button in the Font group

11. Changing the Appearance of Cells • Number formats change the way data looks in a cell. • The default number format is General. • The Formula Bar shows the actual value of the contents you see in the active cell. • For example, the actual value shown in the Formula Bar might be 1000, whereas the number you see in the active cell is $1,000.00.

12. Formats

13. Changing the Appearance of Cells (continued) • Format Painter—copy formatting from one cell to another • To open the Format Cells dialog box—click the Dialog Box Launcher on the Font, Alignment, or Number group • Or press CTRL + 1

15. Using Styles • Style—combination of formatting characteristics such as alignment, font, font size, and font color • Home tab>Styles group>Cell Styles button • To clear all the formatting, Home tab>Editing group>Clear button>Clear Format