Setting Up Your Excel Environment

Before you start using Excel 2007 you should familiarize yourself with it. Learn all about getting started with Excel here.

Introduction

Excel 2007Before you begin creating spreadsheets in Excel, you may want to set up your Excel environment and become familiar with a few key tasks and features, like how to minimize and maximize the Ribbon, configure the Quick Access toolbar, switch page views, and access your Excel options.

Exploring and setting up your Excel environment

Exploring the Excel environment

The tabbed Ribbon menu system is how you navigate Excel and access its various commands. If you have used previous versions of Excel, the Ribbon system replaces the traditional menus. Above the Ribbon in the upper-left corner is the Microsoft Office button. From here, you can access important options such as New, Save, Save As, and Print. By default, the Quick Access toolbar is pinned next to the Microsoft Office button and includes commands such as Undo and Redo.

At the bottom-left area of the spreadsheet, you will find worksheet tabs. By default, three worksheet tabs appear each time you create a new workbook. On the bottom-right area of the spreadsheet you will find page view commands, the zoom tool, and the horizontal scrolling bar.

Excel Window

To zoom in and out:

Zoom

To scroll horizontally in a worksheet:

To change page views:

Page Views

The default is Normal View.

To add commands to the Quick Access toolbar:

Quick Access toolbar


OR

The Save, Undo, and Redo commands appear by default in the Quick Access toolbar. You may wish to add other commands to make using specific Excel features more convenient for you.

To minimize and maximize the Ribbon:

Maximize and Minimize Ribbon

You can also minimize and maximize the Ribbon by right-clicking anywhere in the main menu and selecting Minimize the Ribbon in the menu that appears.

The new, tabbed Ribbon system replaces traditional menus in Excel 2007. It is designed to be easy to use and responsive to your current task; however, you can choose to minimize the Ribbon if you would prefer to use different menus or keyboard shortcuts.

The Microsoft Office button

The Microsoft Office button appears at the top of the Excel window. When you left-click the button, a menu appears. From this menu, you can create a new spreadsheet, open existing files, save files in a variety of ways, and print. You can also add security features, send, publish, and close files.

Button

To change the default Excel Options:

Excel Options

As you learn more about Excel and become proficient at using it, you may want to modify some of the settings. As a beginning user, it is usually best to leave the default settings.

Challenge!