Just Asking

Monday, June 12, 2006

Excel question

What do you call the process of adding dollar signs to an equation in Excel to fix the row and column as appropriate before copying an equation? Does anyone besides me use the term “dollarize?”

2 Comments:

At 10:14 AM, Blogger Alyssa said...

I used to know the answer to that question.

Try your luck with yahoo answers...

 
At 10:09 PM, Blogger Pedicularis said...

Never heard of Yahoo Answers. Good to know.

Microsoft calls it an Absolute Cell Address (with two $), Mixed Cell Address (with 1 $), and Relative Cell Address (with no $). A friend at work told me I could toggle through the four types with the F4 key, cool!

In this post, I'm wondering if others use my word "dollarize" or if there are other words out there.

 

Post a Comment

<< Home