Understanding the Interface

Sorted by:  

Using Built-in Add-In Programs in Excel 2007

Add-in programs are small modules that extend the power of Excel 2007 by giving you access to a wide array of features and calculating functions not otherwise offered in the application. There are three [more…]

How to Add an Excel 2007 Macro to the Quick Access Toolbar

You can assign a macro created in Excel 2007 to a custom button on the Quick Access toolbar and then run it by clicking that button. This provides quicker access to a macro than using the Macro dialog [more…]

Scrolling through an Excel 2007 Worksheet

You can use the horizontal scroll bar in Microsoft Office Excel 2007 to scroll left and right in a worksheet and the vertical scroll bar to scroll up and down. The horizontal scroll bar appears at the [more…]

Finding Commands on the Excel 2007 Ribbon Tabs

The Ribbon in Microsoft Office Excel 2007 contains seven tabs. Contextual tabs also appear when you’re working with a particular object that you select in the worksheet, such as a graphic image, chart, [more…]

Figuring Out the Excel 2007 Formula Bar

The Formula bar in Microsoft Office Excel 2007 displays the cell address and the contents of the current cell. Use the Formula bar to enter or edit formulas and cell entries and assign names to cells. [more…]

Shortcuts for Moving the Cell Cursor in Excel 2007

Microsoft Office Excel 2007 offers a variety of keyboard shortcuts for selecting a new cell. When you use one of these keystrokes, the program automatically scrolls a new part of the worksheet into view [more…]

Selecting Cells in Excel 2007

Before you can enter your worksheet data in Microsoft Office Excel 2007, you must know how to select cells in a worksheet. The cell cursor is a black border that surrounds the active cell [more…]

Working in Excel 2007’s Page Layout View

Excel 2007’s new Page Layout gives you an instant view of how the printed Excel page will look. You activate this view by clicking the Page Layout View button [more…]

Customizing the Excel 2007 Quick Access Toolbar

The Quick Access toolbar in Microsoft Office Excel 2007 appears above the Ribbon, to the right of the Office button, and includes buttons for commands you use often. By default, the Quick Access toolbar [more…]

Working with the Excel 2007 Mini Toolbar

Microsoft Office Excel 2007 makes it easy to apply common formatting changes to a cell selection right within the Worksheet area, thanks to its new mini toolbar feature. [more…]

Select Excel 2007 Commands with Keyboard Shortcuts

In Microsoft Office Excel 2007, you can select commands on the Ribbon by using keyboard shortcuts. Press the Alt key followed by letter keys displayed on the Ribbon to select the desired Excel command [more…]

Finding the Formatting Toolbar Button Equivalents in Excel 2007

Finding the Excel 2007 Ribbon equivalents for the buttons that were on the Formatting toolbar in earlier versions of Excel is easy. Each button on the Formatting toolbar is prominently displayed on the [more…]

Automatically Fix Typos and Add Text with Excel 2007's AutoCorrect Feature

Excel 2007's AutoCorrect feature already knows to automatically fix two initial capital letters in an entry, to capitalize the names of the days of the week, and to replace a set number of text entries [more…]

How to Add Excel 2007 to the Windows Vista Quick Launch Toolbar

If you want to start Microsoft Office Excel 2007 by clicking a single button, you can add the Excel icon to the Quick Launch toolbar. The Quick Launch toolbar resides to the immediate right of the Start [more…]

Examining the Excel 2007 Status Bar

The Status bar appears at the bottom of the Microsoft Office Excel 2007 window and keeps you informed of Excel’s current mode and any special keys you engage. In addition, you can use the status bar to [more…]

Introducing the Excel 2007 Ribbon

The Ribbon interface in Microsoft Office Excel 2007 radically changes how you work. You no longer need to find on which pull-down menu or toolbar a command resides. Instead, the Ribbon shows you the most [more…]

How to Use Excel 2007’s Research Task Pane

Excel 2007 includes the Research task pane that you can use to search for information from online resources, such as the Encarta Dictionary, Thesaurus, MSN Money Stock Quotes, and the Encarta Encyclopedia [more…]

Manipulating the Excel 2007 Office Button

In the top-left corner of the Excel 2007 window, you find the Office button (the round button with the Office four-color icon), which provides access to common file-related commands. The Office button [more…]

Using Contextual Tools in Excel 2007

Microsoft Office Excel 2007 displays contextual tools with tabs and commands that help you work with a particular object that you select in the worksheet — such as a graphic image you’ve added or a chart [more…]

Navigating the Excel 2007 Ribbon

The new Ribbon interface in Microsoft Office Excel 2007 may seem a bit tricky to navigate, until you get used to how commands are organized. You can use the Office button — the large, round button in the [more…]

How to Create a New Custom Dictionary in Excel 2007

In Excel 2007, you can create custom dictionaries to use when spell checking your worksheets. You use the Add to Dictionary button in the Spelling dialog box to add unknown words to a custom dictionary [more…]

Translating Text in Excel 2007

Microsoft Office Excel 2007 provides access to translation tools on the Research task pane that enable you to translate words or phrases by using bilingual dictionaries. [more…]

Exploring the Excel 2007 Program Window

When you start Microsoft Office Excel 2007, you see the first of three worksheets (named Sheet1) in a workbook file (named Book1) inside a program window. The Excel 2007 program window is made up of the [more…]

How to Use the Thesaurus in Excel 2007

Excel 2007 includes access to a thesaurus via the Research task pane if you need to find a word with a similar meaning to a word that exists in your worksheet. Using the thesaurus is pretty easy. [more…]

How to Access Common View Commands in Excel 2007

You can look at the worksheets you create with Excel 2007 from any number of perspectives. You can change the view so that you see — or don’t see — page breaks, grid lines, and dialog boxes, and you can [more…]


Sign Up for RSS Feeds

Computers & Software
Win $500. Enter Now.

Inside Dummies.com