Excel Using control to copy data

Page 1 of 2 12 LastLast

  1. Posts : 166
    microsoft windows 10
       #1

    Excel Using control to copy data


    Hi ,,I want to copy =e7,=e9,=e11,, you know what I mean, select a cell, press Ctrl and select down a part of a column, but each cell says =e7,=e8,=e9,=e10,,,what I want is =e7,=e9,=e11,=e13,,can someone tell me how please instead of me having to type in each cell.
      My Computer

  2. philc43's Avatar
    Posts : 5,006
    64bit Win 10 Pro ver 20H2 Build 19042.868 and W10 Insider Preview Build 21343
       #2

    Try the option of pasting as a link instead of pasting formulas.
      My Computers


  3. Posts : 166
    microsoft windows 10
    Thread Starter
       #3

    Very sorry but I don't know what you mean.
    Len
      My Computer

  4. philc43's Avatar
    Posts : 5,006
    64bit Win 10 Pro ver 20H2 Build 19042.868 and W10 Insider Preview Build 21343
       #4

    Its probably because I did not fully understand what you were trying to do. I guessed you were trying to copy from several individual cells and paste into a new region of the worksheet. When you do this there is the option to change the way the paste works. I was suggesting you explore these options:
    Excel Using control to copy data-capture.png
      My Computers


  5. Posts : 166
    microsoft windows 10
    Thread Starter
       #5

    Very very sorry Phil,,,,,, what I have is a number of cells in a column that in each of them it says =e24, = e26, e28, and so on, what I am trying to do is select the cells and using ctrl shift drag them down so that the following cells are =e30, e32, e34, and so on.
    Hope that explains it better
    Len
      My Computer

  6. philc43's Avatar
    Posts : 5,006
    64bit Win 10 Pro ver 20H2 Build 19042.868 and W10 Insider Preview Build 21343
       #6

    Excel usually recognises patterns in data and fills the cells accordingly. Make sure you select more than one cell before you start dragging from the bottom corner to extend the column so that Excel can recognise the pattern. I have done this below to show you.

    First image shows two cells of the column selected:
    Excel Using control to copy data-capture.png

    Then click on the little square at the bottom corner and drag down. It will fill as shown below:
    Excel Using control to copy data-capture1.png
      My Computers


  7. Posts : 166
    microsoft windows 10
    Thread Starter
       #7

    Hi Phil ,,,,its stil not working. this is what I get ,,,I have =a22 which is fred bloggs,,,,=a24 which is joe bloggs, so I select them and drag down like you say but I get a column like this,,
    Fred Bloggs
    Joe Bloggs
    joe bloggs
    Harry short
    Harry short
    tom
    tom
    dick
    dick
    Sammy
    Sammy
    and so forth,,,I have know idea what the heck is going off.
    Len
      My Computer

  8. philc43's Avatar
    Posts : 5,006
    64bit Win 10 Pro ver 20H2 Build 19042.868 and W10 Insider Preview Build 21343
       #8

    I would have to see an actual spreadsheet with the cells and some explanation of what you are trying to do. Post a link or screenshot. There are always more ways than one to achieve something.
      My Computers


  9. Posts : 166
    microsoft windows 10
    Thread Starter
       #9

    Hi Phil here is what I am doing to do as I have to do it a lot, the ones you can see are every 3 rows but I imagine its the same if I wanted to do every 2 rows.
    Excel Using control to copy data-capture1.png Excel Using control to copy data-capture2.png


    Excel Using control to copy data-capture3.png
    You can see what happens when I drag down
    Len
    Last edited by donnylad; 25 Oct 2018 at 13:23.
      My Computer

  10. philc43's Avatar
    Posts : 5,006
    64bit Win 10 Pro ver 20H2 Build 19042.868 and W10 Insider Preview Build 21343
       #10

    OK, if I understand what you are trying to do, you are only wanting to copy the non-blank cells.

    Select the range you want to copy and then use the Select Option and click on Constants. This will just select the cells with data.
    Excel Using control to copy data-capture.png

    Then use copy to copy those cells and paste to paste them where you want. There will be no blank cells in-between.

    If Constant doesn't work use Go To Special and fine tune the constants to get just text:

    Excel Using control to copy data-2018-10-25.png
      My Computers


 
Page 1 of 2 12 LastLast

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd
All times are GMT -5. The time now is 02:38.
Find Us




Windows 10 Forums