copy sequential formula

[Nenagh]

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

 

[Stefan B Rusynko]

Suggest you try an Excel Newsgroup
- this is a FrontPage newsgroup

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| 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