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.

Customize options and views for worksheets and workbooks

Customize options and views for worksheets and workbooks

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

Start my 1-month free trial

Customize options and views for worksheets and workbooks

“

- [Instructor] Knowing how to customize options and views in Excel 2016 is going to be really important on the MOSC exam. We have several topics that we're going to talk about in this video. We'll start off by hiding and unhiding elements such as worksheets, rows, and columns. Then we're going to talk about how to customize the Quick Access Toolbar. I'll show you how you can quickly add commands that you use all the time to the Toolbar so they'll always be available to you. We'll look at how we can freeze panes, so if as we scroll down, we want to make sure our column headings stay up at the top, so we'll always know what information we're reviewing. We can freeze both rows and columns. We'll also talk about document properties. I'll show you which properties Excel tracks automatically for us, and which properties we can manually insert into our documents. As we work through each of these topics, we'll focus on the information that you'll need to know so that you can prepare for the…

Contents