This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi,
When selecting and copying filtered data in Excel it copies all the underlying cells, so when pasting in another sheet I get all data not only the filtered data. This behaviour is on one machine only. It works fine on others.
It happens on all filters in all files, old as new.
I am looking for a solution to this problem not a workaround. So please dont bring me any Goto/Special/Visible cells only and similar workarounds, because this should work out of the box, and does so on all machines but one.
Both Windows and Office fully patched and updated.
Regards
Leyan
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hi, higlight the range to be copied, press CTRL+G, Special, visible cells only, OK, then press CTRL+C, go to where you want to copy the information press CTRL+V
Hi, sorry but I read it, that is not a work around, is how it has to be done, if you don't like at least you should think that we are trying to help you, and we are not Microsoft employees, everyone of us have a job, so next time you can keep any negative comments to yourself, thank you
Hi.
This problem occurs because the range to be filtered has not been selected properly. Select the range from the first cell of the header row till the last row/column of your dataset. If there are no blank rows/columns in your dataset, then you can press Ctrl+A from the first cell of the header row. If there are, then select the range with the arrow key - if using arrow keys to select the range takes a long time, then you may refer to my article at the following link to select a range with blank rows/columns with lesser effort - http://www.ashishmathur.com/select-a-large-data-set-which-has-blank-rows-and-columns-without-using-the-shift-and-arrow-keys/
Anyways, after the entire dataset has been selected, press Ctrl+Shift+L, apply the filter criteria, copy the resultant cells and paste to another worksheet/workbook.
Hope this helps.
Data/Reapply should do it.
or
Remove Filter and then again Apply filter
or
Go to Excel Options/Advanced/Uncheck Extend data range formats and formulas
You didnt read the entire post did you? =)
I quote myself:
"I am looking for a solution to this problem not a workaround. So please dont bring me any Goto/Special/Visible cells only and similar workarounds, because this should work out of the box, and does so on all machines but one."