Chapter 1

Learning the Secrets of the Excel:Mac Interface

1In this chapter, you'll learn the ins and outs of the Excel:Mac interface and the many secrets it holds.

We'll start by looking at the four main ways to control Excel: the Ribbon, the toolbars, the menus on the menu bar, and keyboard shortcuts. These give you great flexibility in the way you control Excel, especially when you set them up as you prefer.

From there, we'll discuss how to navigate through worksheets and workbooks. We'll then go through the various ways in which you can get data into your Excel workbooks—from importing existing data to entering it more quickly using AutoCorrect, AutoFill, and the Scrapbook.

Toward the end of the chapter, I'll show you the smart ways to view your workbooks so you can work quickly and efficiently. These include splitting the window to show different parts of the worksheet at the same time, opening extra windows, and freezing key rows and columns so that they stay onscreen when you scroll to other parts of the worksheet. You can even create custom views to keep your data laid out exactly as you need it.