Forum Discussion

T Robinson's avatar
T Robinson
Copper Contributor
Mar 04, 2018

in EXCEL,how do you copy NON-adjacent Cells, and paste them the same way, non-adjacent

in EXCEL,how do you copy NON-adjacent Cells, and paste them on the same worksheet  the same way as - non-adjacent?

  • Willy Lau's avatar
    Willy Lau
    Steel Contributor

    I just have Excel2013.  In this page by Olaf Hubel, it showed multiple cell selection.

    I am not sure if this feature is just for formatting or copy & paste.

    • SergeiBaklan's avatar
      SergeiBaklan
      MVP

      Hi Willy,

       

      That new functionality allows to unselect cells within selected range, nothing more.

       

      The issue is with pasting - when you select non-adjacent cells, doesn't matter how, Excel paste them as adjacent cells.

      • Willy Lau's avatar
        Willy Lau
        Steel Contributor

        I see.

        If it is just to unselect, I really want to know what the action/purpose to unselect non-adjacent cells for. [off topic]

Resources