Fix Excel for Mac Fill Handle Not Copying Formulas or Data
Question details
The user needs to use the fill handle in Excel for Mac to copy formulas or data by dragging.
- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- The user selects a cell and tries to drag its lower-right fill handle to extend formulas, values, or a series.
- Observed behavior
- Dragging selects cells when the pointer displays a large white plus sign instead of copying the selected formula or data.
Select the cell that contains the formula or value you want to copy. Zoom in if needed so the small square at the lower-right corner of the selection is easier to target.
Position the pointer directly on the Excel fill handle
Use this when dragging a selected cell highlights more cells rather than filling formulas or values.
Excel for Mac shows different cursor shapes for selecting cells and using the fill handle. The fill action works only when the pointer changes to the small black plus sign.
Click the cell containing the formula, value, or pattern that you want to copy.
Move the pointer to the small square at the lower-right corner of the selected cell or range.
Move the pointer slightly down and to the right until it becomes a small black plus sign. Do not drag when you see the larger white plus sign, because that cursor selects cells.
Click and drag the small black plus sign across or down the destination cells, then release the mouse button to copy the formula or data.
Use WPS Spreadsheets to Fill Formulas and Data by Dragging
If Excel for Mac cursor behavior continues to interrupt your work, WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and seamless support for Microsoft Office files. Open your workbook in WPS Spreadsheets and use the fill handle to extend formulas, values, and series without changing your file format.
- 1. Install WPS Office: Download and install WPS Office, then open WPS Spreadsheets from the WPS Office home screen.
- 2. Open the Excel workbook: Select Open and choose your existing .xlsx or .xls file.
- 3. Select the source cell: Click the cell containing the formula or data that you want to extend.
- 4. Drag the fill handle: Point to the lower-right corner of the selected cell, then drag the fill handle across the target cells to copy the content.
Frequently Asked Questions
Why does Excel for Mac show a white plus sign instead of the fill handle cursor?
The large white plus sign is the selection cursor. Move the pointer precisely to the lower-right corner of the selected cell, usually slightly down and right, until it changes to a small black plus sign.
How do I copy a formula down a column in Excel for Mac?
Select the cell with the formula, point to its lower-right fill handle until the small black plus sign appears, and drag down through the cells where you want the formula copied.
Will dragging the fill handle adjust cell references in a formula?
Yes. Excel normally adjusts relative references as you drag. References with dollar signs, such as $A$1, remain fixed because they are absolute references.
Can I use the fill handle to repeat the same value in Excel for Mac?
Yes. Select the cell with the value, target the small black plus sign at the lower-right corner, and drag across or down the destination cells to repeat the value.
