In: Categories » » Microsoft office » Using The AutoSum command in Excel 2007
One of the most useful and commonly used command is the AutoSum command. The AutoSum command uses the SUM function to add two or more cell references without making you type those cell references yourself. The most common use for the AutoSum function is to add a column or row of numbers. To add a column or row of numbers with the AutoSum function, follow these steps:
1. Create a column or row of numbers that you want to add.
2. Click at the bottom of the column or the right of the row.
3. Click the Formulas tab.
4. Click the AutoSum icon in the Function Library group. Excel automatically creates a SUM function in the cell you chose in Step 2 and highlights all the cells where it will retrieve data to add. (If you accidentally click the downward-pointing arrow under the AutoSum icon, a pull-down menu appears. Just choose Sum.)
5. Press Enter. Excel automatically sums all the cell references. The AutoSum icon also appears on the Home tab in the Editing group.
Using recently used functions
Digging through all the different function library menus can be cumbersome, so Excel tries to make your life easier by creating a special Recently Used list that contains (what else?) a list of the functions you’ve used most often. From this menu, you can just see a list of your favorite functions and ignore the other hundred functions that you may never need in a million years. To use the list of recently used functions, follow these steps:
1. Click the cell where you want to store a function.
2. Click the Formulas tab.
3. Click the Recently Used icon in the Function Library group. A pull-down menu appears.
4. Choose a function. Editing a Formula After you create a formula, you can always edit it later. You can edit a formula in two places:
In the Formula bar
In the cell itself
To edit a formula in the Formula bar, follow these steps:
1. Select the cell that contains the formula you want to edit. Excel displays the formula in the Formula bar.
2. Click in the Formula bar and edit your formula using the Backspace and Delete keys.
To edit a formula in the cell itself, follow these steps:
1. Double-click in the cell that contains the formula you want to edit. Excel displays a cursor in the cell you selected.
2. Edit your formula using the Backspace and Delete keys. Because formulas display their calculations in a cell, it can be hard to tell the difference between cells that contain numbers and cells that contain formulas. To make formulas visible, press Ctrl+` (an accent grave character, which appears on the same key as the ~ symbol).
legal notice
Our website is not responsible for the information contained by this article. Web-articles is a free articles resource.
Suggestion: If you need fresh, daily updated content for your website, feel free to use our service. Click here for more information.
Useful tools and features
If you like this article (tutorial), please link to it from your web page using the information above.
related articles
Cutting, copying, and pasting data may be handy within the same file, but Office 2007 also gives you the ability to cut, copy, and paste data between different programs, such as copying a chart from Excel and pasting it into a PowerPoint presentation. Using the Office Clipboard When you cut or copy any data, Windows stores it in a special part of memory called the Clipboard. This Windows Clipboard can only hold one item at a time, so Office 2007 comes with its own Clipboard called t...
2. Typing Text in Word office 2007
The whole purpose of Microsoft Word is to let you type text and make it look pretty so you can print or send it for other people to read. So the first step in using Microsoft Word is learning how to enter text in a Word file, called a document. In every document, Word displays a blinking cursor that points to where your text will appear if you type anything. To move the cursor, you can use the keyboard or the mouse. Moving the Cursor with the Mouse ...
3. Creating text in Word Office 2007
Text can consist of a single sentence, multiple sentences, or several paragraphs. Text always appears indented underneath a heading (or subheading). To create text, follow these steps: 1. Move the cursor to the end of a heading or subheading. This is the heading (or subheading) that your text will be attached to if you move the heading (or subheading). 2. Press Enter. Word creates a blank heading. 3. Click the Demote to Body Text button....
4. Proofreading Your Document Office 2007
Besides checking for spelling or grammatical mistakes, Word can also proofread your document to highlight other possible problems, such as misplaced commas or correctly spelled words that may be used incorrectly. To make Word proofread your document, follow these steps: 1. Click the Proofing icon at the bottom of the document window. Word highlights a possible error and displays a pop-up menu offering options. 2. Choose one of the following: • ...
5. Changing Colors and Justifying Text Alignment in Office 2007
Color can emphasize text. There are two ways to use color: Change the color of the text (Font color). Highlight the text with a different color (Text Highlight color). Changing the color of text When you change the color of text, you’re physically displaying a different color for each letter. Normally, Word displays text in black, but you can change the color to anything you want, such as bright red or dark green. If you choose a light color for your text, it may be hard to re...
6. Creating a new document from a template using Word Office 2007
The easiest time to use a template is before you’ve typed any text. To create a new document from a template, follow these steps: 1. Click the Office Button and then choose New. A New Document window appears. 2. Click one of the following in the left pane of the New Document window: • Installed Templates: Displays templates installed on your computer • Any category under the Microsoft Office Online heading, such as ...
7. Microsoft office 2007 Creating a table by highlighting rows and columns
Organizing Text in Tables Tables organize text into rows and columns, which can make it easy to type, edit, and format text while spacing it correctly in your document. Tables organize text in cells, where a cell is the intersection of a row and a column. Word provides four ways to create a table: Click the Insert tab, click the Table icon, and then highlight the number of rows and columns for your table (up to a maximum of eight rows and ten columns). Use the Inse...
8. Resizing columns and rows. Table styles in Microsoft office 2007
Picking a table style By coloring rows or columns and adding borders, you can customize the appearance of your tables. However, for a faster method, you can just use a predesigned table style instead, which can automatically format your text, color rows, and add borders to your tables. To choose a table style, follow these steps: 1. Move the cursor inside the table you want to modify. 2. Click the Design contextual tools tab. 3. (...
9. Creating WordArt using Office 2007
Making Text Look Artistic To spice up the appearance of individual paragraphs, Word lets you add drop caps, text boxes, or WordArt. Drop caps make the first letter of a paragraph appear huge. WordArt displays text as graphical images. Text boxes let you display chunks of text in separate boxes that you can arrange anywhere in your document. Creating drop caps To create a drop cap, follow these steps: 1. Click the Insert tab. ...