Keyboard shortcut for absolute cell references

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.

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

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.

More Like This

Retrieving data ...

This site contains user submitted content, comments and opinions and is for informational purposes only.
Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums.
Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.