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

Excel Cell References Worth Remembering

Part of the Excel Formulas and Functions For Dummies Cheat Sheet

In Excel formulas, you can refer to other cells either relatively or absolutely. When you copy and paste a formula in Excel, how you create the references within the formula tells Excel what to change in the formula it pastes. The formula can either change the references relative to the cell where you're pasting it (relative reference), or it can always refer to a specific cell. You can also mix relative and absolute references so that, when you move or copy a formula, the row changes but the column does not, or vice versa.

Preceding the row and/or column designators with a dollar sign ($) specifies an absolute reference in Excel.

Example Comment
=A1 Complete relative reference
=$A1 The column is absolute; the row is relative
=A$1 The column is relative; the row is absolute
=$A$1 Complete absolute reference
blog comments powered by Disqus
Advertisement
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win an iPad Mini. Enter to win now!