Data in each alternative cell

A

Anmol786

New member
Joined
Oct 7, 2014
Messages
36
Reaction score
0
Points
0
Suppose i want to copy each cell data in an alternative cell by formula how can i do it

i have attached sample file where i have done it manually

now want to use formula for doing it autimatically

plz suggest
 

Attachments

  • Alternative cell data.xlsx
    8.3 KB · Views: 10
Just leave every other cell blank by not entering anything there! Seems there is more to the question than you are giving.
 
i can do it manually but same thing i have to type by "pressing enter, then copy and past, then again enter"
but if there is a formula for drop-down plz inform
 
use formula
=IF(MOD(ROW(),2)=0,100,"")
 
No, you select every target cell use the Ctl key, then type 100 and hit Ctl-Enter.
 
Not really, that would just show the results, not how to do it.
 
Data in alternative cell

Bob Phillips said:
Not really, that would just show the results, not how to do it.
Click to expand...
Sir
Ur formulla is useful
but i want same data in alternative cell plz thats y

give such a formula if i drop down the list data will be put skipping one cell in between

thanks
 
It wasn't a formula, it was selecting all cells using Ctl-Click and then type 100 and hit Ctl-Enter.
 
Bob Phillips said:
It wasn't a formula, it was selecting all cells using Ctl-Click and then type 100 and hit Ctl-Enter.
Click to expand...


Ok nice to have obtained the way to fill all selected cells

but show now how to skip one cell after filling each cell
(alterntate cell data)

will u plz
 
You must log in or register to reply here.
Back
Top