1 / 40

Excel 2013 Level 1 Unit 1 Preparing and Formatting a Worksheet Chapter 4 Enhancing a Worksheet

Excel 2013 Level 1 Unit 1 Preparing and Formatting a Worksheet Chapter 4 Enhancing a Worksheet. Enhancing a Worksheet. Quick Links to Presentation Contents. Format a Worksheet Page Insert Headers and Footers CHECKPOINT 1 Customize Print Jobs Complete a Spelling Check

dacia
Download Presentation

Excel 2013 Level 1 Unit 1 Preparing and Formatting a Worksheet Chapter 4 Enhancing 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 2013Level 1 Unit 1 Preparing and Formatting a Worksheet Chapter 4 Enhancing a Worksheet

  2. Enhancing a Worksheet Quick Links to Presentation Contents • Format a Worksheet Page • Insert Headers and Footers • CHECKPOINT 1 • Customize Print Jobs • Complete a Spelling Check • Use Undo and Redo • Find and Replace Data • Find and Replace Cell Formatting • Sort Data • Filter Data • CHECKPOINT 2

  3. Format a Worksheet Page • An Excel worksheet contains default page formatting. • By default, a worksheet contains these defaults: • left and right margins of 0.7 inch • top and bottom margins of 0.75 inch • prints in portrait orientation • has a page size is 8.5 inches by 11 inches

  4. Format a Worksheet Page - continued To change worksheet margins: • Click PAGE LAYOUT tab. • Click Margins button. • Click Custom Margins option at drop-down list. continues on next slide… Custom Margins option

  5. Format a Worksheet Page - continued • At Page Setup dialog box, change top, left, right, and/or bottom measurements. • Click OK. Page Setup dialog box

  6. Format a Worksheet Page - continued To center a worksheet horizontally and/or vertically: • Click PAGE LAYOUT tab. • Click Margins button. • Click Custom Margins option at drop-down list. • Click Horizontally option and/or Vertically option. • Click OK. Horizontally and Vertically options

  7. Format a Worksheet Page - continued To change page orientation: • Click PAGE LAYOUT tab. • Click Orientation button. • Click desired orientation at drop-down list. Orientation button

  8. Format a Worksheet Page - continued To change the page size: • Click PAGE LAYOUT tab. • Click Size button. • Click desired size at drop-down list. Size button

  9. Format a Worksheet Page - continued • If a worksheet contains more than 7 inches of cells across the page, a page break is inserted in the worksheet and the remaining columns are moved to the next page. page break

  10. Format a Worksheet Page - continued To insert a page break • Select column or row. • Click PAGE LAYOUT tab. • Click Breaks button. • Click the Insert Page Break option at drop-down list. Insert Page Break option

  11. Format a Worksheet Page - continued To display the page break view: • Click Page Break Preview button. continues on next slide… Page Break Preview button

  12. Format a Worksheet Page - continued page break preview

  13. Format a Worksheet Page - continued To print column and row titles: • Click PAGE LAYOUT tab. • Click Print Titles button. • Type row range in Rowsto repeat at top option. • Type column range in Columns to repeat at left option. • Click OK. Page Setup dialog box

  14. Format a Worksheet Page - continued To scale data: • Click PAGE LAYOUT tab. • Click desired option. Scale to Fit group

  15. Format a Worksheet Page - continued To insert a background picture: • Click PAGE LAYOUT tab. • Click Background button. • Navigate to desired picture and double-click picture. Sheet Background dialog box

  16. Format a Worksheet Page - continued To print gridlines and/or row and column headings: • Click PAGE LAYOUT tab. • Click the Print check box in the Gridlines and/or Headings section in Sheet Options group. OR • Click PAGE LAYOUT tab. • Click Sheet Options dialog box launcher. • Check Gridlines and/or Row and column headings check boxes. • Click OK. Sheet Options group

  17. Format a Worksheet Page - continued To print a specific area of a worksheet: • Select cells to print. • Click Print Area button. • Click Set Print Area option at drop-down list. Set Print Area option

  18. Insert Headers and Footers To insert headers or footers: • Click INSERT tab. • Click Header & Footer button. continues on next slide… Header & Footer button

  19. Insert Headers and Footers - continued Header button • Click Header button and then click predesigned header or click Footer button and then click predesigned footer. OR • Click INSERT tab. • Click Header & Footer button. • Click desired header or footer elements.

  20. Insert Headers and Footers - continued • At the Print backstage area, you can preview your headers and footers before printing. • If your worksheet will print on more than one page, you can view different pages by clicking the Next Page button or the Previous Page button. Next Page button

  21. Insert Headers and Footers - continued To insert headers and footers in Page Layout view: • Switch to Page Layout view. • Click Click to add header text or Click to add footer text. • Type header or footer. Click to add footer text

  22. Insert Headers and Footers - continued To insert headers and footers at the Page Setup dialog box: • Click PAGE LAYOUT tab. • Click Page Setup group dialog box launcher. • At Page Setup dialog box, click Header/Footer tab. • Make desired selections. • Click OK. Page Setup dialog box

  23. Insert Headers and Footers - continued • To create different odd and even page headers, click the Different odd and even pages check box to insert a check mark and then click the Custom Header button. • This displays the Header dialog box with the Odd Page Header tab selected. Header dialog box

  24. CHECKPOINT 1 • The default left and right margins are set at this inch measurement. • 0.5 • 0.7 • 1.0 • 1.25 • By default, these do not print. • titles • headings • borders • gridlines Answer Answer Next Question Next Question • This is the default orientation. • Panoramic • Standard • Portrait • Landscape • This is the name for text that prints at the top of each worksheet page. • header • footer • repeater • titles Answer Answer Next Question Next Slide

  25. Customize Print Jobs • With options in the Settings category at the Print backstage area, you can specify what you want printed. • By default, the active worksheet prints. Settings category

  26. Customize Print Jobs - continued • With the Pages text boxes in the Settings category, you can specify the pages that you want printed of your worksheet. Pages text boxes

  27. Complete a Spelling Check To complete a spelling check: • Click REVIEW tab. • Click Spelling button. • Replace or ignore selected words. Spelling button Spelling dialog box

  28. Use Undo and Redo To use Undo: • Click the Undo button on the Quick Access toolbar. OR • Use the keyboard shortcut Ctrl + Z. Undo button

  29. Find and Replace Data To find data: • Click Find & Select button. • Click Find at drop-down list. • Type data in Find what text box. • Click Find Next button. Find what text box

  30. Find and Replace Data - continued To find and replace data: • Click Find & Select button. • Click Replace at drop-down list. • Type data in Find what text box. • Type data in Replace with text box. • Click Replace button or Replace All button. Replace All button

  31. Find and Replace Data - continued • Display additional find and replace options by clicking the Options button. This expands the dialog box. Options button

  32. Find and Replace Cell Formatting • Use the Format buttons at the expanded Find and Replace dialog box to search for specific cell formatting and replace with other formatting. Format buttons

  33. Sort Data To sort data: • Select cells. • Click Sort & Filter button. • Click desired sort option at drop-down list. Sort & Filter button

  34. Sort Data - continued To complete a custom sort: • Select cells. • Click Sort & Filter button. • Click Custom Sort at drop-down list. • Specify options at Sort dialog box. • Click OK. Sort dialog box

  35. Sort Data - continued To sort more than one column: • Display Sort dialog box. • Specify first column to sort in Sort by option box. • Click Add Level button. • Specify second column in first Then by option box. Then by option box

  36. Filter Data To filter a list: • Select cells. • Click Sort & Filter button. • Click Filter at drop-down list. • Click down-pointing arrow of heading to filter. • Click desired option at drop-down list. filter arrow

  37. Filter Data - continued • If a column contains numbers, click the filter arrow, point to the Number Filters option, and a side menu displays with options for filtering numbers. Number Filters option

  38. CHECKPOINT 2 • The Spelling button is located on this tab. • HOME • REVIEW • INSERT • PAGE LAYOUT • The Sort & Filter button is located on this tab. • PAGE LAYOUT • INSERT • REVIEW • HOME Answer Answer Next Question Next Question • This command will reverse certain commands or delete the last data typed in a cell. • Ignore • Cancel • Undo • Redo • You can place a restriction, called this, on data in a worksheet to temporarily isolate specific data. • a filter • a sort • a selection • a trial Answer Answer Next Question Next Slide

  39. Enhancing a Worksheet Summary of Presentation Concepts • Change worksheet margins • Center a worksheet horizontally and vertically on the page • Insert a page break in a worksheet • Print gridlines and row and column headings • Set and clear a print area • Insert headers and footers • Customize print jobs • Complete a spelling check on a worksheet • Find and replace data and cell formatting in a worksheet • Sort data in cells in ascending and descending order • Filter a list using AutoFilter

More Related