Excel+cell+ranges+Explanation+of

Excel cell ranges Explanation of

There are various symbols used in creating sections, etc. in Excel. So here are some explanations for you. There are colons, commas, and spaces which must be used correctly or you will have problems. A colon names a single range. A1:C2 names the range of cells from A1 to C2. as per illustration:-

A comma will result in the union of two ranges. A union will be all cells in both ranges named. A1:C2, B1:B4 as per illustration :-

A space will result in the intersection of the ranges. An intersection will include only the cells where the named ranges overlap A1:C2 B1:B4 as per illustration :-

Note:- On all these facilities check as you implement in order to ensure that they are working correctly and not giving false readings. So do a test before relying on the structure.  