silver_mica
Level 1
(4 points)
Notebooks
Q: Excel to Pages Equation/Formula
Hi,
In Excel I make extensive use of the dollar sign so that when I copy a cell the contents of that cell will not change.
Example (in Excel)
$A2
When copied will retain the "A" portion, but the number will change
$A$2
references a specific cell and will always reference that cell when copied and pasted anywhere.
How do I do the same in Pages?
David
MacBook Pro (Retina, 15-inch, Mid 2015), OS X El Capitan (10.11.1)
by silver_mica,Solvedanswer
silver_mica
Level 1
(4 points)
Notebooks
I just found out how. Double click on the cell and then select the little triangle to the right of the cell reference. A drop down menu will appear with options to keep a row and/or column static. (see graphic)
