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.

Computers & Internet Logo

Related Topics:

Related Questions:

5 Answers

excel sheet has been lost how to recover


Lost Excel file can be recovered from:
  1. Recycle Bin - If you have deleted the file with normal delete.
  2. Backup - If have maintained the backup of file.
  3. Email - It may possible that you have mailed the file to someone.
  4. 3rd Party Recovery Software - Recuva, Stellar Data Recovery ...

Oct 29, 2012 | Microsoft Office Excel (License Only)...

1 Answer

How To Save A Workbook In Another File Format? Most of the time, users prefer to save the workbook in the current file format as a.xlsx extension. But often, it's the case where you may need to save a workbook in other file formats, such as the file format of an earlier version of Excel, a text file, or a PDF or XPS file. MS Office technical support experts have suggested users that while saving their workbook in another file format, they need to follow few of its formatting, data, and other essentials features which may not be saved well. For a list of various file formats, also known as various file types, one can easily open or save in Excel 2013 Steps to save a workbook in another file format Step1: Accessing the workbook ·Open and get access to the workbook which you wish to save. Step2: One DRIVE option ·Under the 'Places' section, simply pick up the place where you wish to save the workbook. For example, if you choose the "OneDrive" to save it to the Web location or in the Computer to save it in a local folder, you can save it as your Documents. Step3: Save As dialogue box ·In the "Save As' dialog box, one is required to navigate to the location according to their choices. Step 4: Working with the file formats ·In the Save as type list, just click on the file format which you wish to save and then click the arrows to easily scroll to the file formats that aren't yet visible in the list as suggested by MS Office tech support team members. A note of caution: ·The file formats that you'll see may vary, depending on what type of sheet you are actively working in your workbook (a worksheet, chart sheet, or other type of sheet). ·In the File name box, try to accept a specific suggested name or simply type a new name for your workbook. Fix your issues related to MS Office to get your issues resolved at much faster rates. We are accessible for our users at MS Office customer support Toll-Free 1-800-213-8289 department as and when needed

Apr 28, 2017 | Miscellaneous

2 Answers

How we protect the excel sheet by password.


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

Dec 09, 2010 | Microsoft Office Computers & Internet

1 Answer

I WOULD LIKE TO CHANGE MY EXCEL FILE IN READ ONLY MODE


amjbritto,

There are two ways to do this, depending on what extent you want to protect the spreadsheet.

Windows Read-Only method:
  1. Save and Close the Excel file.
  2. Using Windows Explorer, locate the Excel file in its folder.
  3. Right-click on the file name
  4. Click on "Properties" at the bottom of the drop-down window.
  5. Check the [x] Read-Only box and [OK]
  6. * DONE *
Excel "Protect" Method:

  1. Open the Excel spreadsheet that you want to protect
  2. On the top menu, select [Tools]
  3. Click [Protection] on the drop-down menu
  4. Select [Protect Workbook]
  5. Check [x]Structure and [x]Windows
  6. Enter a password if you wish, but remember it!
  7. Click [OK]
  8. Save and close the spreadsheet and test the protection.
  9. *DONE *
Thanks for using FixYa.

Oct 06, 2010 | Microsoft Excel for PC

1 Answer

excel-template


Open a blank workbook in Excel and click "save as" option select "Template" from the drop-down list and save it

Hope this helps,

CynosureboY

Sep 13, 2008 | Microsoft Excel for PC

Not finding what you are looking for?

1,968 people viewed this tip

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2885 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18408 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Loading...