Half a croissant, on a plate, with a sign in front of it saying '50c'
h a l f b a k e r y
Please listen carefully, as our opinions have changed.

idea: add, search, annotate, link, view, overview, recent, by name, random

meta: news, help, about, links, report a problem

account: browse anonymously, or get an account and write.

user:
pass:
register,


     

Shortcut for Excel lock reference

 I get the feeling that I am missing some simple keystroke
  (+1)
(+1) 		  [vote for,
against]

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.

—Ling, Mar 10 2008

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.
Short name, e.g., Bob's Coffee
Destination URL. E.g., https://www.coffee.com/
Description (displayed with the short name and URL.)






       I'm with you on this one.
—Texticle, Mar 10 2008
   

       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?
—DrCurry, Mar 10 2008
   


 

back: main index
business  computer  culture  fashion  food  halfbakery  home  other  product  public  science  sport  vehicle