Excel (all versions) - How to copy a simple formula?

Ask a question

To copy a simple formula over a wide range of cells (columns and/or rows), you can use your mouse. Simply place your mouse pointer in the lower right corner of the cell containing your formula. This takes the form of a plus (+). You just have to click (left click) and while holding down, drag your mouse over the desired rows or colums!
Jean-François Pillou

CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jeff Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Learn more about the CCM team