Getting Started with Excel 2007

View:  
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…]

Comparing Two Excel 2007 Worksheets Side by Side

You can use the View Side by Side command button on the View tab in Excel 2007 to quickly and easily do a side-by-side comparison of any two worksheet windows that you have open. When you click this button [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…]

Using Paste Special in Excel 2007

Microsoft Office Excel 2007 normally copies all the information in the range of cells you select when you paste the data. Use Excel's Paste Special command to specify other options, such as pasting only [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…]

Freezing Panes in an Excel 2007 Worksheet

The Freeze Panes command in Excel 2007 enables you to freeze portions of a worksheet, typically column and row headings, so that you can view distant parts of the worksheet while the headings remain in [more…]

How to Insert Symbols and Special Characters in Excel 2007

Excel 2007 makes it easy to enter symbols, such as foreign currency indicators, as well as special characters, like trademark and copyright symbols, into Excel's cells. These symbols are available in the [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…]

Sorting Excel 2007 Data on a Single Column

You may find data in an Excel 2007 worksheet easier to view if it’s sorted on a particular column, in ascending or descending order. Excel sorts in the following pattern: numbers, spaces, special characters [more…]

Inserting Cells, Rows, or Columns in Excel 2007

If you need to add new data within an existing Microsoft Office Excel 2007 worksheet, you can insert new cells, columns, or rows rather than going through all the trouble of moving and rearranging several [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…]

Deleting Cells and Data in Excel 2007

In Microsoft Office Excel 2007, when you need to delete data, remove formatting in a cell selection, or remove entire cells, rows, or columns, you have many options depending on your objective. Excel can [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…]

How to Save an Excel 2007 Workbook

As you work in Microsoft Office Excel 2007, remember to save your work often or you risk losing your Excel data if the computer crashes or the power goes out. When you save a workbook for the first time [more…]

Get Excel Help for Excel 2007

If you get stuck and have questions about Microsoft Office Excel 2007 features, you can use the Excel Help window to quickly find Excel 2007 help. The Excel Help button — the button with a question mark [more…]

Starting and Exiting Excel 2007

Microsoft Office Excel 2007 provides several methods for starting and exiting the program. You can open Excel by using the Start menu or a desktop shortcut. When you want to exit Excel, you can do so by [more…]

How to Check Your Spelling in Excel 2007

Microsoft Office Excel 2007 includes a built-in spell checker that can catch and get rid of spelling errors and typos in your worksheets. Excel 2007's spell checker normally looks for misspellings only [more…]

Creating a New Workbook in Excel 2007

If you’re working in Microsoft Office Excel 2007 and want to begin work in a new Excel file, you can easily create a new workbook. To do so, you can use a command on the Office menu or a keyboard shortcut [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 and Replacing Data in Excel 2007

Excel 2007's Find and Replace feature can be a powerful tool. Use Find and Replace to locate — and optionally replace — text or values in a worksheet. You can narrow the search results by specifying formatting [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…]

Listings:1-2526-5051-53

Sign Up for RSS Feeds

Computers & Software
Great Gadget Giveaway -- Enter to Win!

Inside Dummies.com