| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do you select a cell with an "absolute" address with a cursor?
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. |
|
#2
|
|||
|
|||
|
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 "New Daddy" wrote in message oups.com... When you try to make an 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| Please Help...How can I do this? Select a cell | Excel Worksheet Functions | |||
| I want to select the first blank cell in column A | Excel Worksheet Functions | |||
| Is there a forumla to link an absolute cell reference in multiple. | Excel Worksheet Functions | |||
| Link to a cell in another workbook by name rather than absolute c. | New Users to Excel | |||
Linear Mode
