1 / 17

EXCEL 2007

EXCEL 2007. Part 4. Today’s Lesson. Search & Replace Sorting Data Copying, Moving and Deleting Within a Worksheet Between Worksheets Cell(s) Between Active Workbooks Fill Handle Copy/Increment Data Series of Items. Ribbon Groups Used – Home & View TAB. Clipboard. Search & Sort.

ondrea
Download Presentation

EXCEL 2007

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 2007 Part 4

  2. Today’s Lesson • Search & Replace • Sorting Data • Copying, Moving and Deleting • Within a Worksheet • Between Worksheets • Cell(s) • Between Active Workbooks • Fill Handle • Copy/Increment Data • Series of Items

  3. Ribbon Groups Used – Home & View TAB Clipboard Search & Sort View Tab - Windows

  4. Search & Replace • Find specific occurrences of data • Find • Find Next • Find All • Replace • Replace All

  5. Exercise • Open replace.xlsx workbook • Using Find Next/Replace (one at a time) change • ‘Dinner’ to ‘Lunch’ • How many replacements? • Using Replace All (all at once) change • ‘Gaeilge’ to ‘Irish’ • How many replacements? • Save as replace1.xlsx

  6. Sorting a Cell Range • Ascending • A to Z • Lowest to Highest • Descending • Z to A • Highest to Lowest • Sort Dialogue Box • Sort by 2 criteria Note: To sort data with empty rows/columns or a section of data you must select the range of cells that contain the data first.

  7. Custom Sort Add Levels Headers First Level

  8. Exercise • Open sorting.xlsx workbook • Surnames are sorted in Ascending Order but Liam Kelly should not be before Brian Kelly • Use Custom Sort to sort by Surname and then First Name • Practice sorting in ascending/descending order based on student marks • Save as sorting1.xlsx

  9. Copying & Moving Within a Worksheet Between Worksheets Same as between cells Before pasting click a worksheet tab to open the new worksheet • Copy a range of cells • Select / Copy / Paste • Paste Options • Used for paste options

  10. SHORTCUTS: Copy = Ctrl + C Paste = Ctrl + V Move = Ctrl + X Paste = Ctrl + V

  11. Deleting Cells Right Click Shortcut Menu Delete or Clear Contents • Select cell or range of cells • Press the Delete key

  12. Exercise • Open copymove.xlsx workbook • Use Copy/Move commands to get the spreadsheet to look like the one handed out • Delete contents of cells B19:E20 • Copy contents to a new worksheet • Name worksheets as ‘Timetable’ and ‘Timetable Copy’ • Save as copymove1.xlsx

  13. Copying/Moving between Workbooks • Similar to within a Workbook • Must have both Workbooks open • Switch between active workbooks by clicking the workbook in the View Tab - Windows Group

  14. Exercise • Open copy1.xlsx workbook • Open copy2.xlsx workbook • Copy the contents of cell range A4:F14 of copy1.xlsx • Paste into copy2.xlsx, starting in cell A4 • Save as copy2.xlsx as copy3.xlsx

  15. Fill Handle Copy/Increment Series of Items Use Auto Fill Options Menu Or Use Ctrl key as you drag • Default setting to copy data as well as formatting to adjacent cells

  16. Exercise • Open fill.xlsx workbook • Using the fill handle, copy data into their appropriate cells (as per handout) • Save as myfill.xlsx

More Related