Formatting Issues

Fix Excel Fill Handle and Currency Formatting When Copying Cells

Anum MushtaqAnum Mushtaq Nov 18, 2026 870 views

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.

Fix Excel Fill Handle and Currency Formatting When Copying Cells
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.
Before you start

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.

Solution 1Recommended

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.

1
Check the source format

Select the source cell, open the number format list on the Home tab, and choose Currency if it is not already selected.

2
Enable the fill handle

In Excel for Windows, open File > Options > Advanced. Under Editing options, select Enable fill handle and cell drag-and-drop, then click OK.

3
Drag across the destination

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.

4
Verify the result

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.

Enable the Excel fill handle and copy the source cell
Excel version differences: The File > Options path applies to Excel for Windows. Settings and fill-handle behavior may differ in other Excel versions.
Copy currency formatting in WPS

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. 1. Open the workbook: Open WPS Spreadsheets and choose Open to select your Excel workbook.
  2. 2. Set the currency format: Select the source cell and choose Currency from the number format options on the Home tab.
  3. 3. Copy the cell: Select the source cell and choose Home > Copy, then select the destination cells.
  4. 4. Choose how to paste: Use Home > Paste to copy the contents and formatting, or choose Paste Special > Formats to apply only the formatting.
Apply currency formatting to spreadsheet cellsCopy formatting without replacing destination valuesOpen and edit Microsoft Excel XLSX and XLS filesWork with a familiar spreadsheet interface
microsoft office alternative - wps office

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.