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