excell

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excell

Excell

resolvedResolved · Low Priority · Version Standard

Sue has attended:
Excel Introduction course

Excell

How do I add a drop down list to a cell?

How do I use goal search?

RE: Excell

Hello Sue,
I hope you enjoyed your Excel training with us, and thank you for your questions.

To answer your first question, if you want to add a drop down list to a cell in Excel, you need to create a Data Validation. To do this, first click on the cell where you wan the drop down box to be, then go to the Data menu, then choose Validation. In the new dialog box, choose "List" from the "Allow" drop down box. Then in the "Source" box, type the list of words you want in your drop down box, separated by a comma. Make sure there is a tickmark for "In-cell dropdown." When you're done, click OK. You should now see your dropdown list in the cell. If you try to type any other text into the cell, other than what you have designated in your validation, you will get an error message. You can always update your list of dropdown words by going back to the Data Validation dialog box.

To use the Goal Seek function, you must first set up a formula that relies on other cell references. A good Goal Seek example is a PMT (loan payment) formula. If you know what you want your monthly payment to be, you can back peddle using the Goal Seek, to check on different interest rates, loan terms or principle amounts to get the right payment. You can find the Goal Seek under the Tools menu.

I hope this resolves your question. If it has, please mark this question as resolved. If you require further assistance, please reply to this post. And please feel free to ask any other questions you may have.

Have a great day.

Regards,
Mara
Microsoft Office Specialist Master Trainer


 

Excel tip:

Apply currency format quickly in Excel

To quickly apply the currency format to cell in your spreadsheet, select (highlight) the cells you wish to apply currency format to, then use Ctrl + Shift + $

This will apply a pounds symbol even though the $ key is pressed.

View all Excel hints and tips


Server loaded in 0.1 secs.