Friday, August 28, 2009

How To... Use Absolute Cell Reference in Excel

I have posted a new "How To..." video on YouTube - my first last April.

This one is about using Absolute Cell referencing in Excel. This is a neat Excel tool that makes copying data and formulas a little easier. It is easy to implement once you know how to use it. I learned about it the hard way as I tried to figure out why formulas got messed up whne I copied them. You can save a lot of work if you know how to use this tool - especially if you have a lot of formulas dependent on a static value.

This video was created in my office using Camstudio which is a free and easy to use screen recording tool (

No comments:

Post a Comment