Excel 2013 Level 1 Unit 2 Enhancing the Display of Worksheets

2. Excel 2013Level 1 Unit 2Enhancing the Display of Worksheets Chapter 5 Moving Data within and between Workbooks

3. Moving Data within and between Workbooks • Create a Workbook with Multiple Worksheets • Copy, Cut, and Paste Cells • Manage Worksheets • CHECKPOINT 1 • Work with Ranges • Work with Windows • Move, Link, Copy, and Paste Data • CHECKPOINT 2 Quick Links to Presentation Contents

4. Create a Workbook with Multiple Worksheets To display a worksheet in a workbook with multiple worksheets: • Click desired sheet tab. sheet tab

5. Create a Workbook with Multiple Worksheets - continued To insert a new worksheet: • Click New sheet button. OR • Press Shift + F11. New sheet button

6. Create a Workbook with Multiple Worksheets - continued To delete a worksheet: • Click worksheet tab. • Click Delete button arrow. • Click Delete Sheet. • Click Delete button. Delete Sheet option

7. Create a Workbook with Multiple Worksheets - continued • To work with more than one worksheet at a time, select the desired worksheets. • You might want to select multiple worksheets to apply the same formatting to cells or to delete multiple worksheets. • To select adjacent worksheet tabs, click the first tab, hold down the Shift key, and then click the last tab. • To select nonadjacent worksheet tabs, click the first tab, hold down the Ctrl key, and then click any other tabs you want selected.

8. Cut, Copy, and Paste Cells To copy and paste selected cells: • Select cells. • Click Copy button. • Click desired cell. • Click Paste button. Copy button

9. Cut, Copy, and Paste Cells - continued To move and paste selected cells: • Select cells. • Click Cut button. • Click desired cell. • Click Paste button. Cut button

10. Cut, Copy, and Paste Cells - continued • The Paste Options button displays in the lower right corner of the pasted cell(s) when you paste a cell or cells. Paste Options button

11. Cut, Copy, and Paste Cells - continued To copy and paste multiple items: • Click Clipboard task pane launcher. • Select desired cells. continues on next slide… Clipboard group dialog box launcher

12. Cut, Copy, and Paste Cells - continued • Click Copy button. • Repeat Steps 2 and 3 as desired. • Make desired cell active. • Click item in Clipboard task pane to be inserted in worksheet. • Repeat Step 6 as desired. Clipboard task pane

13. Cut, Copy, and Paste Cells - continued • When all desired items are inserted, click the Clear All button to remove any remaining items. Clear All button

14. Cut, Copy, and Paste Cells - continued • With the buttons in the Paste Values section of the Paste Options button drop-down list, you can choose to insert the value only, the value with numbering formatting, or the value with the source formatting. Paste Values section

15. Manage Worksheets To move or copy a worksheet: • Right-click sheet tab. • Click Move orCopy. continues on next slide… Move orCopy option

16. Manage Worksheets - continued • At Move or Copy dialog box, click desired worksheet name in Before sheet list box. • Click OK. OR • Drag worksheet tab to desired position. (To copy, hold down Ctrl key while dragging.) Move or Copy dialog box

17. Manage Worksheets - continued To rename a worksheet: • Right-click sheet tab. • Click Rename option at. • Type desired name. Type the desired name

18. Manage Worksheets - continued To hide a worksheet: • Click Format button. • Point to Hide & Unhide. • Click Hide Sheet. OR • Right-click worksheet tab. • Click Hide at shortcut menu. Hide Sheet option

19. Manage Worksheets - continued To unhide a worksheet: • Click Format button. • Point to Hide & Unhide. • Click Unhide Sheet. • Double-click desired hidden worksheet in Unhide dialog box. OR • Right-click worksheet tab. • Click Unhide at shortcut menu. • Double-click desired hidden worksheet in Unhide dialog box. Unhide dialog box

20. Manage Worksheets - continued To print all worksheets in a workbook: • Click FILE tab. • Click Print option. • Click first gallery in Settings category. • Click Print Entire Workbook. • Click Print button. Print Entire Workbook option

21. Manage Worksheets - continued • The VIEW tab contains a Zoom group with three buttons to change zoom settings. • Click the Zoom button in the Zoom group to open the Zoom dialog box, which contains options for changing the zoom percentage. • Click the 100% button in the Zoom group to return the view to 100%, which is the default. • Select a range of cells and then click the Zoom to Selection button to cause Excel to scale the zoom setting so that the selected range fills the worksheet area.

22. Manage Worksheets - continued To split a worksheet: • Click VIEW tab. • Click Split button. Split button

23. Manage Worksheets - continued To freeze panes: • Click Freeze Panes button. • Click Freeze Panes option at drop-down list. Freeze Panes option

24. CHECKPOINT1 • By default a workbook contains how many worksheets? • 3 • 2 • 1 • 4 • Press these keys to insert a new worksheet. • Ctrl + F1 • Shift + F1 • Ctrl + F11 • Shift + F11 Answer Answer Next Question Next Question • This is the name of the moving dashed line border that displays when you click the Cut button to move selected cells. • marquee • gridlines • selector • outline • To select adjacent worksheet tabs, click the first tab, hold down this key, and then click the last tab. • Shift • Ctrl • Alt • F1 Answer Answer Next Question Next Slide

25. Work with Ranges To name a range: • Select cells. • Click in Name box. • Type range name. • Press Enter. Name box

26. Work with Ranges - continued To name a range at the New Name dialog box: • Select desired cells. • Click Define Name button. • At New Name dialog box, type range name. • Click OK. New Name dialog box

27. Work with Ranges - continued To move to a specific range: • Click down-pointing arrow at right side of Name box. • Click range name. range name

28. Work with Ranges - continued • A name range can be used in a formula. range name in a formula

29. Work with Windows • With multiple workbooks open, you can move or copy information between workbooks or compare the contents of several workbooks. • When you open a new workbook, it is placed on top of the original workbook. • Once multiple workbooks are opened, you can resize the workbooks to see all or a portion of them on the screen.

30. Work with Windows - continued To switch windows: • Click VIEW tab. • Click Switch Windows button. • Click desired workbook name at drop-down list. Switch Windows button

31. Work with Windows - continued To arrange workbooks: • Click VIEW tab. • Click Arrange All button. • At Arrange Windows dialog box, click desired arrangement. • Click OK. Arrange Windows dialog box

32. Work with Windows - continued tiled workbooks

33. Work with Windows - continued cascaded workbooks

34. Work with Windows - continued • With the Hide button in the Window group on the VIEW tab, you can hide the active workbook. • If a workbook has been hidden, redisplay the workbook by clicking the Unhide button in the Window group on the VIEW tab.

35. Work with Windows - continued To maximize a workbook: • Click Maximize button. Maximize button

36. Move, Copy, and Paste Data To copy text to another workbook: • Select desired text from active workbook. • Click Copy button. • Click Excel button on Taskbar and then click desired workbook thumbnail. • Make desired cell active. • Click Paste button. Excel button

37. Move Data To link data between worksheets: • Select cells. • Click Copy button. • Click desired worksheet tab. • Click in desired cell. • Click Paste button arrow. • Click Paste Link at drop-down list. Paste Link button

38. Move Data - continued • Microsoft Office is a suite that allows integration, which is the combining of data from two or more programs into one file. • Integration can occur by copying and pasting data between programs. Paste Options

39. CHECKPOINT 2 • A selected group of cells is referred to as this. • an area • a group • an object • a range • The Switch Windows button is located on this tab. • HOME • PAGE LAYOUT • REVIEW • VIEW Answer Answer Next Question Next Question • Open multiple workbooks at one time at this dialog box. • Open • Save As • Page Setup • Page Layout • When linking data, the worksheet that contains the original data is called this. • source • dependent • destination • original Answer Answer Next Question Next Slide

40. Moving Data within and between Workbooks • Create a workbook with multiple worksheets • Move, copy, and paste cells within a worksheet • Use zoom, split a worksheet into windows, and freeze panes • Name a range of cells and use a range in a formula • Open multiple workbooks • Arrange, size, and move workbooks • Copy and paste data between workbooks • Link data between worksheets Summary of Presentation Concepts