How to use formula drag and drop in Microsoft Excel?

Extend Formula through Drag Down/Up/Left/Right

The beauty of Microsoft Excel is that when you put formula once in any cell, you don’t need to write again and again because Microsoft Excel provides you a facility of drag and drop. By this facility, you can copy the formula from one place to another very easily. 

There is another way, through which we can use drag and drop very easily. So the method is that: Select the cell where formula ready, then put your cursor on the right side bottom corner. When the sign of cursor changes into plus just double click and the formula will automatically copy in all cells from top to bottom but from left to right, you should use the method which is discussed above.

Look into screenshot below:

Fig-1

As you see in Fig-1 the column E and row 9 (E9) where sum the formula used. So, we drag from E9 to E10, then E11 and so on.

Similarly, we can use this process from E9 to F9, then G9 and so on and also we can use from left to right side and from right to left as well. 

If you wish to learn more and more about Excel visit our facebook page Waseem WebWork and hit like for upcoming updates.

For Email to us click here Waseem Web Work

Subscribe our youtube channel for the latest and updates videos visit here the video related to the blog How to use formula drag and drop in Microsoft Excel?