How to "lock" a cell reference in Numbers??

HELP! I am a recent convert from Windows based machines to Apple. I am very familiar with Excel and need to figure out how to do something in Numbers....

I need to know how to lock a cell reference so that when you drag the formula down or across it keeps the same cell reference. In Excel you can do this by picking the cell and then hitting F4 to either lock the column, row or both.

Anybody out there help a newbie?? Thanks

Posted on Dec 17, 2009 2:02 PM

17 replies

Jan 1, 2010 5:37 PM in response to RoyFelix

Roy,

What do you mean when you say "lock"?

Jerry

RobWM

Level 1

4 points

Jan 11, 2010 9:22 AM in response to Jerrold Green1

Thank you Jerrold - forgot to put the $ in front of both names (duh).
It works ...

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

How to "lock" a cell reference in Numbers??

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up