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

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

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