08 April, 2012

Excel switch between relative and absolute references

I've always wondered how to do this, and I found out you can use F4 to cycle between relative and absolute references, e.g. A1 and $A$1!

No comments:

Post a Comment