Search results
With Microsoft 365 for the web you can edit and share Word, Excel, PowerPoint, and OneNote files on your devices using a web browser.
- Word, Excel, PowerPoint
Craft great-looking resumes, newsletters, and documents...
- Microsoft Office Kostenlos
Mit Microsoft 365 im Web können Sie Word-, Excel-,...
- Buy Microsoft 365 Personal
Microsoft Defender also brings valuable device protection to...
- Word, Excel, PowerPoint
Learn and practice dozens of Excel functions and tools online for free - from beginners to pro level, without the need to download any files.
Microsoft Excel is the industry leading spreadsheet software program, a powerful data visualization and analysis tool. Take your analytics to the next level with Excel.
People also ask
How do you create a list in Microsoft Lists?
What are the benefits of using Microsoft Lists?
How do you sync Microsoft Lists with Microsoft Excel?
Can you import an Excel workbook into Microsoft Lists?
Easily edit Microsoft Excel spreadsheets online without converting them, and layer on Sheets’ enhanced collaborative and assistive features like comments, action items, and Smart Fill.
- Overview
- Need more help?
- See also
You can help people work more efficiently in worksheets by using drop-down lists in cells. Drop-downs allow people to pick an item from a list that you create.
1.In a new worksheet, type the entries you want to appear in your drop-down list. Ideally, you’ll have your list items in an Excel table. If you don’t, then you can quickly convert your list to a table by selecting any cell in the range, and pressing Ctrl+T.
Notes:
2.Select the cell in the worksheet where you want the drop-down list.
3.Go to the Data tab on the Ribbon, and then Data Validation.
4.On the Settings tab, in the Allow box, select List.
You can always ask an expert in the Excel Tech Community or get support in Communities.
Our Microsoft Excel online training courses from LinkedIn Learning (formerly Lynda.com) provide you with the skills you need, from the fundamentals to advanced tips.
When creating a Microsoft list, you can save time by importing an existing Excel spreadsheet. This method converts the table headings to columns in the list, and the rest of the data is imported as list items. Importing a spreadsheet is also a way to create a list without the default Title column.
