Home |
Search |
Today's Posts |
#1
|
|||
|
|||
The $ thing to lock cells at rows or columns
Hi group,
I do know how manually modify the content of a cell so that when "pulling it" to autocomplete into further rows and columns one can lock either row or column. Like =$I$10 It is rather cumbersome though getting the $ sign where it must be. Once I knew a combination of keys that fixed that for me, but I have forgotten. And if one is optimistic enough to enter the $ sign in the help search function one is in for a reminder of who made this software. So I have to ask you guys and girls. Is there still a clever way to have the =$I$10, or has that been discarded with the bathwater? Lars Stockholm |
#2
|
|||
|
|||
Hi
hit F4 to toggle between relative and absolute reference styles " wrote: Hi group, I do know how manually modify the content of a cell so that when "pulling it" to autocomplete into further rows and columns one can lock either row or column. Like =$I$10 It is rather cumbersome though getting the $ sign where it must be. Once I knew a combination of keys that fixed that for me, but I have forgotten. And if one is optimistic enough to enter the $ sign in the help search function one is in for a reminder of who made this software. So I have to ask you guys and girls. Is there still a clever way to have the =$I$10, or has that been discarded with the bathwater? Lars Stockholm |
#3
|
|||
|
|||
The F4 function key is a toggle, toggling through the four states, $I$10,
I$10,$I10, I10. You have to edit the cell for it to take effect. -- HTH RP (remove nothere from the email address if mailing direct) wrote in message ... Hi group, I do know how manually modify the content of a cell so that when "pulling it" to autocomplete into further rows and columns one can lock either row or column. Like =$I$10 It is rather cumbersome though getting the $ sign where it must be. Once I knew a combination of keys that fixed that for me, but I have forgotten. And if one is optimistic enough to enter the $ sign in the help search function one is in for a reminder of who made this software. So I have to ask you guys and girls. Is there still a clever way to have the =$I$10, or has that been discarded with the bathwater? Lars Stockholm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing unused or blank rows and columns | Excel Discussion (Misc queries) | |||
repeated transpose from rows to columns with unequal groups | Excel Discussion (Misc queries) | |||
How do you select two cells in different rows and columns with ou. | Excel Discussion (Misc queries) | |||
interchange columns with rows | Excel Discussion (Misc queries) | |||
Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) |