Category Archives for "Uncategorized"

2 Change references

If you want to change references of a formula, you could toggle F4 key inside the formula to change the references from Absolute, Column Absolute Row Absolute or all relative. Although, if you have to change references from a range, you can use these two options1. Download ASAP utilities, because it’s worth it, they have […]

Continue reading

Auto increment a cell

Suppose if you want to increment a cell by 1 to see how your formulae handle that change, may be a simulation. That means that cell would be incremented by 1 everytime you hit F9 (keyboard short cut to make Excel recalculate). To achieve this do the following: 1. On the Tools menu, click Options, […]

Continue reading