h a l f b a k e r y
Caution! Contents may be not!
idea:
add, search, annotate, link, view, overview, recent, by name, best, random
meta:
news, help, about, links, report a problem
account:
Browse anonymously,
or get an account
and write.
or Create a new account.
|
|
|
Please log in.
If you're not logged in,
you can see what this page
looks like, but you will
not be able to add anything.
In Excel, you sometimes want to lock the row and/or column of a reference.
Normally, by hand, edit and insert $ appropriately, or highlight the cell in the formula bar and press F4 until the right locking type appears (took me some time to find out that one!).
So, without having to write Macro,
I think that it should be as simple as pressing CTRL (lock column) or SHIFT (lock row) or both while selecting the cell.
Annotation:
|
| |
I'm with you on this one. |
|
| |
I dunno. If you're clicking on a cell (or range) to add it to the formula, Ctrl and Shift already have a meaning, and would bollix up the formula. |
|
| |
Didn't cycling F4 come from the Lotus 1-2-3 days? |
|
| |