Allow Cell Drag and Drop option in Excel

Allow Cell Drag and Drop option in Excel 2010?

Sometime back while working on excel 2010, it seems by mistake I disabled the option to use “cell drag and drop”. This feature allows you to drag the mouse and copy cells. If this option is disabled, your mouse pointer will never change to move pointer on selecting a particular cell.

Ok, here is what I mean. In the illustration shown below, mouse pointer is getting changed to move pointer as soon as I bring it to the edge of a cell.

There is some info available on the net for Excel 2003 and the earlier versions ie  by going to Tools > Options > Edit and checking “Allow cell drag and drop”, you can enable this option but there is no information regarding the same for Excel 2007 and Excel 2010. So how can you enable this option in 2010?

1. Go to File > Options > Advanced > Enable file handle and cell drag-and-drop
2. Check this box.
3. Click OK and you’re done

Count if

In Excel 2010 by using COUNTIF conditional logic, you will be able to count occurrence of data and show the result if the condition is met. It enables user to use a condition that contain two arguments (range,criteria), that would be applied on data which yields counting results, only if specified criteria isTRUE. Thus facilitating user to create a group for certain type of data that falls into specific category. This post explains simple usage of COUNTIF logic.

Launch Excel 2010, and open a datasheet on which you need to apply formula with COUNTIF function

=COUNTIF(range, criteria)

=COUNTIF(A2:A34,"SINGH COMMUNICATION")

If you want to Count Singh Comm

=COUNTIF(A2:A34,"SINGH COMMUNICATION")  Ans :- 3