General Chat Thread, Excel help please? in General; I am trying to copy excel cells like this
Hard to explain but I have about ...
1st June 2012, 11:46 AM #1
Excel help please?
I am trying to copy excel cells like this
Hard to explain but I have about 400 cells to fill and I can fill series as it jumps in just one step at a time.
To make things more complicated I'm actually doing this in google docs!
Can anyone help please?
IDG Tech News
1st June 2012, 12:00 PM #2
Do you mean you can't fill series?
What step jump are you looking for as in Office 2010 you can set that I know you said you were doing it in google.
A bit more info is required
1st June 2012, 12:09 PM #3
Sorry, I am finding it hard to explain what I want to do here!
What I am trying to do is this...
=concatenate(A503," ",B503) | =C505 | =E505
=concatenate(A537," ",B537) | =C539 | =E539
=concatenate(A571," ",B571) | =C573 | =E573
And on and on!
1st June 2012, 12:17 PM #4
im confused just use the concatenate?
dont think i know what you want, say you have these cells:
what would you want as the result?
do you mean you want to lock the co-ords in the concatenation?
=concatenate($A$571$," ",$B$571$) | =C573 | =E573
1st June 2012, 12:24 PM #5
See I told you I was finding it hard!
I already have that in the six cells shown in my rubbish diagram but I now want to copy those down below stepping in steps of 34. When I try to fill series this doesn't carry on the steps of adding 34!
1st June 2012, 01:06 PM #6
If you select the cells where you have already entered the formula. You will see a small black box at the bottom right of the selection range [see attached picture]
Click and drag this box out until you have populated the cells you want to have the copied formulas with the required values.
1st June 2012, 01:13 PM #7
That won't work for me! I think it is because it is a formula. If I just had
Originally Posted by DaveP
I could do as you suggest and it works fine. but the minute it becomes a formula that doesn't happen!
1st June 2012, 01:19 PM #8
Got it. I take out the equals sign. Then fill series and then do a replace to put the equals sign back in!
1st June 2012, 01:19 PM #9
How odd!. I have just used your formula [in one column only] and copied the values down with the following result [see attached]
Originally Posted by reggiep
Does this not work for you?
1st June 2012, 01:33 PM #10
I think that if you manually enter the first few rows, then highlight all of them and copy the formula down, Excel will carry on your +34 pattern. Might be wrong though...
By stupidusagi in forum Office Software
Last Post: 2nd October 2011, 06:42 PM
By elsiegee40 in forum Office Software
Last Post: 17th May 2010, 09:23 AM
By MrWestwood in forum Office Software
Last Post: 1st May 2009, 12:34 PM
By RabbieBurns in forum Office Software
Last Post: 7th September 2008, 12:53 AM
By MuppetQueen in forum Budgets and Expenditure
Last Post: 12th December 2005, 04:10 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)