Excel Using control to copy data Solved

Page 1 of 2 12 LastLast
  1.    3 Weeks Ago #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 ComputerSystem Spec

  2. philc43's Avatar
    Posts : 3,694
    64bit Win 10 Pro ver 1809 Build 17763.134 and W10 Insider Build 18277
       3 Weeks Ago #2

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

  3.    3 Weeks Ago #3

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

  4. philc43's Avatar
    Posts : 3,694
    64bit Win 10 Pro ver 1809 Build 17763.134 and W10 Insider Build 18277
       3 Weeks Ago #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:
    Click image for larger version. 

Name:	Capture.PNG 
Views:	23 
Size:	7.2 KB 
ID:	209639
      My ComputersSystem Spec

  5.    3 Weeks Ago #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 ComputerSystem Spec

  6. philc43's Avatar
    Posts : 3,694
    64bit Win 10 Pro ver 1809 Build 17763.134 and W10 Insider Build 18277
       3 Weeks Ago #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:
    Click image for larger version. 

Name:	Capture.PNG 
Views:	14 
Size:	5.0 KB 
ID:	209885

    Then click on the little square at the bottom corner and drag down. It will fill as shown below:
    Click image for larger version. 

Name:	Capture1.PNG 
Views:	14 
Size:	7.1 KB 
ID:	209886
      My ComputersSystem Spec

  7.    2 Weeks Ago #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 ComputerSystem Spec

  8. philc43's Avatar
    Posts : 3,694
    64bit Win 10 Pro ver 1809 Build 17763.134 and W10 Insider Build 18277
       2 Weeks Ago #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 ComputersSystem Spec

  9.    2 Weeks Ago #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.
    Click image for larger version. 

Name:	Capture1.PNG 
Views:	12 
Size:	19.9 KB 
ID:	209917 Click image for larger version. 

Name:	Capture2.PNG 
Views:	12 
Size:	15.0 KB 
ID:	209918


    Click image for larger version. 

Name:	capture3.PNG 
Views:	11 
Size:	5.6 KB 
ID:	209921
    You can see what happens when I drag down
    Len
    Last edited by donnylad; 2 Weeks Ago at 13:23.
      My ComputerSystem Spec

  10. philc43's Avatar
    Posts : 3,694
    64bit Win 10 Pro ver 1809 Build 17763.134 and W10 Insider Build 18277
       2 Weeks Ago #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.
    Click image for larger version. 

Name:	Capture.PNG 
Views:	11 
Size:	14.5 KB 
ID:	209924

    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:

    Click image for larger version. 

Name:	2018-10-25.png 
Views:	11 
Size:	9.4 KB 
ID:	209925
      My ComputersSystem Spec


 
Page 1 of 2 12 LastLast

Related Threads
206387 Outlook is driving me crazy! Office 365 ProPlus got updated yesterday, and today it's giving me this stupid thing! It also doesn't seem to be collecting my emails for me. In fact, I tried to send an email from one of my accounts to...
Solved Slow Data copy/paste SPEEDS in WINDOWS 10 in Performance & Maintenance
Hello Guyz, I encountered a problem after upgrading to windows 10. I had extremely slow data transfer speed from any storage media. I myself found a fix for it. I didn't have this prob in win 7. I hope that u understand. Regards Robert Stark ...
Source: Were Making Our Terms and Data Policy Clearer, Without New Rights to Use Your Data on Facebook | Facebook Newsroom
I just upgraded to windows 10. I am trying to copy DATA files and folders from a DVD. This is not music, movies, or anything like that, these are data files I was able to access in prior versions of Windows 10 that I placed them on the DVD myself....
Guys I have done this in the past but cannot recall how and don't want to botch. I had hoped Windows 10 corrected the "rename user account" function but nope. I renamed a User Account due to conflict on the LAN and sure enough, now I have two...
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 07:47.
Find Us