Viewing & printing worksheets in Excel 365 (2023)

Excel 365 (2023)    |    Beginner
  • 11 videos | 45m 26s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.0 of 4 users Rating 4.0 of 4 users (4)
In Excel, you can change the way you view your worksheet data depending on your purpose. You can also print worksheets for others to see. This course covers various techniques for viewing and printing worksheets in Excel 365. The first part of the course covers different ways to view your worksheet. You will see how to adjust row and column dimensions. You will discover how to view and arrange multiple windows. You will also see how to view different parts of a worksheet at once by freezing panes and splitting worksheets, as well as how to view your worksheet in Full-Screen Mode, Page Layout View, and Page Break Preview. The second part of the course covers techniques to help you optimize your worksheet for printing. You will learn how to adjust the print page layout, set print areas, and configure layout for multiple pages. See also how to insert headers and footers, and configure print settings. This course aligns with the objectives of Exam MO-210: Microsoft Excel (Microsoft 365 Apps). Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in the viewing & printing worksheets in excel 365 course
    Adjust row height and column width
    View and arrange workbook sheets in multiple windows
    Freeze worksheet rows and columns and split worksheets
    Activate full-screen mode and switch between normal, page break, and page layout views
    Adjust the print page layout
  • Set a print area
    Add page breaks and set print titles
    Insert headers and footers
    Add headers and footers to multiple worksheets and apply custom header and footer options
    Configure print settings

IN THIS COURSE

  • 1m
    This video outlines the key content covered in the Viewing & printing worksheets in Excel 365 course, including Viewing multiple windows, Freezing panes and Configuring your print job in Excel 365. FREE ACCESS
  • 5m 14s
    Changing the row height and column width can enhance your column's aesthetics and readability. In this tutorial, you will see how to manually adjust row height and column width, as well as how to use the AutoFit feature. This video aligns with MO-210 Microsoft Excel Exam objective: Adjust row height and column width. FREE ACCESS
  • Locked
    3.  Viewing multiple windows in Excel 365
    3m 55s
    When you are working with a large spreadsheet, it can be helpful to view the same workbook in multiple windows. In this tutorial, you will see how to create and work with multiple windows at the same time. This video aligns with MO-210 Microsoft Excel Exam objective: Change window views. FREE ACCESS
  • Locked
    4.  Freezing panes & splitting worksheets in Excel 365
    4m 49s
    Scrolling through large worksheets can be tedious, but the Freeze Panes and Split tools can make it easier. In this video, you will see how to freeze panes to lock headers and other rows or columns in place as you scroll. You will also see how to split your worksheet into multiple scrollable areas. This video aligns with MO-210 Microsoft Excel Exam objectives: Freeze worksheet rows and columns, and Change window views. FREE ACCESS
  • Locked
    5.  Changing the workbook view in Excel 365
    4m 51s
    In Excel, you can choose from multiple views to help you visualize and edit your data in the most efficient way possible. In this video, you will see how to activate Full-Screen Mode to maximize your workspace. You will also see how to use Page Layout View and Page Break Preview to help you optimize your worksheet for printing as well as how to save a custom view. This video aligns with MO-210 Microsoft Excel Exam objective: Display and modify workbook content in different views. FREE ACCESS
  • Locked
    6.  Adjusting the print page layout in Excel 365
    4m 36s
    Before printing a worksheet, you will want to make sure it is laid out according to your needs. In this video, you will explore how to adjust various aspects of page layout, including margins, orientation, and paper size. This video aligns with MO-210 Microsoft Excel Exam objective: Modify page setup. FREE ACCESS
  • Locked
    7.  Setting a print area in Excel 365
    4m 30s
    When you work with large worksheets, you may only want to print a specific area. In Excel, you can easily set and adjust the print area. You can also use the Page Break View to visualize the print area. See how in this tutorial. This video aligns with MO-210 Microsoft Excel Exam objective: Set a print area. FREE ACCESS
  • Locked
    8.  Configuring layout for multiple pages in Excel 365
    4m 4s
    In Excel, you can split a large spreadsheet across multiple pages. In this tutorial, you will find out how to split the print area across pages, insert and adjust page breaks, and set print titles. This video aligns with MO-210 Microsoft Excel Exam objective: Set a print area. FREE ACCESS
  • Locked
    9.  Inserting headers & footers in Excel 365
    4m 47s
    You can use headers and footers to display the author, date, or other information in your printed spreadsheet. In this video, you will see how to add headers and footers using Excel's built-in formats. This video aligns with MO-210 Microsoft Excel Exam objective: Customize headers and footers. FREE ACCESS
  • Locked
    10.  Customizing headers & footers in Excel 365
    3m 49s
    Excel provides a number of options for customizing headers and footers. You can group worksheets to apply headers or footers to multiple sheets at once. You can also use the Page Setup dialog box to access options for personalizing headers and footers, including formatting font and images. Find out more in this tutorial. This video aligns with MO-210 Microsoft Excel Exam objective: Customize headers and footers. FREE ACCESS
  • Locked
    11.  Configuring your print job in Excel 365
    3m 51s
    Once you have set up the page layout to your liking, you are ready to print. In this tutorial, you will see how to configure print options and submit your print job. This video aligns with MO-210 Microsoft Excel Exam objective: Configure print settings. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Exploring essential functions in Excel 365 (2023)
Rating 4.9 of 7 users Rating 4.9 of 7 users (7)
Course Enhancing a worksheet with visual elements in Excel 365 (2024)
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Course Using Custom and Conditional Formatting in Excel 365 (2024)
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course A Difficult Boss Doesn't Have to Be a Difficult Problem
Rating 4.4 of 925 users Rating 4.4 of 925 users (925)
Course Getting started in Excel 365 (2023)
Rating 3.5 of 57 users Rating 3.5 of 57 users (57)
Course Earning and Offering Trust at Work
Rating 4.6 of 2318 users Rating 4.6 of 2318 users (2318)