+ Reply to Thread
Results 1 to 3 of 3

How to copy only the selected cells and not cells in between those?

  1. #1
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    How to copy only the selected cells and not cells in between those?

    I want to copy cell 2, 3, 6, 8,10,15. So if I click each of those and say copy, only those cells get that copy border, but if I go and paste it in another workbook it pastes the cells between those numbers.

  2. #2
    Forum Contributor Mvaldesi's Avatar
    Join Date
    01-21-2011
    Location
    Plano, TX
    MS-Off Ver
    MS365 (PC) v.2108
    Posts
    271

    Re: How to copy only the selected cells and not cells in between those?

    Use [Alt+;] to select only visible cells.

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: How to copy only the selected cells and not cells in between those?

    Are you holding CTRL down as you select the cells for copy/paste? IF you do... only the selected cells paste into same/different workbook.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. copy the intersection of selected cells and past delimition then copy results to another
    By hassan khansa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-07-2017, 04:57 PM
  2. Copy cells of selected row
    By fesan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-31-2016, 02:37 PM
  3. Unmerge cells then copy content to only selected cells
    By zoenightshade in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-23-2015, 11:44 PM
  4. Copy the most count of identifier and copy them into the selected cells
    By geliedee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-26-2015, 04:44 PM
  5. Copy selected cells from one worksheet to selected cells in another worksheet
    By peter wischhusen in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 6
    Last Post: 02-01-2015, 01:01 PM
  6. copy data from selected cells , in selected row and paste it to ms word table ?
    By aaashaaa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-06-2010, 03:25 PM
  7. [SOLVED] How can I copy the values of all selected cells to the same cells inanother Sheet
    By hans.domian@de.man-mn.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2006, 12:50 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1