Copy a Formula to Adjacent Cells in Excel

Question

How to copy a formula to adjacent cells in Excel?

Answer

With cell B8 active, point to the fill handle (the lower right hand corner of the active cell). Drag the fill handle to select the destination area, C8:E8.

Release the mouse or press Enter.  The formula is copied to the selected cells.

The next step will be to format the Worksheet. Formatting in Excel uses much the same techniques as formatting in Word or PowerPoint.
 

For more information about Microsoft Excel Basics, please view the full tutorial from the CTL here: Excel Part 1

If you need further assistance, please click the CTL Support Request button on this page.

CTL Support Request

Details

Article ID: 7884
Created
Thu 12/22/22 12:55 PM
Modified
Fri 11/3/23 3:41 PM
KCS Article Status
WIP: Only Problem & some Environment captured
Not Validated: Complete & Resolution captured, confidence lacks in structure, content, no feedback
Validated: Complete & reusable, used by licensed KCS user, confidence in resolution & std. compliance
Validated

Related Services / Offerings (1)

CTL Support Request
The Center for Teaching & Learning develops and supports a diverse and inclusive community dedicated to excellent teaching, learning, and student educational experience regardless of location, formality, or modality.