Keyboard shortcut for absolute cell references

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)

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.

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)