**Question description:**

*This user has given permission to use the problem statement for this blog.*

copying numbers from 1 column to another in filter mode brings irrelevant data over to new column

Solved by O. J. in 40 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

User
18/04/2018 - 10:39

5 mins

Excelchat Expert
18/04/2018 - 10:39

hello!

Excelchat Expert
18/04/2018 - 10:39

how are you?

User
18/04/2018 - 10:40

good but frustrayed

Excelchat Expert
18/04/2018 - 10:40

I see, I'll do my best to help you. :)

Excelchat Expert
18/04/2018 - 10:41

Could you demonstrate to me what you mean by copying cells in a column in filter mode?

Excelchat Expert
18/04/2018 - 10:41

and it bringing about irrelevant data?

Excelchat Expert
18/04/2018 - 10:42

*i'm guessing you want to copy visible cells only in a column after applying a filter, is this correct?

User
18/04/2018 - 10:42

I have a sheet of data with titles in column 1. If I use a filter to extract a titled group of data then cut it & paste it into a different column it takes irrelevant data over as well

Excelchat Expert
18/04/2018 - 10:43

please follow these steps:

User
18/04/2018 - 10:43

yes correct

User
18/04/2018 - 10:43

i can send you sheet, but your app doesn't like the version

User
18/04/2018 - 10:44

it is 2016 version

User
18/04/2018 - 10:44

just purchased today to get around this problem

Excelchat Expert
18/04/2018 - 10:44

are you using mac or windows?

User
18/04/2018 - 10:44

mac

Excelchat Expert
18/04/2018 - 10:45

On a Mac the shortcut is Cmd+Shift+Z. Excel will exclude all the hidden data from your selection and then you can copy (Ctrl+C) and paste (Ctrl+V) only the visible cells

Excelchat Expert
18/04/2018 - 10:46

apologies - In Mac Excel 2016, you can also use Command+Shift+* to select visible cells

Excelchat Expert
18/04/2018 - 10:46

then after that you can copy and paste as per usual

User
18/04/2018 - 10:46

i just use cmd x to cut them cmd v to paste

Excelchat Expert
18/04/2018 - 10:47

yes, you may opt to use cut and paste as well, only after you have selected the visible cells

Excelchat Expert
18/04/2018 - 10:50

apologies again, i just confirmed that you can't use cut (cmd + x) for non-continuous selection (or multiple selection), please use cmd +C instead

Excelchat Expert
18/04/2018 - 10:51

could you confirm if this is working? or do you need more step-by-step guidance?

User
18/04/2018 - 10:52

checking

Excelchat Expert
18/04/2018 - 10:52

if the shortcut keys i've mentioned before doesn't work, please perform these following steps instead:

Excelchat Expert
18/04/2018 - 10:53

1) Select the area of the spreadsheet you want to copy (including all the hidden rows, after applying filter)

Excelchat Expert
18/04/2018 - 10:53

2) n the Menu click Edit -> Find -> Go To...

Excelchat Expert
18/04/2018 - 10:53

3) Click the "Special..." button in the pop up

Excelchat Expert
18/04/2018 - 10:54

4)Select the "Visible Cells Only" radio button in the pop up

Excelchat Expert
18/04/2018 - 10:54

5) Copy the resulting selection Command (⌘) - C

Excelchat Expert
18/04/2018 - 10:54

6) Paste the copied cells in the new location and they won't include any of the hidden/irrelevant cells

User
18/04/2018 - 10:58

that was just a mess

Excelchat Expert
18/04/2018 - 10:59

I'm sorry to hear that. May I know why?

User
18/04/2018 - 10:59

surely this is a fairly common need?

User
18/04/2018 - 10:59

it highlighted the whole page in grey

Excelchat Expert
18/04/2018 - 11:00

May I know at which point did the whole page got highlighted in grey?

User
18/04/2018 - 11:01

step 4

Excelchat Expert
18/04/2018 - 11:02

would you like me to give you a link to a complete step-by-step process with screenshots so you may follow it more easily?

User
18/04/2018 - 11:02

yes please

Excelchat Expert
18/04/2018 - 11:02

https://www.utest.com/articles/how-to-select-just-the-visible-cells-in-excel-mac

Excelchat Expert
18/04/2018 - 11:03

here you go :) please let me know if it works for you at this time.

User
18/04/2018 - 11:08

i get an alert

Excelchat Expert
18/04/2018 - 11:08

which is?

User
18/04/2018 - 11:08

'That command cannot be used on multiple selectiones

Excelchat Expert
18/04/2018 - 11:09

yes, please refrain from using command + X and use command + C instead

User
18/04/2018 - 11:09

cmd C on a mac is copy

Excelchat Expert
18/04/2018 - 11:09

I'm sorry this is a limitation of the software I have no control over

User
18/04/2018 - 11:10

So I will be duplicating the data?

Excelchat Expert
18/04/2018 - 11:11

yes, it is copy. I suggest you perform copy and paste first, on the the new column, and after successfully doing that you may delete those items from the original column

Excelchat Expert
18/04/2018 - 11:13

I hope this alternative method is acceptable to you. again, i'm really sorry but this is a limitation of excel that I have no control over.

Excelchat Expert
18/04/2018 - 11:13

Thanks for your kind understanding.

User
18/04/2018 - 11:14

ok thanks for your help much appreciated

Excelchat Expert
18/04/2018 - 11:14

You're most welcome :)

Excelchat Expert
18/04/2018 - 11:14

At this point, if you don't have any more clarifications on those steps, you may end the session by hovering over the TIME REMAINING section of this chat window and select END SESSION

Excelchat Expert
18/04/2018 - 11:15

Your kind feedback and rating will be highly appreciated. Thank you and have a good day!

Excelchat Expert
18/04/2018 - 11:15

bye bye :)

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*