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.
Try the option of pasting as a link instead of pasting formulas.
Very sorry but I don't know what you mean.
Len
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:
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
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:
Then click on the little square at the bottom corner and drag down. It will fill as shown below:
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
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.
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.
You can see what happens when I drag down
Len
Last edited by donnylad; 25 Oct 2018 at 13:23.
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.
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:
Quote
