In Excel- Value List Creation

1.  Open Excel

2. Enter the values needed in the list in a worksheet.

3. Select all the cells,  

4. Then select Formula menu - Name Manager  - New

5.  Enter a Name for the range and Scope as Workbook.

 

Next you need to click on the cell, where we want the predefined list.

 

1. Data - Data validation - data validation.

2. Allow - LIST

3 Source :-   =<name>

Temperory profile issue...

 

• Start your computer and login with temp profile
• Click on START and then type RUN in search box and then click on RUN from found results, then you will get a RUN BOX.
• Type a command in run box “regedit” and hit enter or click on OK, then you will appear a registry edition
•  
• • HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList
  • You will get the similar keys under “profile list”, however one key may shows as end with “.bak”
  • “.bak” is a your original profile Example: “SID-1213428093-345618312-2235-148770.bak”
  • “Without .Bak” is a your current temp profile (which currently logged on with this profile) Example:“SID-1213428093-345618312-2235-148770″
  • You have to Rename both entries
  • Rename the key “Without .Bak“, rename it and put “.temp” in the end
    SID-1213428093-345618312-2235-148770″
                                      to
    SID-1213428093-345618312-2235-148770.temp”
  • Rename the key with “.Bak“,  rename it and remove “.bak” from the end
    SID-1213428093-345618312-2235-148770.bak”
                                     to
    “SID-1213428093-345618312-2235-148770”

  

• That’s it, Now click on start and click on log off
• After log off, restart the computer once.
• After restart it will automatically get your old (original) profile
•