1 / 18

Lesson 20: Working with Large Worksheets

Lesson 20: Working with Large Worksheets. Learning Objectives. After studying this lesson, you will be able to: Sort worksheet rows in alphabetic and numeric order View nonadjacent areas of large worksheets and view multiple worksheets simultaneously

makya
Download Presentation

Lesson 20: Working with Large Worksheets

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. Lesson 20: Working with Large Worksheets

  2. Learning Objectives • After studying this lesson, you will be able to: • Sort worksheet rows in alphabetic and numeric order • View nonadjacent areas of large worksheets and view multiple worksheets simultaneously • Set printing options to center and fit the worksheet on one page • Set options to print a worksheet on multiple pages

  3. Sorting by a Single Column • Sort buttons • Sort by one column only Ascending Descending Tip! If a sorting problem occurs, close without saving and revert to presorted data.

  4. Sorting Selected Rows • Select rows to sort if: • No blank row separates the list from a total row • The list contains other rows that should not be sorted • Select entire rows, not individual cells • Sort if based on column A

  5. Sorting by Multiple Columns • Data Sort & Filter Sort Sort by any number of columns Any same last names are then sorted by first name Sort each column in ascending or descending order

  6. Freezing Rows and Columns Leaves column A visible when scrolling right Leaves row 1 visible when scrolling down Tip! Use Freeze Panes to lock the headings in worksheets containing more rows or columns than can fit on one screen.

  7. Splitting the Worksheet Window • View different sections (window panes) of a worksheet at the same time Separate scroll bars for vertical panes Separate scroll bars for horizontal panes

  8. Viewing in Multiple Windows • Choose and control options via the Window group in the View Ribbon Once you have a workspace set up in a way that is functional, you can save it for future use Choose to have the multiple windows scroll together

  9. Page Layout View • Display results of changes to print options You can add headers and footers in Page Layout view

  10. Page Layout Ribbon Portrait Landscape Paper size Page Setup dialogbox launcher Page Setup tab in the Page Layout Ribbon

  11. Margins Tab (Page Setup Dialog Box) Change worksheet or header/footer margins Center worksheet

  12. Scaling Options • Shrink data to fit fewer printed pages • Change width and height in proportion • Change just the height when the worksheet is very wide

  13. Predesigned Headers and Footers • Header • Prints at the top of every page • Footer • Prints at the bottom of every page • Choose predesigned items from the list

  14. Custom Headers and Footers Combination of text and codes Code only Text only

  15. Setting Title Rows and Columns Selected rows and columns to print on all pages Page 1 Page 2

  16. Sheet Options No gridlines Gridlines With headings

  17. Page Break Preview Displays page numbers

  18. Lesson 20: Working with Large Worksheets

More Related