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.