How to copy multiple cells in Excel without dragging

As we known, we can drag the fill handle down right to fill series or formula as we need. But if there are hundreds of cells needed to be filled by dragging, that must be not a easy job. Here I introduce some tricks on filling series or formula to a specific row without dragging in Excel.

Table of Contents Show

The Best Office Productivity Tools
How do you copy and paste multiple cells in Excel without dragging?
How do I copy multiple cells without dragging?
How do I fill 1000 rows in Excel without dragging?
How do I copy a lot of cells in Excel fast?

Fill series without dragging with Series dialog

1. Select a cell and type the first number of the series.

2. Click Home > Fill > Series.

3. In the Series dialog, if you want to fill cells in a column, check Columns, if not, check Rows, in Type section, check Linear, and in the buttom of the dialog, specify the step value and stop value as you need.

4. Click OK. The sereis has been filled.

Fill formula without dragging with Name box

If you want to fill formula without dragging fill handle, you can use the Name box.

1. Type the formula in the first cell you want to apply the formula, and copy the formula cell by pressing Ctrl + C keys simultaneously.

2. Go to the Name box, and type the range reference you want to apply the formula, press Enter key to select them. See screenshot:

3. Then press Ctrl + V keys together to paste the copied formula to the selected cells, and press Enter key. Now the cells have been apply the same formula.

If you want to apply a same formula to a range or a colum values, you can apply Kutools for Excel’s Operation utility to quickly solve it as below screenshot shown, It’s full function without limitation in 30 days, please download and have a free trial now.

The Best Office Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
More than 300 powerful features. Supports Office / Excel 2007-2021 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.

Read More... Free Download... Purchase...

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
Open and create multiple documents in new tabs of the same window, rather than in new windows.
Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!

Read More... Free Download... Purchase...

Oldest First

Sort comments by

Oldest First

Newest First

Comments (1)

No ratings yet. Be the first to rate!

Ken S.

about 3 years ago

This comment was minimized by the moderator on the site

Thanks for the "Fill Formula Without Dragging With Name Box" tip. Very useful!

There are no comments posted here yet

Leave your comments

Posting as Guest

Username

Password

Name (Required)

Email (Required)

Rate this post:

Reset

0 Characters

Suggested Locations

I agree to the terms and condition

Cancel Submit Comment

How do you copy and paste multiple cells in Excel without dragging?

Copy cells by using Copy and Paste.

Select the cell or range of cells..

Select Copy or press Ctrl + C..

Select Paste or press Ctrl + V..

How do I copy multiple cells without dragging?

Press Ctrl + C to copy the formulas, or Ctrl + X to cut them. Use the latter shortcut if you want to move formulas to a new location. Open Notepad or any other text editor and press Ctrl + V to paste the formulas there. Then press Ctrl + A to select all the formulas, and Ctrl + C to copy them as text.

How do I fill 1000 rows in Excel without dragging?

Quickly Fill Numbers in Cells without Dragging.

Enter 1 in cell A1..

Go to Home –> Editing –> Fill –> Series..

In the Series dialogue box, make the following selections: Series in: Columns. Type: Linear. Step Value: 1. Stop Value: 1000..

Click OK..

How do I copy a lot of cells in Excel fast?

IF you want to copy multiple cells, click and drag until all the cells you intend to copy are selected. The next step is to actually copy the cells. You can do this by pressing control+C on a PC (command+C on a Mac), or by clicking the Copy button in the ribbon at the top of the Excel window.