How do I anchor a cell/create absolute ref. while clicking on it?

G

Guest

I know that I can manually go in to a formula and put a "$" to anchor a cell
(i.e., create an absolute reference), but I remember there being a way that I
could use a key stroke while clicking on the cell that I want to anchor.

Thanks for your help!
 
G

Guest

The F4 key cycles through
complete absolute,
absolute row relative column
relative row absolute column
complete relative
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Making a structured reference absolute? 5
Finding values in different rows/columns 1
anchor an object to a cell 1
"Relative" Absolute Cell References in Excel 2007 4
Is it possible to "anchor" a callout in PowerPoint 2007? 3
Making visible the anchor point for floating drawing canvas 10
How do I anchor a cell reference? 3
How to fill cell references from several worksheets in one? 2

Top