3 Replies Latest reply: Oct 4, 2008 2:03 AM by KOENIG Yvan
drh_g4 Level 1 Level 1 (0 points)
Ok, I am trying to find the keyboard shortcut to change a cell reference (A1) into an absolute cell reference ($A$1). This is the same as Apple-T in Excel which cycles through the variations (A1, $A1, A$1, $A$1).

Thanks!
-Darren

p.s. The manual for Numbers only talks about the feature but not the shortcut.

To paste a copy of a formula in a different cell and use the same cell references in both
formulas, place a dollar sign ($) in front of column and row identifiers (=$A$1). This
technique creates what’s called an absolute cell reference.
For example, if the formula =A1 appears in cell D1 and you want to paste a copy of the
formula in cell E1, change the formula to =$A$1, select D1, copy it, and paste the copy
into E1. The formula $A$1 is copied into cell E1. If you didn’t change the formula to use
an absolute cell reference the formula in E1 would be =B1.

MacBook Intel, Power Mac G5, Mac mini, Mac OS X (10.5.4)
  • Level 8 Level 8 (41,790 points)
    drh_g4 wrote:
    Ok, I am trying to find the keyboard shortcut to change a cell reference (A1) into an absolute cell reference ($A$1). This is the same as Apple-T in Excel which cycles through the variations (A1, $A1, A$1, $A$1).

    p.s. The manual for Numbers only talks about the feature but not the shortcut.


    It's perfectly logical because there is no such shortcut in Numbers.

    _Go to "Provide Numbers Feedback" in the "Numbers" menu_, describe what you wish.
    Then, cross your fingers, and wait _at least_ for iWork'09

    Yvan KOENIG (from FRANCE mercredi 27 août 2008 16:19:49)
  • Simon Varnam Level 1 Level 1 (15 points)
    There is a similar function (in Numbers '08) called "ADDRESS" but ... well I'll paste it all below.
    Is this any use?

    It (absolute cell ref.) seems to work for cells in a spreadsheet that I imported from AW6 which simply use =$A$1, but not for those which use the $A$1 in a formula such as =COUNTIF(H26:T26,"=$A$1")
    Still on my first day with Numbers and regretting it already!
    The Japanese characters have been mutilated, and it's SLOWWW.
    If you can get ADDRESS to work please let me know how. Thanks!

    - - - - - - from Numbers '08 Help - - - - - - - - - - - -
    ADDRESS

    The ADDRESS function constructs a cell address string from row, column, and sheet identifiers.
    ADDRESS(row, column, [type], [style], [sheet])
    row: The row number of the address.
    column: The column number of the address.
    type: Optional; a number specifying whether the row and column numbers are relative or absolute:
    1 or missing treats row and column as absolute references.

    2 treats the row number as an absolute reference and the column number as a relative reference.

    3 treats the row number as a relative reference and the column number as an absolute reference.

    4 treats both row and column numbers as relative references.

    style: Optional; the address style:
    TRUE, 1, or omitted formats the address using the A1 style, in which the letter specifies the column and the number specifies the row.

    sheet: Optional; the name of the sheet, if the table is on another sheet.
  • Level 8 Level 8 (41,790 points)
    It (absolute cell ref.) seems to work for cells in a spreadsheet that I imported from AW6 which simply use =$A$1, but not for those which use the $A$1 in a formula such as =COUNTIF(H26:T26,"=$A$1")


    If we use the correct syntax:
    =COUNTIF(H26:T26,$A$1)
    it behaves flawlessly.

    I don't see any link between your message and the original question <hich was about shortcut to create an absolute reference.

    Yvan KOENIG (from FRANCE samedi 4 octobre 2008 11:03:01)