Office Settings & Configuration

How to Select Multiple Excel Cells Without Copying Contents

Bushra Parveen Oct 20, 2026 869 views

Question details

The user needs to highlight a range of cells in a spreadsheet without the application automatically duplicating the data from the first cell into the rest of the selection.

How to Select Multiple Excel Cells Without Copying Contents

Product: Excel
Device & OS: not provided
Scenario: Highlighting adjacent or multiple cells to apply formatting or perform a mass operation.
Observed behavior: When attempting to select multiple cells, Excel inadvertently copies the first cell's contents into the other selected cells because the drag-and-drop or fill handle feature is triggered.

Before you start

Make sure your cursor displays as a thick white cross (used for selection) rather than a thin black cross (which activates the fill handle) before you click and drag across your spreadsheet.

Solution 1Recommended

Disable the Fill Handle and Cell Drag-and-Drop

Turn off the drag-and-drop feature in Excel Options to completely prevent accidental data duplication when selecting cells.

By default, Excel enables a feature called the 'fill handle'—a small green square at the bottom right corner of an active cell. Dragging this square copies the cell's contents. Disabling this feature ensures your selections remain harmless.

Open Excel Options

Click on 'File' in the top-left corner of the Excel ribbon, then select 'Options' at the bottom of the menu to open the Excel Options dialog box.

Navigate to Advanced Settings

In the left-hand sidebar of the Options window, click on the 'Advanced' tab.

Disable the Fill Handle

Under the 'Editing options' section, uncheck the box labeled 'Enable fill handle and cell drag-and-drop'.

Apply Changes

Click 'OK' at the bottom of the window to save your settings. Try selecting your cell range again.

Disable the Fill Handle and Cell Drag-and-Drop

Feature Disabled Successfully: Once disabled, you can drag your mouse anywhere across the cells safely without the risk of copying or overwriting adjacent cell contents.

Solution 2

Use Keyboard Shortcuts for Selection

Avoid the mouse drag entirely by using keyboard commands to select multiple cells safely.

Select and Edit Cells Easily with WPS Spreadsheet

WPS Spreadsheet provides intuitive cell selection tools and allows you to quickly toggle drag-and-drop settings to prevent accidental data overwriting. It serves as a highly capable and user-friendly spreadsheet solution.

1. Open WPS Spreadsheet: Launch WPS Office and open your current workbook or create a new one.
2. Access the Settings Menu: Click on 'Menu' in the top-left corner and select 'Options' from the drop-down list.
3. Modify Edit Settings: Navigate to the 'Edit' tab and clear the 'Allow cell drag and drop' checkbox to prevent accidental copying.

Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) formats.Straightforward interface to customize editing and fill handle preferences.Lightweight design ensures smooth performance even on older devices.Completely free to download and use for all your data management tasks.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel keep copying my cell when I just want to highlight it?

This usually happens because you are clicking and dragging the 'fill handle'—the small green square located at the bottom-right corner of the active cell. To highlight cells normally, ensure your cursor looks like a thick white cross and click from the center of the cell.

How do I select non-adjacent cells without changing their contents?

To select cells that are not next to each other, click the first cell, then hold down the 'Ctrl' key (or 'Command' on a Mac) while clicking each additional cell you want to select.

Can I turn the fill handle back on later if I need it?

Yes. You can easily re-enable the feature at any time by going to File > Options > Advanced, and checking the 'Enable fill handle and cell drag-and-drop' box again.

Office App Problems