Home > Data > Data Entry > Paste Numbers Excel Copy Paste Number Cells OnlySee 3 different ways that you can select and copy the numbers only, in an Excel column. Then, paste the copied numbers in a different location, in a consecutive block of cells. 
Video: Copy and Paste Numbers OnlyIf a range of cells contains a mix of number cells, blank cells and text cells, you can use builtin Excel tools to select just the cells with numbers. Then, copy and paste the cells to another location on the worksheet, in a solid block of cells. 
Watch this short video, to 3 ways to copy and paste just the numbers in an Excel column. Written steps and timeline are below the video. Note: To follow along with the video, you can get the sample file, in the download section at the bottom of the page. Video Timeline

How to Copy and Paste Numbers OnlyTo select just the number cells in an Excel column, you can use one of the following techniques:  1) Copy and Paste Typed Number Cells Only  2) Ignore Text Cells When Selecting  3) Select Formula Cells With Numbers The steps for all three are shown in the video above, and in the written steps below. 
1) Copy and Paste Typed Number Cells OnlyIn this example we've got cells where there are numbers typed, and several cells are blank. None of the cells have formulas. The goal is to copy just the numbers, and paste them in a consecutive block of cells, somewhere else on the worksheet. Select Numbers OnlyTo begin to copy and paste just the numbers, follow these steps:
Now just the number cells are selected  none of the blank cells are included. 
Copy and PasteNext, follow these steps, to complete the copy and paste steps:
The numbers all appear in their original sequence with no blanks between them. 
2) Ignore Text Cells When SelectingIn this example we've got cells where there are numbers typed, some cells have text entries, and several cells are blank. None of the cells have formulas. The goal is to copy just the numbers, and paste them in a consecutive block of cells, somewhere else on the worksheet. Select Numbers OnlyTo begin to copy and paste just the numbers, follow these steps:

Go To Special Dialog BoxThe Go To Special dialog box opens, where there are many options to choose from.
On the worksheet, only the number cells are selected. None of the text cells or blank cells are included. 
Copy and PasteNext, follow these steps, to complete the copy and paste steps:
The numbers all appear in their original sequence with no blanks between them. 
3) Select Formula Cells With NumbersIn this example there are cells where numbers and empty strings are returned by a formula. =IF([@Amt]="","",[@Amt]*[@Price]) The goal is to copy just the numbers, and paste them in a consecutive block of cells, somewhere else on the worksheet. Select Numbers OnlyTo begin to copy and paste just the numbers, follow these steps:

Go To Special Dialog BoxThe Go To Special dialog box opens, where there are many options to choose from.
On the worksheet, only the number cells are selected. None of the text cells or blank cells are included. 
Copy and PasteNext, follow these steps, to complete the copy and paste steps:
The numbers all appear in their original sequence with no blanks between them. 
Download the Sample FilePaste Numbers: Get the sample file for copying and pasting number cells only, to follow along with the video. The zipped file is in xlsx format, and does not contain any macros. 
____________________
Today I'm going to show you how to select cells where there are blanks and numbers or text and copy and paste, just the numbers.
In this example we've got cells where there are numbers typed. There's no formula, just numbers.
Now just the number cells are selected.
The numbers all appear in sequence with no blanks between them.
On the next sheet, I've got numbers and some text, so I'm going to do things a little differently, so I select just the numbers.
In this window, we've got lots of options.
Now I can copy, select a cell and paste.
On the third sheet we've got a price here.
And then in this column there's a formula.
It's saying, IF the amount cell is empty, just put an empty string here, otherwise, multiply the amount by the price.
There's a formula in each of these cells.
I can copy them, click somewhere and paste.
____________________
Increase Numbers With Paste Special
Last updated: February 17, 2024 2:37 PM