1 / 15

Excel Lesson 2 Changing the Appearance of a Worksheet

Excel Lesson 2 Changing the Appearance of a Worksheet. 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

mandel
Download Presentation

Excel Lesson 2 Changing the Appearance of a Worksheet

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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

  14. 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

More Related