How to fetch data from first row

[aadityapatel1984]

I have one excel sheet in which first row having multiple columns how to fetch cell data from each column of first row?

[NBVC]

We may need a bit more specifics.....

but here are a couple of ways....

You can simply point to the first cell, then copy across.

e.g. =Sheet1!A1 and copy across.

or

=INDEX(Sheet1!1:1,COLUMNS($A$1:$A1)) copied across.

where Sheet1 is sheet you have the data in.