Create a drop-down list - Microsoft Support
After you create your drop-down list, make sure it works the way you want. For example, you might want to check to see if Change the column width and row height to show all your entries.. If the list of entries for your drop-down list is on another worksheet and you want to prevent users from seeing it or making changes, consider hiding and protecting that worksheet.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Download and install or reinstall Microsoft 365 or Office 2021 on a PC ...
If you still don't see an option to install Microsoft 365 on the Microsoft 365 Software page, it's possible your admin hasn't assigned a license to you. Find out if you have a license to install Microsoft 365. If you're a student or teacher and your institution didn't give you a license, find out if you're eligible to Get Microsoft 365 for free.
Applies To: Office 2021, Office 2021 for Mac, Office 2019, Office 2019 for Mac, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Admin, Microsoft 365 for Mac, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin
Delete files or folders in OneDrive - Microsoft Support
Open the Shared view, and select the files or folders you want to remove by pointing to each item and clicking the circle check box that appears.. To remove an item shared by other users, select the item, then select Remove from shared list on the bar at the top of the page.. To remove an item from Shared by me, select the item, select Information in the upper-right corner to open the Details ...
Applies To: OneDrive (work or school), OneDrive (home or personal), OneDrive (work or school) operated by 21Vianet, OneDrive for Mac, OneDrive for Windows
Install Quick Assist - Microsoft Support
To pin Quick Assist to your taskbar so you can quickly get back to it, after Quick Assist is open, right-click (or press and hold) the icon on your taskbar > Pin to taskbar. If the old app icon still appears on your device, make sure you select the new app icon.
KB5027397: Feature update to Windows 11, version 23H2 by using an ...
Summary. Windows 11, versions 22H2 and 23H2 share a common core operating system with an identical set of system files. Therefore, the new features in Windows 11, version 23H2 are included in the latest monthly quality update for Windows 11, version 22H2 but are in an inactive and dormant state.
App permissions - Microsoft Support
Here's more info on what permissions allow an app to do: Access all your files, peripheral devices, apps, programs, and registry: The app has the ability to read or write to all your files (including documents, pictures, and music) and registry settings, which allows the app to make changes to your computer and settings. It can use any peripheral devices that are either attached or part of ...
Delete a page in Word - Microsoft Support
To delete a page that contains text, graphics, or empty paragraphs, select the content to delete, and press Delete.You can also do this:
Applies To: Word for Microsoft 365, Word for Microsoft 365 for Mac, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016
Use System Restore - Microsoft Support
Use System restore to make restore points when you install a new app, driver, or Windows update, and when you create a restore point manually. Restoring won’t affect your personal files, but it will remove apps, drivers, and updates installed after the restore point was made. To go back to a restore point:
XLOOKUP function - Microsoft Support
Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Keyboard shortcuts in Excel - Microsoft Support
To do this. Press. Move to the Tell me or Search field on the ribbon and type a search term for assistance or Help content.. Alt+Q, then enter the search term. Open the File menu.. Alt+F. Open the Home tab and format text and numbers and use the Find tool.. Alt+H. Open the Insert tab and insert PivotTables, charts, add-ins, Sparklines, pictures, shapes, headers, or text boxes.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones, Excel Mobile