From the course: Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Configure page setup and headers/footers

Configure page setup and headers/footers

From the course: Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)

Start my 1-month free trial

Configure page setup and headers/footers

“

- [Instructor] You'll probably see quite a few questions on the MOS exam regarding formatting and configuring your worksheets and workbooks. In this video we're going to review how to set up worksheet margins and take it a step further. We're going to learn how we can change the header and footer margins. We'll also look at worksheet orientation, changing it from portrait to landscape and vice versa, and also how to insert headers and footers. I have the 02_04 exercise file open, so let's get started. First let's look at what's available under the page layout tab for page setup. Here's our page setup group. Starting on the left-hand side we have margins: normal, wide, narrow, and then of course we can set up our own custom margins. On the exam you may have a task as simple as change the margins of a worksheet to wide, and this is all you need to do is come here and choose wide. Orientation we can change it from portrait to landscape, and the other item that we'll look at is on the…

Contents