How do you select a cell with an "absolute" address with a cursor?

N

New Daddy

When you try to make an absolute reference to a cell, you place "$" in
front of the column and/or row.
But can you do it more easily by, for example, selecting a cell with
your mouse while pressing CTRL (obviously this does not work) when you
select a cell?

Thank you.
 
P

Paul B

New Daddy, select the cell press F2 then F4 to toggle absolute
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 

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

Automatic cell selection 12
How do I add a formula to a range of cells 0
Code to add comments to selected cells within a selected range 30
External cell reference between two excel worksheets both in One Drive 0
WORD VBA Search and switch to advanced ... 1
Building A Formula: Selecting Cell Address As Absolute? 4
Creating Labels Over 3-Up Image 2
Not able to select range of cells with mouse. 2

Top