Windows keyboard tips and tricks - Microsoft Support
Keystroke. What it does. Windows logo key + R Opens the Run command. Windows logo key + S Opens Search. Windows logo key + E Opens File Explorer. Alt + Tab. Opens Task Switcher, moving forward with each press of Tab, switching to that window on release
Unlicensed Product and activation errors in Office
Tip: In Windows 7, you can synchronize your computer clock with an Internet time server to keep the computer clock up to date.To do this, select the date or time in the bottom right-hand corner of your screen, and then select Change date and time settings.Select the Internet Time tab, select Change settings, select Synchronize with an Internet time server, and then select Update now.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Project Online Desktop Client, Publisher for Microsoft 365, Visio Plan 2, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016, Office 2016, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, InfoPath 2013
So verwenden Sie die App PC-Integritätsprüfung
Wenn Sie derzeit Windows 10 verwenden, bietet PC Health Check eine umfassende Eignungsprüfung für Ihr Gerät, um sicherzustellen, dass es die Mindestsystemanforderungen von Windows 11 erfüllt. Sie erhalten Informationen dazu, warum Ihr Gerät geeignet oder nicht geeignet ist, sowie Informationen dazu, was Sie tun können, wenn Ihr Gerät die Anforderungen nicht erfüllt.
Set up an authenticator app as a two-step verification method
Note: If you receive a prompt asking whether to allow the app to access your camera (iOS) or to allow the app to take pictures and record video (Android). select Allow so the authenticator app can access your camera to take a picture of the QR code in the next step.If you don't allow the camera, you can still set up the authenticator app as described in Manually add an account to the app.
Change the language Office uses in its menus and proofing tools
Under Proofing, if your language shows as Installed, you're ready to go.Otherwise press Not installed and Office will take you to a page where you can download the necessary Language Accessory Pack for that language. Follow the instructions on that page to download and install the pack, then come back to the Office Language Preferences dialog box to confirm that it's now installed.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Publisher for Microsoft 365, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, Outlook for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Excel for the web, Word for the web, PowerPoint for the web, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Publisher 2021, Office 2021, Excel 2021 for Mac, Word 2021 for Mac, Outlook 2021 for Mac, PowerPoint 2021 for Mac, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Publisher 2019, Office 2019, Excel 2019 for Mac, Word 2019 for Mac, Outlook 2019 for Mac, PowerPoint 2019 for Mac, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Publisher 2016, Office 2016, Excel for iPad, Word for iPad, PowerPoint for iPad, Excel for iPhone, Word for iPhone, PowerPoint for iPhone, Word for Android tablets, Excel for Android tablets, PowerPoint for Android tablets, Excel for Android phones, Excel for Windows Phone 10, Excel Mobile, PowerPoint for Android phones, PowerPoint for Windows Phone 10, PowerPoint Mobile, Word for Android phones, Word for Windows Phone 10, Word Mobile
Repair an Office application - Microsoft Support
The steps to access the repair tool vary depending on your operating system. Right-click the Start button (lower-left corner) and select Apps and Features on the pop-up menu.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Publisher for Microsoft 365, Visio Plan 2, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016, Office 2016, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Small Business Admin, Office 365 operated by 21Vianet - Admin, InfoPath 2013, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin
Change the capitalization or case of text - Microsoft Support
PowerPoint for the web supports changing case. See the procedure below. Word for the web doesn't support changing case. Use the desktop application to open the document and change text case there, or else you can manually change the casing of text in Word for the web.
Applies To: Word for Microsoft 365, PowerPoint for Microsoft 365, Word for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Word for the web, PowerPoint for the web, Word 2021, PowerPoint 2021, Word 2021 for Mac, PowerPoint 2021 for Mac, Word 2019, PowerPoint 2019, Word 2019 for Mac, PowerPoint 2019 for Mac, Word 2016, PowerPoint 2016
What's the difference between Microsoft 365 and Office 2021?
Microsoft 365 is a subscription service that makes sure you always have the most up-to-date modern productivity tools from Microsoft. There are Microsoft 365 plans for home and personal use, as well as for small and midsized businesses, large enterprises, schools, and non-profits.
Applies To: Office 2021, Office 2021 for Mac, Office 2019, Office 2019 for Mac, Microsoft 365 for home, Office for business, Microsoft 365 admin
VLOOKUP function - Microsoft Support
Argument name. Description. lookup_value (required). The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in the table_array argument. For example, if table-array spans cells B2:D7, then your lookup_value must be in column B.. Lookup_value can be a value or a reference to a cell.. table_array (required)
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
Create workbook links - Microsoft Support
Important: Workbook links are considered potentially unsafe and must be enabled when you open a formula workbook.When you open a formula workbook, click Enable Content in the Message Bar to allow the workbook links to function. If you don't, Excel keeps the most recent values and disables refreshing the links with values from the data workbook.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016