Excel 2013 Level 1 Unit 1 Preparing and Formatting a Worksheet

2. Excel 2013Level 1 Unit 1 Preparing and Formatting a Worksheet Chapter 3Formatting an Excel Worksheet

3. Formatting an Excel Worksheet Quick Links to Presentation Contents • Change Column Width • Change Row Height • Insert Rows • Insert Columns • Delete Cells, Rows, or Columns • Clear Data in Cells • CHECKPOINT 1 • Apply Formatting • Apply a Theme • Format Numbers • Use the Format Cells Dialog Box • Format with Format Painter • Hide and Unhide Columns and Rows • CHECKPOINT 2

4. Change Column Width column boundary To change column width: • Drag column boundary line. OR • Double-click column boundary. OR • Click Format button. • Click Column Width at drop-down list. • Type desired width. • Click OK.

5. Change Column Width - continued To change column width of selected adjacent columns: • Select desired columns. • Drag one column boundary within the selected columns. column boundary

6. Change Column Width - continued To change column width at the Column Width dialog box: • Click Format button. • Click Column Width option at drop-down list. • Type desired width. • Click OK. Column Width dialog box

7. Change Row Height To change row height: • Drag row boundary. OR • Click Format button. • Click Row Height at drop-down list. • Type desired height. • Click OK. row boundary

8. Change Row Height - continued To change row height of selected adjacent rows: • Select desired rows. • Drag one row boundary within the selected rows. row boundary

9. Change Row Height - continued To change row height at the Row Height dialog box: • Click Format button. • Click Row Height option at drop-down list. • Type desired height. • Click OK. Row Height dialog box

10. Insert Rows To insert a row with the Insert button: • Click Insert button. Insert button

11. Insert Rows - continued To insert a row with the Insert Sheet Rows option: • Click Insert button arrow. • Click Insert Sheet Rows at drop-down list. Insert Sheet Rows option

12. Insert Rows - continued To insert a row at the Insert dialog box: • Click Insert button arrow. • Click Insert Cells option. • Click Entire row option in Insert dialog box. • Click OK. Insert dialog box

13. Insert Columns To insert a column with the Insert Sheet Columns option: • Click Insert button arrow. • Click Insert Sheet Columns at drop-down list. Insert Sheet Columns option

14. Insert Columns - continued To insert a column at the Insert dialog box: • Click Insert button arrow. • Click Insert Cells. • Click Entire column. • Click OK. Entire column option

15. Delete Cells, Rows, or Columns To delete a cell: • Make cell active. • Click Delete button arrow. • Click Delete Cells option at drop-down list. • At Delete dialog box, specify what to delete. • Click OK. Delete dialog box

16. Clear Data in Cells To clear data in cells: • Select desired cells. • Press Delete key. OR • Select desired cells • Click Clear button. • Click Clear Contents at drop-down list. Clear Contents option

17. CHECKPOINT 1 • To display the Column Width dialog box, click the Format button on this tab. • FILE • HOME • INSERT • PAGE LAYOUT • By default, a column is inserted here in relation to the column containing the active cell. • to the top • to the bottom • to the right • to the left Answer Answer Next Question Next Question • A vertical inch contains approximately how many points? • 12 • 24 • 48 • 72 • To delete cell contents but not the cell, make the cell active and then press this key. • Enter • Tab • Insert • Delete Answer Answer Next Question Next Slide

18. Apply Formatting • You can apply a variety of formatting to cells in a worksheet with buttons in the Font group on the HOME tab. Font group

19. Apply Formatting - continued To change the font: • Make desired cell active or select the desired cells. • Click Font button arrow. • Scroll down drop-down gallery and click desired font. Font button arrow

20. Apply Formatting - continued Borders button arrow To add a border: • Make desired cell active or select desired cells. • Click Borders button arrow. • Click desired option at drop-down list.

21. Apply Formatting - continued To apply fill color: • Make desired cell active or select desired cells. • Click Fill Color button arrow. • Click desired color option. Fill Color button arrow

22. Apply Formatting - continued Font Color button arrow To change the font color: • Make desired cell active or select desired cells. • Click Font Color button arrow in Font group on HOME tab. • Click desired color at drop-down color palette.

23. Apply Formatting - continued • Double-click in a cell and then select data within the cell and the Mini toolbar displays above the selected data. Mini toolbar

24. Apply Formatting - continued • Enter words or text combined with numbers in a cell and the text is aligned at the left edge of the cell. • Enter numbers in a cell and the numbers are aligned at the right side of the cell. Alignment group

25. Apply Formatting - continued To merge each row of the selected cells: • Select desired cells. • Click Merge & Center button arrow. • Click Merge Across option at drop-down list. Merge Across option

26. Apply Formatting - continued To rotate text: • Make desired cell active or select desired cells. • Click Orientation button in Alignment group on HOME tab. • Click desired option at drop-down list. Orientation button

27. Apply a Theme To apply a theme: • Click PAGE LAYOUT tab. • Click Themes button. • Click desired theme at drop-down gallery. Themes button

28. Format Numbers To format numbers using the Number Format button: • Make desired cell active or select desired cells. • Click Number Format button arrow. • Click desired number format at drop-down list. Number Format button arrow

29. Format Numbers - continued To format numbers using the Format Cells dialog box: • Make desired cell active or select desired cells. • Click Number group dialog box. • Click desired number format in Format Cells dialog box with Number tab selected. • Click OK. Number tab

30. Format Numbers - continued continues on next slide…

31. Format Numbers - continued

32. Use the Format Cells Dialog Box To align and indent data in cells: • Make desired cell active or select desired cells. • Click Alignment group dialog box. • Select desired options in Format Cells dialog box with Alignment tab selected. • Click OK. Alignment tab

33. Use the Format Cells Dialog Box - continued Font tab To change the font: • Make desired cell active or select desired cells. • Click Font group dialog box. • Select desired options in Format Cells dialog box with Font tab selected. • Click OK.

34. Use the Format Cells Dialog Box - continued To add borders to cells: • Select cells. • Click Borders button arrow. • Click desired border. OR • Select Cells • Click Borders button arrow. • Click More Borders. • Use options in dialog box to apply desired border. • Click OK. Border tab

35. Use the Format Cells Dialog Box - continued To add fill and shading to cells: • Select cells. • Click Fill Color button arrow. • Click desired color. OR • Select cells. • Click Format button. • Click Format Cells at drop-down list. • Click Fill tab. • Use options in dialog box to apply desired shading. • Click OK. Fill tab

36. Format with Format Painter To format with the Format Painter: • Select cells with desired formatting. • Double-click Format Painter button. • Select desired cells. • Click Format Painter button. Format Painter button

37. Hide and Unhide Columns and/or Rows Format button To hide rows or columns: • Select rows or columns. • Click Format button. • Point to Hide & Unhide. • Click Hide Rows or Hide Columns.

38. Hide and Unhide Columns and/or Rows - continued To unhide rows or columns: • Select rows above and below hidden row or columns to left and right of hidden column. • Click Format button. • Point to Hide & Unhide option. • Click Unhide Rows or Unhide Columnsoption. Hide & Unhide option

39. CHECKPOINT 2 • You can apply a variety of formatting with buttons in this group on the HOME tab. • Font • Editing • Formulas • Formatting • This is a set of formatting choices that includes fonts, colors, and effects. • texture • trial • trend • theme Answer Answer Next Question Next Question • When you select data this displays above the selected data. • Format toolbar • Highlight bar • Mini toolbar • Font bar • When you click the Format Painter button, the mouse pointer displays with this attached. • paintbrush • white arrow • black arrow • crosshairs Answer Answer Next Question Next Slide

40. Formatting an Excel Worksheet Summary of Presentation Concepts • Change column widths • Change row heights • Insert rows and columns in a worksheet • Delete cells, rows, and columns in a worksheet • Clear data in cells • Apply formatting to data in cells • Apply formatting to selected data using the Mini toolbar • Preview a worksheet • Apply a theme and customize the theme font and color • Format numbers • Repeat the last action • Automate formatting with Format Painter • Hide and unhide rows and columns