- Worldstart's Tech Tips And Computer Help - http://www.worldstart.com -

Cell Range Characters in Excel Explained

Do you find that referring to cell ranges in Excel formulas is a difficult task? Confused by the use of the colons, commas and spaces?

These characters are definitely a part of formula writing and if they aren’t used correctly, you’ll probably run into some problems.

So, here’s the information that can make formula writing with ranges a much more manageable task.

I’ve shown you the results of the identified ranges as highlighted cells, but obviously, when you actually go to use them in formulas, it’s the values within those cells that are put to work.

Now, go forward and confidently use ranges in your formulas to your heart’s content!

~ April