answersLogoWhite

0


Best Answer

If your list is in a column with each item in a separate cell, simply insert a new row and put your word in the blank cell created by the new row.

If your list is a long text string all in one cell, press the F2 key to open the in-cell text editor, use the arrow keys to move the cursor to the desired position, and type in your word. I think the question is "How to add another item in the list that is already available?" 1. Select the cell which contains the list (Say, D1). 2. From the Menu Bar, Data--> Validation 3. In the data validation dialog box, "Settings" Tab, you will see 2 fields, "Allow" & "Source" 4. You should be able to see the value as "List" in the "Allow" drop-down. 5. If the "Source" field has the items of the list directly (Items that were available in D1 cell), you can just add another item to the list by typing in after a comma wherever necessary & click "OK". 6. Or, if the "Source" field has the cell reference where the items of the list are available, Go to those cells & insert your item or word you want to be available in the list & then follow steps 1 to 4. Then, click on the look-up icon near "Source" field & select the new cell reference where you added one more item & click "OK"

User Avatar

Wiki User

15y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you insert a Word in a list in Microsoft Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

List five tasks in the Insert tab that are common to Microsoft Word 2007 and Microsoft Excel 2007?

clip art, hyperlink, text box, word art, symbol


List specific computer applications with which you are proficient?

Microsoft Word and Excel


List 5 tasks in the insert tab that are common to both Microsoft word and Microsoft excel?

clip board, text box, symbol, hyperlink, word art


What are the list of latest application software?

The list of the latest application software is Windows Microsoft Word, Windows Microsoft Excel, Dubail Word and Engineering Applications Dual Processor, and Photoshop Pro.


How do you put a multiple filter in Microsoft Excel spreadsheet?

It is not possible to have multiple autofilters in one worksheet. What you can do is select your range(s) and convert them to a list/table by going to Data->List in Excel 2003 or Insert->Table in Excel 2007. This will give you the functionality of an autofilter, but it can be applied to several ranges within the same worksheet.


How do you Display a list of programs Microsoft Equation etc used to create objects that can be added to a Word document Object Insert?

yeas


How do you answer interview questions about Microsoft office skills?

Certainly! Here are some interview questions related to Microsoft Word and Microsoft Excel that you might excel interview encounter during an interview: Microsoft Word Interview Questions: What is Microsoft Word used for, and how have you used it professionally? Explain the difference between "Save" and "Save As" in Microsoft Word. How would you create a bulleted list in a Word document? What is Track Changes, and how can it be useful in collaborative document editing? Describe how you would insert a table into a Word document. How can you change the page orientation from portrait to landscape in Microsoft Word? What is a header and footer in Word, and when might you use them? How would you adjust line spacing in a Word document? What is a mail merge, and how can it be used to personalize documents? Explain how to add page numbers to a Word document. Microsoft Excel Interview Questions: Why is Microsoft Excel important in the business context, and how have you used it professionally? Explain the purpose of cells, rows, and columns in Excel. How can you format cells to display currency values with two decimal places? What is the difference between a worksheet and a workbook in Excel? Describe how you would freeze panes in an Excel worksheet. How do you create a chart in Excel to visualize data? Explain the concept of relative and absolute cell references in Excel formulas. What is the SUM function, and how would you use it to add a range of numbers? How can you sort data in Excel based on a specific column? Explain what a PivotTable is and how it can be useful for data analysis. Remember that interview questions can vary based on the specific role and level of proficiency required for the job. Practice and familiarize yourself with these concepts to confidently address these questions during your interview.


How do you get on Microsoft Excel?

If you have already bought and downloaded the Microsoft Office tools, you access them by clicking 'Start' in the bottom left-hand corner of your screen, then scrolling through the programs list until you see 'Microsoft Office'. When you scroll over it, a drop down list will appear. Click 'Microsoft Office Excel'.


How does a company create a mailing list database?

A mailing list database can be created in a variety of ways depending on what type of software the company is using in their office. Microsoft Office has several products available for creating a mailing list, and it can be done with programs such as Microsoft Word, Excel or Access.


What ribbon tab is used to insert a citation?

The "References" ribbon tab is used to insert a citation in Microsoft Word. You can find options for adding citations and managing your source list within this tab.


How do you type degrees into Microsoft word?

Go to the "Insert" tab. At the right end of the insert ribbon, you will see a button labeled "Symbol". Click. Look in the list that appears. If not there, go to "More Symbols" Click.


When using the Insert Function button or the AutoSum list arrow it is necessary to type the equal sign?

Not in Excel.