400 likes | 637 Views
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
E N D
Excel 2013Level 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 • Use Undo and Redo • Find and Replace Data • Find and Replace Cell Formatting • Sort Data • Filter Data • CHECKPOINT 2
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
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
Format a Worksheet Page - continued • At Page Setup dialog box, change top, left, right, and/or bottom measurements. • Click OK. Page Setup dialog box
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
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
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
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
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
Format a Worksheet Page - continued To display the page break view: • Click Page Break Preview button. continues on next slide… Page Break Preview button
Format a Worksheet Page - continued page break preview
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
Format a Worksheet Page - continued To scale data: • Click PAGE LAYOUT tab. • Click desired option. Scale to Fit group
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
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
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
Insert Headers and Footers To insert headers or footers: • Click INSERT tab. • Click Header & Footer button. continues on next slide… Header & Footer button
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.
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
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
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
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
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
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
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
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
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
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
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
Find and Replace Data - continued • Display additional find and replace options by clicking the Options button. This expands the dialog box. Options button
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
Sort Data To sort data: • Select cells. • Click Sort & Filter button. • Click desired sort option at drop-down list. Sort & Filter button
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
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
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
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
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
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