Skip to Main Content
Office 2010 Made Simple
book

Office 2010 Made Simple

by Guy Hart-Davis
August 2011
Beginner content levelBeginner
730 pages
16h 29m
English
Apress
Content preview from Office 2010 Made Simple

Referring to Cells and Ranges in Formulas and Functions

To make your formulas and functions work correctly, you need to refer to the cells and ranges you want. You can create references to cells and ranges in different locations:

  • On the same worksheet as the formula
  • On a different worksheet than the formula
  • In a different workbook than the formula

Referring to a Cell or Range on the Same Worksheet

To refer to a cell on the same worksheet, enter its column lettering and its row number. For example, use =A10 to refer to cell A10.

You can either type in the reference or click the cell—whichever you find easier. You'll see examples of this shortly.

Similarly, to refer to a range, enter the range's address. For example, use =A10:A20 to refer to ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® Office Outlook® 2007 Inside Out

Microsoft® Office Outlook® 2007 Inside Out

Jim Boyce, Beth Sheresh, Doug Sheresh
Microsoft® Word® 2010 On Demand

Microsoft® Word® 2010 On Demand

Steve Johnson - Perspection Inc.
Microsoft® Word 2013: Step by Step

Microsoft® Word 2013: Step by Step

Joan Lambert and Joyce Cox
Special Edition Using Microsoft® Office Word 2007

Special Edition Using Microsoft® Office Word 2007

Faithe Wempen, Nicholas Chase, Kathy Jacobs, Karen McCall, Joyce J. Nielsen, Patrick Schmid

Publisher Resources

ISBN: 9781430235750Purchase book