Shortcut Key for Absolute References...?

Question

Level 1

8 points

Shortcut Key for Absolute References...?

In "the other" spreadsheet software - while entering a formula - you can hit F4 just after a cell reference and have it become "Absolute". Is there a quick way to do this in numbers?

PowerBook, Mac OS X (10.5.6)

Posted on Feb 1, 2009 7:43 AM

Reply

Answer 1

Feb 1, 2009 7:54 AM in response to MatLgx

In Numbers 09, hover over cell reference until the triangle appears. Click the triangle and select your reference type from the drop-down list.

Jerry

Reply

Answer 2

KOENIG Yvan

Level 8

41,825 points

Feb 1, 2009 1:43 PM in response to MatLgx

Help > Numbers Shortcuts

states:

Specify absolute and relative attributes of selected cell references:
_Command-K or Shift-Command-K_ to cycle forward or backward through options

Specify absolute and relative attributes of first and last cells of selected cell references
_Option-Command-K or Shift-Option-Command-K_ to cycle forward or backward through options

Yvan KOENIG (from FRANCE dimanche 1 février 2009 22:43:22)

Reply