Results 1 to 2 of 2

Thread: How to fetch data from first row

  1. #1

    How to fetch data from first row



    Register for a FREE account, and/
    or Log in to avoid these ads!

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

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,429
    Articles
    0
    Excel Version
    Excel 2016
    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.


Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •