Skip to Main Content
Teach Yourself VISUALLY™ Microsoft® Office 2008 for Mac®
book

Teach Yourself VISUALLY™ Microsoft® Office 2008 for Mac®

by Paul McFedries
June 2009
Beginner content levelBeginner
415 pages
12h 48m
English
Visual
Content preview from Teach Yourself VISUALLY™ Microsoft® Office 2008 for Mac®
256
11
22
Excel switches the address to an
absolute cell reference.
4 Repeat Steps 2 and 3 to switch
any other cell addresses that you
require in the absolute reference
format.
5 Press .
1 Double-click the cell that contains
the formula you want to edit.
2 Select the cell reference you want
to change.
3 Press + .
Switch Between Relative and Absolute Cell References
You can make some formulas easier to copy by
switching to absolute cell references. When you
use a regular cell address — called a relative cell
reference — such as A1 in a formula, Excel
adjusts that reference when you copy the
formula to another location. To prevent that
reference from ...
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

Special Edition Using® Microsoft® Office Outlook® 2003

Special Edition Using® Microsoft® Office Outlook® 2003

Charlie Russel, Robert Cordingley

Publisher Resources

ISBN: 9780470485033Purchase book