Tip & How-To about Microsoft Excel Computers & Internet
Excel - Drop Down List
Ever wish that you didn't have to type out the same thing over
and over again? Well you can save time by using Excel's drop down list!
Drop Down Preparation
Imagine that we are creating an Excel spreadsheet to document
our purchases from the grocery store. For each purchase we want to mark
down the name of the food and the type of the food.
The way a drop down list works in Excel is that it takes
values from some place on your spreadsheet and uses them to populate the
options in the list. Lucky for us, the type of food is a perfect
opportunity to use a drop down list!
In cells A1 through A7 enter the type of food that will
be used for the drop down list.
Creating a Drop Down List
Now that we have a source for our drop down list, we can
create a begin to create our drop down.
1.
Select
cells D2 though D20 (We will be creating a drown down list for each cell in
this range)
2.
Click
the Data menu and select Validation
3.
Choose
List from the Allow drop down menu
4.
Click
the Source button that appears to the right of the textfield
5.
Select
our source cells A1 though A7
6.
Press
Enter and Click OK
Testing Your Drop Down
All of your cells in the Type column should now have a
drop down list. To test to see if your drop down works, click on cell D2
and then click on the downward facing arrow and see if all the types of
food are available.
follow these steps to password-protect Excel file
Step 1: Save your *.xls Excel file
Point to the File Menu, click save as and input the file name then the *.xls file is saved on your local disc. Point to "Tools" - "Options". When the "Options" multi-tabbed dialog box appears, click the "Security" tab.
Step 2: Choose the password protect type
• If you don't wish other users to view your Excel workbook, enter a password in the "Password to open" box, and then click OK.
• If you agree other users to view your Excel workbook but don't want them make changes to the workbook, type a password in the "Password to modify" box.
• If you wish to use a different encryption settings type, click Advanced, choose an encryption setting type you want in the list, and then click OK. And you can also specify the number of characters in the Choose a key length box.
Step3: Confirm your password
After type your password, a "Confirm Password" box will prompted, retype your passwords to confirm, then click OK.
Step4: Resave the Excel spreadsheet.
After password protecting your Excel file, click Save. All the steps are finished.
read more:
http://blog.recoverlostpassword.com/how-to-password-protect-microsoft-office-excel-2003.html
×