Excel bug? Inconsistent behavior when Cut/Copy-Pasting across filtered data












4















Problem



I'm seeing the following inconsistent behavior in Excel 2016, when Copying/Cutting/Deleting data across filtered data:




  1. Copying Cells:
    Data gets "copied" from the visible cells only, and not from the filtered cells.

  2. Cutting Cells:
    Data gets "cut" from both - the visible, as well as the filtered cells.

  3. Pasting Cells:
    Data gets pasted on to both - the visible, as well as the filtered cells.

  4. Formatting/Deleting/Dragging Down/Other: Only the visible cells get affected, and not the filtered cells.


I see no good reason for this inconsistent behavior - is this a bug? Or is there some reason for this?



And more importantly, is there any way to get Excel to ignore hidden rows when Cutting and Pasting data, so that it is more consistent with the rest of the operations?



Demo



To try this out, please create the following table in Excel:



enter image description here



Next, filter out the rows with the Category = "Hide":



enter image description here



You should see something like:



enter image description here



Now, do the following:




  1. Select the visible cells in the Copy-From column (AAAA, BBBB, EEEE, FFFF), and Copy them (CTRL-C on Windows)

  2. Go to the first empty cell under Copy-To, and Paste (CTRL-V on Windows)

  3. Select the visible cells in the Cut-From column (GGGG, HHHH, KKKK, LLLL), and Cut them (CTRL-X on Windows)

  4. Go to the first empty cell under Cut-To, and Paste (CTRL-V on Windows)

  5. Select the visible cells in the Format column (MMMM, NNNN, QQQQ, RRRR), and make them Bold (CTRL-B on Windows)

  6. Select the visible cells in the Delete column (SSSS, TTTT, WWWW, XXXX), and Delete them (DEL on Windows)

  7. Select the first cell in the Drag column (January), and drag it down till the end of the column (till CCCC).


You should now see:



enter image description here



Now, clear the filter from the Category column, and you should see:



enter image description here



Based on the above, we can see several inconsistencies in how the filtered cells are handled:




  • Copy: ignores filtered cells

  • Cut: operates on filtered cells

  • Paste: operates on filtered cells

  • Delete: ignores filtered cells

  • Formatting: ignores filtered cells

  • Dragging data down: ignores filtered cells


Bonus



This behavior for filtered cells is different from how hidden cells are handled (to hide a cell, right click on the column or row header, and choose Hide - this will hide the entire row or column). Hidden rows are included in all operations - that is, we can Copy, Cut, Paste, Delete, Format etc data if it is Hidden. The operations seem to behave inconsistently only for "Filtered" data.



Also, interestingly, when the data is hidden and not filtered, the Drag operation behaves differently as well - instead of repeating "January" everywhere, it behaves more intelligently, and shows February, March etc.










share|improve this question

























  • This is a happy case. The inconsistencies I encounter have absolutely no logic. I never determined why if you cut-paste a cell sometimes the cell borders are also moved and sometimes not. Seems totally random.

    – Overmind
    May 29 '17 at 12:34











  • I've always used excel more for viewing/analyzing information. Recently, I had to modify some attributes for a list of 190,000 entities - and after several weeks of working on it, when we finalized the list, I realized that something fishy was going on - and now I have to verify all 190,000 entities all over again! Luckily I haven't noticed too much random behavior at my end - but I'm starting to trust Excel a little less now.

    – Omaer
    May 29 '17 at 12:43











  • In a scenario like that I'd rather do some direct XML checks. It may be easier in some cases, but that needs some familiarity with XML. Anyway, the 'only copy visible cells' it's an option in Home > Find & Select -> Go To Special. Make sure it's not active. It should not be active by default. That may be the cause of point #1 in your list.

    – Overmind
    May 29 '17 at 12:55











  • Paste has to be to a contiguous range. The cell "row" is not part of the copied data. Also, at least in 2016, the Cut operation has to be on a contiguous range. It is not possible to select only the visible cells, and perform a Cut. Perhaps you selected the entire column, thinking that you only selected the visible cells? Copy will exclude filtered cells, but not hidden cells. If you want to exclude hidden cells, you have to actually select just the visible cells as outlined in Help for the Copy function.

    – Ron Rosenfeld
    May 29 '17 at 19:36
















4















Problem



I'm seeing the following inconsistent behavior in Excel 2016, when Copying/Cutting/Deleting data across filtered data:




  1. Copying Cells:
    Data gets "copied" from the visible cells only, and not from the filtered cells.

  2. Cutting Cells:
    Data gets "cut" from both - the visible, as well as the filtered cells.

  3. Pasting Cells:
    Data gets pasted on to both - the visible, as well as the filtered cells.

  4. Formatting/Deleting/Dragging Down/Other: Only the visible cells get affected, and not the filtered cells.


I see no good reason for this inconsistent behavior - is this a bug? Or is there some reason for this?



And more importantly, is there any way to get Excel to ignore hidden rows when Cutting and Pasting data, so that it is more consistent with the rest of the operations?



Demo



To try this out, please create the following table in Excel:



enter image description here



Next, filter out the rows with the Category = "Hide":



enter image description here



You should see something like:



enter image description here



Now, do the following:




  1. Select the visible cells in the Copy-From column (AAAA, BBBB, EEEE, FFFF), and Copy them (CTRL-C on Windows)

  2. Go to the first empty cell under Copy-To, and Paste (CTRL-V on Windows)

  3. Select the visible cells in the Cut-From column (GGGG, HHHH, KKKK, LLLL), and Cut them (CTRL-X on Windows)

  4. Go to the first empty cell under Cut-To, and Paste (CTRL-V on Windows)

  5. Select the visible cells in the Format column (MMMM, NNNN, QQQQ, RRRR), and make them Bold (CTRL-B on Windows)

  6. Select the visible cells in the Delete column (SSSS, TTTT, WWWW, XXXX), and Delete them (DEL on Windows)

  7. Select the first cell in the Drag column (January), and drag it down till the end of the column (till CCCC).


You should now see:



enter image description here



Now, clear the filter from the Category column, and you should see:



enter image description here



Based on the above, we can see several inconsistencies in how the filtered cells are handled:




  • Copy: ignores filtered cells

  • Cut: operates on filtered cells

  • Paste: operates on filtered cells

  • Delete: ignores filtered cells

  • Formatting: ignores filtered cells

  • Dragging data down: ignores filtered cells


Bonus



This behavior for filtered cells is different from how hidden cells are handled (to hide a cell, right click on the column or row header, and choose Hide - this will hide the entire row or column). Hidden rows are included in all operations - that is, we can Copy, Cut, Paste, Delete, Format etc data if it is Hidden. The operations seem to behave inconsistently only for "Filtered" data.



Also, interestingly, when the data is hidden and not filtered, the Drag operation behaves differently as well - instead of repeating "January" everywhere, it behaves more intelligently, and shows February, March etc.










share|improve this question

























  • This is a happy case. The inconsistencies I encounter have absolutely no logic. I never determined why if you cut-paste a cell sometimes the cell borders are also moved and sometimes not. Seems totally random.

    – Overmind
    May 29 '17 at 12:34











  • I've always used excel more for viewing/analyzing information. Recently, I had to modify some attributes for a list of 190,000 entities - and after several weeks of working on it, when we finalized the list, I realized that something fishy was going on - and now I have to verify all 190,000 entities all over again! Luckily I haven't noticed too much random behavior at my end - but I'm starting to trust Excel a little less now.

    – Omaer
    May 29 '17 at 12:43











  • In a scenario like that I'd rather do some direct XML checks. It may be easier in some cases, but that needs some familiarity with XML. Anyway, the 'only copy visible cells' it's an option in Home > Find & Select -> Go To Special. Make sure it's not active. It should not be active by default. That may be the cause of point #1 in your list.

    – Overmind
    May 29 '17 at 12:55











  • Paste has to be to a contiguous range. The cell "row" is not part of the copied data. Also, at least in 2016, the Cut operation has to be on a contiguous range. It is not possible to select only the visible cells, and perform a Cut. Perhaps you selected the entire column, thinking that you only selected the visible cells? Copy will exclude filtered cells, but not hidden cells. If you want to exclude hidden cells, you have to actually select just the visible cells as outlined in Help for the Copy function.

    – Ron Rosenfeld
    May 29 '17 at 19:36














4












4








4








Problem



I'm seeing the following inconsistent behavior in Excel 2016, when Copying/Cutting/Deleting data across filtered data:




  1. Copying Cells:
    Data gets "copied" from the visible cells only, and not from the filtered cells.

  2. Cutting Cells:
    Data gets "cut" from both - the visible, as well as the filtered cells.

  3. Pasting Cells:
    Data gets pasted on to both - the visible, as well as the filtered cells.

  4. Formatting/Deleting/Dragging Down/Other: Only the visible cells get affected, and not the filtered cells.


I see no good reason for this inconsistent behavior - is this a bug? Or is there some reason for this?



And more importantly, is there any way to get Excel to ignore hidden rows when Cutting and Pasting data, so that it is more consistent with the rest of the operations?



Demo



To try this out, please create the following table in Excel:



enter image description here



Next, filter out the rows with the Category = "Hide":



enter image description here



You should see something like:



enter image description here



Now, do the following:




  1. Select the visible cells in the Copy-From column (AAAA, BBBB, EEEE, FFFF), and Copy them (CTRL-C on Windows)

  2. Go to the first empty cell under Copy-To, and Paste (CTRL-V on Windows)

  3. Select the visible cells in the Cut-From column (GGGG, HHHH, KKKK, LLLL), and Cut them (CTRL-X on Windows)

  4. Go to the first empty cell under Cut-To, and Paste (CTRL-V on Windows)

  5. Select the visible cells in the Format column (MMMM, NNNN, QQQQ, RRRR), and make them Bold (CTRL-B on Windows)

  6. Select the visible cells in the Delete column (SSSS, TTTT, WWWW, XXXX), and Delete them (DEL on Windows)

  7. Select the first cell in the Drag column (January), and drag it down till the end of the column (till CCCC).


You should now see:



enter image description here



Now, clear the filter from the Category column, and you should see:



enter image description here



Based on the above, we can see several inconsistencies in how the filtered cells are handled:




  • Copy: ignores filtered cells

  • Cut: operates on filtered cells

  • Paste: operates on filtered cells

  • Delete: ignores filtered cells

  • Formatting: ignores filtered cells

  • Dragging data down: ignores filtered cells


Bonus



This behavior for filtered cells is different from how hidden cells are handled (to hide a cell, right click on the column or row header, and choose Hide - this will hide the entire row or column). Hidden rows are included in all operations - that is, we can Copy, Cut, Paste, Delete, Format etc data if it is Hidden. The operations seem to behave inconsistently only for "Filtered" data.



Also, interestingly, when the data is hidden and not filtered, the Drag operation behaves differently as well - instead of repeating "January" everywhere, it behaves more intelligently, and shows February, March etc.










share|improve this question
















Problem



I'm seeing the following inconsistent behavior in Excel 2016, when Copying/Cutting/Deleting data across filtered data:




  1. Copying Cells:
    Data gets "copied" from the visible cells only, and not from the filtered cells.

  2. Cutting Cells:
    Data gets "cut" from both - the visible, as well as the filtered cells.

  3. Pasting Cells:
    Data gets pasted on to both - the visible, as well as the filtered cells.

  4. Formatting/Deleting/Dragging Down/Other: Only the visible cells get affected, and not the filtered cells.


I see no good reason for this inconsistent behavior - is this a bug? Or is there some reason for this?



And more importantly, is there any way to get Excel to ignore hidden rows when Cutting and Pasting data, so that it is more consistent with the rest of the operations?



Demo



To try this out, please create the following table in Excel:



enter image description here



Next, filter out the rows with the Category = "Hide":



enter image description here



You should see something like:



enter image description here



Now, do the following:




  1. Select the visible cells in the Copy-From column (AAAA, BBBB, EEEE, FFFF), and Copy them (CTRL-C on Windows)

  2. Go to the first empty cell under Copy-To, and Paste (CTRL-V on Windows)

  3. Select the visible cells in the Cut-From column (GGGG, HHHH, KKKK, LLLL), and Cut them (CTRL-X on Windows)

  4. Go to the first empty cell under Cut-To, and Paste (CTRL-V on Windows)

  5. Select the visible cells in the Format column (MMMM, NNNN, QQQQ, RRRR), and make them Bold (CTRL-B on Windows)

  6. Select the visible cells in the Delete column (SSSS, TTTT, WWWW, XXXX), and Delete them (DEL on Windows)

  7. Select the first cell in the Drag column (January), and drag it down till the end of the column (till CCCC).


You should now see:



enter image description here



Now, clear the filter from the Category column, and you should see:



enter image description here



Based on the above, we can see several inconsistencies in how the filtered cells are handled:




  • Copy: ignores filtered cells

  • Cut: operates on filtered cells

  • Paste: operates on filtered cells

  • Delete: ignores filtered cells

  • Formatting: ignores filtered cells

  • Dragging data down: ignores filtered cells


Bonus



This behavior for filtered cells is different from how hidden cells are handled (to hide a cell, right click on the column or row header, and choose Hide - this will hide the entire row or column). Hidden rows are included in all operations - that is, we can Copy, Cut, Paste, Delete, Format etc data if it is Hidden. The operations seem to behave inconsistently only for "Filtered" data.



Also, interestingly, when the data is hidden and not filtered, the Drag operation behaves differently as well - instead of repeating "January" everywhere, it behaves more intelligently, and shows February, March etc.







microsoft-excel microsoft-excel-2016






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited May 29 '17 at 12:09







Omaer

















asked May 29 '17 at 11:37









OmaerOmaer

12116




12116













  • This is a happy case. The inconsistencies I encounter have absolutely no logic. I never determined why if you cut-paste a cell sometimes the cell borders are also moved and sometimes not. Seems totally random.

    – Overmind
    May 29 '17 at 12:34











  • I've always used excel more for viewing/analyzing information. Recently, I had to modify some attributes for a list of 190,000 entities - and after several weeks of working on it, when we finalized the list, I realized that something fishy was going on - and now I have to verify all 190,000 entities all over again! Luckily I haven't noticed too much random behavior at my end - but I'm starting to trust Excel a little less now.

    – Omaer
    May 29 '17 at 12:43











  • In a scenario like that I'd rather do some direct XML checks. It may be easier in some cases, but that needs some familiarity with XML. Anyway, the 'only copy visible cells' it's an option in Home > Find & Select -> Go To Special. Make sure it's not active. It should not be active by default. That may be the cause of point #1 in your list.

    – Overmind
    May 29 '17 at 12:55











  • Paste has to be to a contiguous range. The cell "row" is not part of the copied data. Also, at least in 2016, the Cut operation has to be on a contiguous range. It is not possible to select only the visible cells, and perform a Cut. Perhaps you selected the entire column, thinking that you only selected the visible cells? Copy will exclude filtered cells, but not hidden cells. If you want to exclude hidden cells, you have to actually select just the visible cells as outlined in Help for the Copy function.

    – Ron Rosenfeld
    May 29 '17 at 19:36



















  • This is a happy case. The inconsistencies I encounter have absolutely no logic. I never determined why if you cut-paste a cell sometimes the cell borders are also moved and sometimes not. Seems totally random.

    – Overmind
    May 29 '17 at 12:34











  • I've always used excel more for viewing/analyzing information. Recently, I had to modify some attributes for a list of 190,000 entities - and after several weeks of working on it, when we finalized the list, I realized that something fishy was going on - and now I have to verify all 190,000 entities all over again! Luckily I haven't noticed too much random behavior at my end - but I'm starting to trust Excel a little less now.

    – Omaer
    May 29 '17 at 12:43











  • In a scenario like that I'd rather do some direct XML checks. It may be easier in some cases, but that needs some familiarity with XML. Anyway, the 'only copy visible cells' it's an option in Home > Find & Select -> Go To Special. Make sure it's not active. It should not be active by default. That may be the cause of point #1 in your list.

    – Overmind
    May 29 '17 at 12:55











  • Paste has to be to a contiguous range. The cell "row" is not part of the copied data. Also, at least in 2016, the Cut operation has to be on a contiguous range. It is not possible to select only the visible cells, and perform a Cut. Perhaps you selected the entire column, thinking that you only selected the visible cells? Copy will exclude filtered cells, but not hidden cells. If you want to exclude hidden cells, you have to actually select just the visible cells as outlined in Help for the Copy function.

    – Ron Rosenfeld
    May 29 '17 at 19:36

















This is a happy case. The inconsistencies I encounter have absolutely no logic. I never determined why if you cut-paste a cell sometimes the cell borders are also moved and sometimes not. Seems totally random.

– Overmind
May 29 '17 at 12:34





This is a happy case. The inconsistencies I encounter have absolutely no logic. I never determined why if you cut-paste a cell sometimes the cell borders are also moved and sometimes not. Seems totally random.

– Overmind
May 29 '17 at 12:34













I've always used excel more for viewing/analyzing information. Recently, I had to modify some attributes for a list of 190,000 entities - and after several weeks of working on it, when we finalized the list, I realized that something fishy was going on - and now I have to verify all 190,000 entities all over again! Luckily I haven't noticed too much random behavior at my end - but I'm starting to trust Excel a little less now.

– Omaer
May 29 '17 at 12:43





I've always used excel more for viewing/analyzing information. Recently, I had to modify some attributes for a list of 190,000 entities - and after several weeks of working on it, when we finalized the list, I realized that something fishy was going on - and now I have to verify all 190,000 entities all over again! Luckily I haven't noticed too much random behavior at my end - but I'm starting to trust Excel a little less now.

– Omaer
May 29 '17 at 12:43













In a scenario like that I'd rather do some direct XML checks. It may be easier in some cases, but that needs some familiarity with XML. Anyway, the 'only copy visible cells' it's an option in Home > Find & Select -> Go To Special. Make sure it's not active. It should not be active by default. That may be the cause of point #1 in your list.

– Overmind
May 29 '17 at 12:55





In a scenario like that I'd rather do some direct XML checks. It may be easier in some cases, but that needs some familiarity with XML. Anyway, the 'only copy visible cells' it's an option in Home > Find & Select -> Go To Special. Make sure it's not active. It should not be active by default. That may be the cause of point #1 in your list.

– Overmind
May 29 '17 at 12:55













Paste has to be to a contiguous range. The cell "row" is not part of the copied data. Also, at least in 2016, the Cut operation has to be on a contiguous range. It is not possible to select only the visible cells, and perform a Cut. Perhaps you selected the entire column, thinking that you only selected the visible cells? Copy will exclude filtered cells, but not hidden cells. If you want to exclude hidden cells, you have to actually select just the visible cells as outlined in Help for the Copy function.

– Ron Rosenfeld
May 29 '17 at 19:36





Paste has to be to a contiguous range. The cell "row" is not part of the copied data. Also, at least in 2016, the Cut operation has to be on a contiguous range. It is not possible to select only the visible cells, and perform a Cut. Perhaps you selected the entire column, thinking that you only selected the visible cells? Copy will exclude filtered cells, but not hidden cells. If you want to exclude hidden cells, you have to actually select just the visible cells as outlined in Help for the Copy function.

– Ron Rosenfeld
May 29 '17 at 19:36










1 Answer
1






active

oldest

votes


















0














I'm going to try and answer this question in parts.



For your cell formatting: What gets moved is the formatting on the CELL, not what it looks like. Let's take cells A1 and B1. They're next to each other. There's a border between the two. I'm going to move cell B1.



If the border is because B1 has a left border, it'll move.



If the border is because A1 has a right border, it won't move.



I never use cut, because it ISN'T copy-paste-delete. Cut is treated as a "special" action, and as a result, it ignores filters. It will also move cell references with it, and overwrite cell references where it lands. If you try similar experiments with paste special data into filtered ranges, or if your drag-down is copy then paste special, you might see similar behavior.



I've had quite a few problems at work from people cutting and pasting data. My mantra is "Never cut and paste - you won't get the results you're hoping for"






share|improve this answer























    Your Answer








    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "3"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1213970%2fexcel-bug-inconsistent-behavior-when-cut-copy-pasting-across-filtered-data%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    0














    I'm going to try and answer this question in parts.



    For your cell formatting: What gets moved is the formatting on the CELL, not what it looks like. Let's take cells A1 and B1. They're next to each other. There's a border between the two. I'm going to move cell B1.



    If the border is because B1 has a left border, it'll move.



    If the border is because A1 has a right border, it won't move.



    I never use cut, because it ISN'T copy-paste-delete. Cut is treated as a "special" action, and as a result, it ignores filters. It will also move cell references with it, and overwrite cell references where it lands. If you try similar experiments with paste special data into filtered ranges, or if your drag-down is copy then paste special, you might see similar behavior.



    I've had quite a few problems at work from people cutting and pasting data. My mantra is "Never cut and paste - you won't get the results you're hoping for"






    share|improve this answer




























      0














      I'm going to try and answer this question in parts.



      For your cell formatting: What gets moved is the formatting on the CELL, not what it looks like. Let's take cells A1 and B1. They're next to each other. There's a border between the two. I'm going to move cell B1.



      If the border is because B1 has a left border, it'll move.



      If the border is because A1 has a right border, it won't move.



      I never use cut, because it ISN'T copy-paste-delete. Cut is treated as a "special" action, and as a result, it ignores filters. It will also move cell references with it, and overwrite cell references where it lands. If you try similar experiments with paste special data into filtered ranges, or if your drag-down is copy then paste special, you might see similar behavior.



      I've had quite a few problems at work from people cutting and pasting data. My mantra is "Never cut and paste - you won't get the results you're hoping for"






      share|improve this answer


























        0












        0








        0







        I'm going to try and answer this question in parts.



        For your cell formatting: What gets moved is the formatting on the CELL, not what it looks like. Let's take cells A1 and B1. They're next to each other. There's a border between the two. I'm going to move cell B1.



        If the border is because B1 has a left border, it'll move.



        If the border is because A1 has a right border, it won't move.



        I never use cut, because it ISN'T copy-paste-delete. Cut is treated as a "special" action, and as a result, it ignores filters. It will also move cell references with it, and overwrite cell references where it lands. If you try similar experiments with paste special data into filtered ranges, or if your drag-down is copy then paste special, you might see similar behavior.



        I've had quite a few problems at work from people cutting and pasting data. My mantra is "Never cut and paste - you won't get the results you're hoping for"






        share|improve this answer













        I'm going to try and answer this question in parts.



        For your cell formatting: What gets moved is the formatting on the CELL, not what it looks like. Let's take cells A1 and B1. They're next to each other. There's a border between the two. I'm going to move cell B1.



        If the border is because B1 has a left border, it'll move.



        If the border is because A1 has a right border, it won't move.



        I never use cut, because it ISN'T copy-paste-delete. Cut is treated as a "special" action, and as a result, it ignores filters. It will also move cell references with it, and overwrite cell references where it lands. If you try similar experiments with paste special data into filtered ranges, or if your drag-down is copy then paste special, you might see similar behavior.



        I've had quite a few problems at work from people cutting and pasting data. My mantra is "Never cut and paste - you won't get the results you're hoping for"







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Dec 21 '17 at 17:26









        SelkieSelkie

        222115




        222115






























            draft saved

            draft discarded




















































            Thanks for contributing an answer to Super User!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1213970%2fexcel-bug-inconsistent-behavior-when-cut-copy-pasting-across-filtered-data%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            How to make a Squid Proxy server?

            Is this a new Fibonacci Identity?

            19世紀