From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Display and modify content in different views
From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Display and modify content in different views
- In this video, we will look at different ways we can customize our worksheet views. We'll learn to display and modify workbook content in different ways, freeze worksheet rows and columns, change window views and display formulas. Let's jump right into our views workbook and take a look at our Q1 2019 internet orders worksheet. We'll take a look at the different views we have available to us under our view tab. Usually we work in normal view, but we can view the information in page break preview. This will show us how the document will print if we printed it without doing any formatting. And we see that columns A through F would be on one page. And G and H would be on a separate page. We also see the bottom page break between rows 42 and 43. If I want to adjust this so that all the columns fit on the page, I can manually move this page break by clicking and dragging it over to the right side of the order amount column. We also have page layout available to us. In page layout view…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
Import TXT or CSV data into a new workbook3m 22s
-
Import TXT or CSV data into an existing workbook3m 7s
-
Search for data within a workbook2m 36s
-
Navigate data with named ranges and hyperlinks5m 27s
-
Format worksheets and workbooks5m 1s
-
Customize headers and footers4m 37s
-
Display and modify content in different views5m
-
Modify basic workbook properties2m 33s
-
Customize the Quick Access Toolbar3m 55s
-
Inspect and export workbooks6m 33s
-
Configure print settings4m 15s
-
Challenge: Manage worksheets and workbooks1m 10s
-
Solution: Manage worksheets and workbooks9m 10s
-
-
-
-
-
-
-