The $ thing to lock cells at rows or columns

  • Thread starter Thread starter Lars
  • Start date Start date
L

Lars

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)
 
You must log in or register to reply here.

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

Allowing row deletion in worksheet with locked cells 2
How to covert rows to columns or columns to rows. 11
Locking rows and columns 2
Excel Help to copy information from one row at a time to another sheet 1
Locking Columns and rows 1
Hiding rows with cells locked using format protection lock functio 3
Deleting Rows or Columns 1
Working Days function copied down column 1

Back
Top