Fix Excel Fill Handle and Currency Formatting When Copying Cells
Question details
The user needs to copy cells across columns while keeping the intended currency formatting and restore the fill handle if it is missing.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Copying a currency-formatted source cell into adjacent columns using the fill handle or another fill method.
- Observed behavior
- The fill handle disappears, or the source cell appears to change from Currency to Number during copying.
Select the source cell and check its number format on the Home tab. Confirm that it is set to Currency and that the cells you want to fill are adjacent to it.
Enable the Excel fill handle and copy the source cell
Use this method when the fill handle is missing or you want to copy a currency-formatted cell across adjacent columns.
Select the source cell, open the number format list on the Home tab, and choose Currency if it is not already selected.
In Excel for Windows, open File > Options > Advanced. Under Editing options, select Enable fill handle and cell drag-and-drop, then click OK.
Select the source cell and drag the small square at its lower-right corner across the cells you want to fill. If Auto Fill Options appears, choose Copy Cells to copy the source rather than extend a series.
Select the source and destination cells and check the number format list on the Home tab. If a cell shows Number instead of Currency, select Currency for that cell.

Copy currency formatting with Paste Special
Use Paste Special to copy the source formatting without replacing values already in the destination cells.
Fill currency-formatted cells to the right
Use Fill Right as an alternative when the source is the leftmost cell in a selected range.
Copy currency-formatted cells with WPS Spreadsheets
Use WPS Spreadsheets to format a source cell as Currency and copy its contents or formatting across a worksheet.
- 1. Open the workbook: Open WPS Spreadsheets and choose Open to select your Excel workbook.
- 2. Set the currency format: Select the source cell and choose Currency from the number format options on the Home tab.
- 3. Copy the cell: Select the source cell and choose Home > Copy, then select the destination cells.
- 4. Choose how to paste: Use Home > Paste to copy the contents and formatting, or choose Paste Special > Formats to apply only the formatting.

Frequently Asked Questions
How do I turn the fill handle back on in Excel?
In Excel for Windows, go to File > Options > Advanced and select Enable fill handle and cell drag-and-drop under Editing options. Click OK, then select a cell to see its fill handle.
How can I copy currency formatting without changing the values?
Copy the formatted source cell, select the destination cells, and choose Home > Paste > Paste Special > Formats. This applies formatting without replacing the destination values.
Why did dragging the fill handle produce a series instead of a copy?
Excel may interpret the drag as a request to extend a series. After dragging, open Auto Fill Options and choose Copy Cells if that option is available.
Can I fill cells to the right without using the fill handle?
Yes. Select the source cell and the adjacent cells to its right, then choose Home > Fill > Right. The leftmost cell's contents and formatting are copied across the range.




