+ Reply to Thread
Results 1 to 8 of 8

i'm sorry I don't know what topic it is, but please help to look on the picture.

  1. #1
    Forum Contributor
    Join Date
    03-05-2015
    Location
    Cambodia
    MS-Off Ver
    2016
    Posts
    110

    i'm sorry I don't know what topic it is, but please help to look on the picture.

    I use to set up this before but now i'm totally forgot how to set it. Please have a look in attached file and help me.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    10-29-2014
    Location
    udaipur, rajasthan
    MS-Off Ver
    2007
    Posts
    339

    Re: i'm sorry I don't know what topic it is, but please help to look on the picture.

    Hi Lekhna,

    i think you need to post a sample file for it, with expected result.

    Thank you
    If answer helped you say Thanks by Add Reputation

  3. #3
    Forum Contributor
    Join Date
    03-05-2015
    Location
    Cambodia
    MS-Off Ver
    2016
    Posts
    110

    Re: i'm sorry I don't know what topic it is, but please help to look on the picture.

    Hi,

    Acutally I want to set up like in attached excel file. on the narrow in row 1, I can select for topic appreal when I click on that narrow. but I don't know how to set that format.

    Can you go throug attached file and help me please.

    Thanks
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    10-29-2014
    Location
    udaipur, rajasthan
    MS-Off Ver
    2007
    Posts
    339

    Re: i'm sorry I don't know what topic it is, but please help to look on the picture.

    you need a drop down list only ?

  5. #5
    Forum Contributor
    Join Date
    03-05-2015
    Location
    Cambodia
    MS-Off Ver
    2016
    Posts
    110

    Re: i'm sorry I don't know what topic it is, but please help to look on the picture.

    yes, becuz I want to set many list, and then I just only select which one i need. it would be better than i key in everytime.

    Thanks

  6. #6
    Forum Contributor
    Join Date
    10-29-2014
    Location
    udaipur, rajasthan
    MS-Off Ver
    2007
    Posts
    339

    Re: i'm sorry I don't know what topic it is, but please help to look on the picture.

    ok,

    So in this case just type your list names in your sheet any where then go to data tab---then---data validation---then---select data validation----then--in allow field select List----then---in source--- give your name list range there... and done.

    validation.JPG

    hope it will help you.

  7. #7
    Forum Contributor
    Join Date
    03-05-2015
    Location
    Cambodia
    MS-Off Ver
    2016
    Posts
    110

    Re: i'm sorry I don't know what topic it is, but please help to look on the picture.

    :D it great

    :D :D :D thank you so much :D

  8. #8
    Forum Contributor
    Join Date
    10-29-2014
    Location
    udaipur, rajasthan
    MS-Off Ver
    2007
    Posts
    339

    Re: i'm sorry I don't know what topic it is, but please help to look on the picture.

    Great it helps you,

    thank you for reputation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Click on picture and run macro to replace existing picture with selected picture file
    By houseflipsheet in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-14-2014, 12:02 AM
  2. [SOLVED] example in the help topic
    By Lois Ann in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 08-01-2006, 07:20 PM
  3. [SOLVED] Help topic index
    By D.E.Phillips in forum Excel General
    Replies: 1
    Last Post: 06-06-2006, 05:35 PM
  4. Off Topic I Know But,
    By Martin Knight in forum Excel General
    Replies: 6
    Last Post: 08-11-2005, 02:05 AM
  5. Where do I find the help topic
    By Roberto in forum Excel General
    Replies: 2
    Last Post: 07-05-2005, 11:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1