$ shortcut

[remeng]

I can't remember what the shortcut keys were to apply the $ character in a cell to lock either the row or column, can anyone help me out? Thanks!

 

[xlhelp]

F4

Vita Brevis

 

[remeng]

Thanks! What is that thing called anyway?

 

[kjv1611]

dollar sign?


I guess it's the "constant" qualifier..

--

"If to err is human, then I must be some kind of human!" -Me

 

[AnotherHiggins]

As far as what the thing is called, I'm with KJV - dollar sign.

The result is an Absolute Reference vs. a Relative Reference.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[remeng]

Dollar sign it is!

 

[JPaules]

A really simple way to change all of your formulas is to use ASAP Utilities. It has a command that will allow you to do all of your formulas (or the ones you select) at one time.

--
JP

 

[remeng]

Jp, I just used Find / Replace and that worked well. Thanks All!

 

[JPaules]

I use ASAP for several features. That one is one of over 300 tools - and it's free. Gotta love that price. I just showed a coworker that he could create a directory of all of the files in a folder to compare with another folder. Each one had over 800 files so he wasn't looking forward to doing that manually.

--
JP

 

[remeng]

JP,

That sounds very useful. What else does it have and where can I get it?

Thanks

 

[JPaules]

I use it to change text case, find duplicate data, easily conditionally shade rows, and my favorite - add prefixes and suffixes to a series of numbers. I work with serial numbers that consist of an unchanging number, 3 unchanging letters, a 4-digit number that increases, and a single unchanging letter. Can't pick and drag to fill in the series of numbers so I do just the numbers, then use this to add in the rest of the info in one step.

My husband also uses this add-in - he's the one who showed it to me. It's saved us both A LOT of time

http://www.asap-utilities.com/

Enjoy!

--
JP

 

[xlbo]

Just to stick my head in here and back up what's being said about ASAP utilities - exceptionally good add-in for excel!

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question