Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy sequential formula
Hi
| | I have a formula repeating itself across coulumns in 1 row, =c2, =d2, =f2, =g2 | | so every 3rd cell is skipped. Even when i highlight the above formula and | drag across the sequence is not picked up. There are 90 coulumns i need this | formula for and i don't want to do each of them one at a time. | | Any clues? | | Cheers -- Nenagh |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy sequential formula
Nenagh --
OK, not perfect, but better than typing the formula 90 times. Create the first two formulas, then copy the three cells -- two with formulas, one blank. Then paste every third cell. You'll have to do it 30 times, but that's 30 times better than 90... "Nenagh" wrote: Hi | | I have a formula repeating itself across coulumns in 1 row, =c2, =d2, =f2, =g2 | | so every 3rd cell is skipped. Even when i highlight the above formula and | drag across the sequence is not picked up. There are 90 coulumns i need this | formula for and i don't want to do each of them one at a time. | | Any clues? | | Cheers -- Nenagh |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy sequential formula
Enter the formulas in the first two cells, then select these two cells plus
the third adjacent cell. Now left-click on the handle (the small balck square) in the lower right corner of the box outlining the three selected cells and drag it to the right for as many columns as you require. -- EarlyBirdie "Nenagh" wrote: Hi | | I have a formula repeating itself across coulumns in 1 row, =c2, =d2, =f2, =g2 | | so every 3rd cell is skipped. Even when i highlight the above formula and | drag across the sequence is not picked up. There are 90 coulumns i need this | formula for and i don't want to do each of them one at a time. | | Any clues? | | Cheers -- Nenagh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel, how to copy conditional formats in sequential order 1,2,3 | Excel Worksheet Functions | |||
sequential formula copying | Excel Discussion (Misc queries) | |||
Sequential formula | Excel Worksheet Functions | |||
Non-sequential VLOOKUP function -OR- sequential sort of web query | Excel Worksheet Functions | |||
Sequential names on Sequential pages | Excel Worksheet Functions |