From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Format worksheets and workbooks
From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Format worksheets and workbooks
- [Instructor] After creating a workbook and entering your data into worksheets, you may want to modify the structure or layout of the worksheets in your workbook. After watching this video, you'll know how to modify page setup, adjust row height and column width, and modify workbooks. Let's jump right into our Format document and take a look at the data on the New Customers worksheet. This information may be displayed better if our layout was in Landscape view. Let's go to our Page Layout tab and take a look at the orientation that is currently set for this worksheet. It looks like it's Portrait. Let's go ahead and change it to Landscape. There. That gave us a little more room on our page. And I want you to notice over between columns H and I that there's a dashed vertical line. That's telling me where my current page break is. If I go over to Margins, I can see that they are set to Normal with a left and a right margin of 0.7 inches. Let's go ahead and change that to Narrow, which…
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
-
(Locked)
Import TXT or CSV data into an existing workbook3m 7s
-
(Locked)
Search for data within a workbook2m 36s
-
(Locked)
Navigate data with named ranges and hyperlinks5m 27s
-
(Locked)
Format worksheets and workbooks5m 1s
-
(Locked)
Customize headers and footers4m 37s
-
(Locked)
Display and modify content in different views5m
-
(Locked)
Modify basic workbook properties2m 33s
-
(Locked)
Customize the Quick Access Toolbar3m 55s
-
(Locked)
Inspect and export workbooks6m 33s
-
(Locked)
Configure print settings4m 15s
-
(Locked)
Challenge: Manage worksheets and workbooks1m 10s
-
(Locked)
Solution: Manage worksheets and workbooks9m 10s
-
-
-
-
-
-
-