Advertisement
Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

Microsoft Excel

View:  
Sorted by:  

How to Add Titles to Excel 2007 Charts

You can add titles to a chart to help describe its purpose. By default, titles are not added when you create a basic chart, but you can add them later manually. In addition to a main chart title that is [more…]

Formatting a Pivot Table in Excel 2007

Excel 2007 makes formatting a new pivot table you’ve added to a worksheet as quick and easy as formatting any other table of data. The PivotTable Tools Design tab includes special formatting options for [more…]

Managing Range Names in Excel 2007

If you’ve created a number of range names in an Excel 2007 worksheet, you can use the Name Manager to work with these names. The Name Manager provides a list of all names assigned in the current workbook [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…]

How to Apply Fill Colors, Patterns, and Gradients to Cells in Excel 2007

You can add emphasis to selected cells in an Excel 2007 worksheet by changing the fill color or applying a pattern or gradient effect to the cells. If you’re using a black-and-white printer, restrict your [more…]

Rounding Numbers in Excel 2007 with ROUND, ROUNDUP, and ROUNDDOWN

The mathematical functions ROUND, ROUNDUP, and ROUNDDOWN are included in the Math & Trig category in Excel 2007. You'll find these by clicking the Math & Trig button on the Ribbon’s Formulas tab or in [more…]

Changing Chart Elements in Excel 2007

The command buttons on the Chart Tools Layout tab in Excel 2007 make it easy to change or customize particular parts of your chart. This customization includes buttons in the following groups on the Layout [more…]

How to Build an Array Formula in Excel 2007

Remember that an array formula is a special formula that operates on a range of values. When you build an array formula in a worksheet, you use the Ctrl+Shift+Enter keyboard shortcut to insert an array [more…]

How to Change the Print Margins in Excel 2007

Print margins indicate how much white space Excel 2007 places between the worksheet data and the edge of the page. The Normal margin settings that Excel applies to a new workbook use top and bottom margins [more…]

Adjusting Page Breaks in Excel 2007

The Page Break Preview feature in Excel 2007 enables you to spot page break problems in an instant as well as fix them, such as when the program wants to split onto different pages information that you [more…]

Merging and Splitting Cells in Excel 2007

You can merge and center data horizontally or vertically across multiple cells in Excel 2007. You also can unmerge or split a merged cell into its original, individual cells. A common use of merge and [more…]

Splitting Data into Multiple Columns in Excel 2007

Use the Convert Text to Columns Wizard in Excel 2007 when you need to split combined data into separate columns, such as a first name and last name; or city, state, and zip code. This type of combined [more…]

Sorting Excel 2007 Data on Multiple Columns

If your Excel 2007 worksheet has become quite large, using the Sort dialog box to sort on multiple columns can make it easier to find the data you need. The Sort dialog box lets you tell Excel what column [more…]

Inserting Subtotals in an Excel 2007 Worksheet

You can use Excel 2007’s Subtotals feature to subtotal data in a sorted list. To subtotal a list, you first sort the list on the field for which you want the subtotals, and then you designate the field [more…]

Modifying a Pivot Table's Summary Function in Excel 2007

By default, Excel 2007 uses the SUM function to create subtotals and grand totals for the numeric field(s) that you assign as the Data Items in a pivot table. Some pivot tables, however, require the use [more…]

How to Hide and Unhide Rows and Columns in Excel 2007

You can hide and unhide rows or columns in Excel 2007 when you don’t want part of the worksheet to be visible or when you don’t want certain data (such as salary information) to appear in printed reports [more…]

How to Change a Cell's Number Format in Excel 2007

Excel 2007 provides a variety of number formats that you can apply to the values (numbers) you enter in a worksheet to make the data easier to interpret. These number formats include currency, accounting [more…]

Adding an Excel Chart to a Word 2007 Document

When you insert a chart in Word, Excel is automatically started, and the data that you chart is placed in an Excel workbook. However, that Excel workbook isn?t stored as a separate document. Instead, the [more…]

Protecting Cell Data in Excel 2007

After you finalize an Excel 2007 worksheet by reviewing formulas and proofing text, you should consider protecting the document to guard against any unplanned changes. Each cell in the worksheet can be [more…]

Creating and Formatting a Pivot Chart in Excel 2007

After you create a pivot table in Excel 2007, you can create a pivot chart to display its summary values graphically. You also can format a pivot chart to improve its appearance. You can use any of the [more…]

Customizing the Type and Style of an Excel 2007 Chart

When you add a chart to an Excel 2007 workbook, a new Chart Tools Design tab appears in the Ribbon. You can use the command buttons on the Chart Tools Design tab to customize the chart type and style. [more…]

Switching Vertical and Horizontal Data with Excel 2007's TRANSPOSE Function

Excel 2007's TRANSPOSE function enables you to change the orientation of a cell range (or array). You can use this function to transpose a vertical cell range where the data runs down the rows of adjacent [more…]

Navigating Excel 2007's Worksheet Tabs

Each new workbook you open in Excel 2007 contains three blank worksheets, although you can add many more. You can easily move between the worksheets in an Excel workbook by using the sheet tabs, the Sheet [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…]

Listings:1-2526-5051-7576-100more...
Advertisement

Sign Up for RSS Feeds

Computers & Software
Win an iPad Mini! Enter to win now.

Inside Dummies.com

Dummies.com Sweepstakes

Win an iPad Mini. Enter to win now!