Excel Formulas
 |
 |
 |
 |
 |
 |
 |
Excel Formulas
Additional Resources
Excel Formulas
Excel Formulas | Microsoft Excel XP | Page 4 |
 |
 |
What's on this page... Using Excel Formulas Entering Formulas Entering Formulas Manually Entering Formulas by Pointing Entering Formulas using the Formula Palette Identifying Formula Errors Using Absolute, Relative and Mixed References |
Using Absolute, Relative And Mixed References
Absolute reference uses two dollar signs in its address: one for the column part and one for the row part.For example, $A$1.
When you copy Excel formulas that has an absolute reference, the reference is not adjusted in the copied cell.
Relative references, on the other hand, are adjusted when the formula is copied. For example, A1.
Excel also allows mixed references in which only one of the address's parts is absolute.
The following table summarizes all of the possible types of cell references.
| Example | Type |
| A1 | Relative reference |
| $A$1 | Absolute reference |
| $A1 | Mixed Reference (column part is absolute) |
| A$1 | Mixed Reference (row part is absolute) |
To change the type of cell reference in Excel formulas, follow these steps:
| 1. | Double-click the cell (or press F2) to get into edit mode. |
| 2. | In the formula bar, move the cursor to a cell reference. |
| 3. | Press F4 repeatedly to cycle through all possible cell reference types. Stop when the cell reference displays the proper type. |
When the formula refers to cells in a different workbook, the other workbook doesn't need to be open.
If the workbook is closed, you must add the complete path to the reference. Here's an example:
=A1* ` C:\MSOffice\Excel\[Budget for 1999]Sheet1`!A1
| Back to Top |
| See also... Using Formulas | Enter Formulas Manually |
| Enter Formulas by Pointing | Enter Formulas with the Formula Palette |
| Identify Formula Errors |
| Return to Excel XP from Excel Formulas |
Excel XP Topics
- Tips- Excel Screen Layout
- Navigational Techniques
- Working with Workbooks
- Templates
- Working with Worksheets
- Moving Around
- Move Worksheets
- Copy Worksheets
- Insert & Delete Cells
- Insert & Delete Rows
- Insert & Delete Columns
- Resize Row
- Resize Column
- Editing Data
- Content Color
- Cell Color
- Number Formats
- Fonts
- Alignment
- Text Direction
- Indent Contents
- Merge Cells
- Copy
- Move
- Undo & Redo
- Using Zoom
- Freeze & Unfreeze Titles
- Split Worksheet
- Spreadsheet Data
- AutoFill
- AutoComplete
- Comment
- Find
- Replace
- Spellcheck
- Formulas
- Functions
- Password
- Sorting
- AutoFilter
- Advanced Filter
- Macros
- Charts
- Charting
- Charting Elements
- Gantt Chart
- PivotTable
- PivotTable Calculations
- PivotTable Layout
- PivotTable Format
- PDF to Excel
- PDF-to-Excel Converter
- Excel to PDF Converter