Create, load, or edit a query in Excel (Power Query) - Microsoft Support
Tip Sometimes the Load To command is dimmed or disabled. This can occur the first time you create a query in a workbook. If this occurs, select Close & Load, in the new worksheet, select Data > Queries & Connections > Queries tab, right click the query, and then select Load To.Alternatively, on the Power Query Editor ribbon select Query > Load To. ...
Applies To:
Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Zip and unzip files - Microsoft Support
Press and hold (or right-click) the file or folder, select (or point to) Send to, and then select Compressed (zipped) folder. A new zipped folder with the same name is created in the same location.
What's new in Word 2021 for Windows - Microsoft Support
Word 2021 for Windows enables you to create compelling content and includes co-authoring, new stock media from the Office Premium Creative Content collection, and new Draw tab additions such as Point Eraser, Ruler, and Lasso.
Applies To:
Word 2021
Multiply and divide numbers in Excel - Microsoft Support
Multiply numbers in different cells by using a formula. You can use the PRODUCT function to multiply numbers, cells, and ranges.. You can use any combination of up to 255 numbers or cell references in the PRODUCT function. For example, the formula =PRODUCT(A2,A4:A15,12,E3:E5,150,G4,H4:J6) multiplies two single cells (A2 and G4), two numbers (12 and 150), and three ranges (A4:A15, E3:E5, and H4 ...
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
Install or reinstall OneNote for Windows - Microsoft Support
Note: If you installed OneNote before you install and activate Microsoft 365 or Office 2019, then the end-user license that appears in OneNote will display as “Home and Student.”As soon as you’ve activated your edition of Microsoft 365 or Office 2019 and then restart OneNote, your license will be applied to OneNote, even though the default license for it may still be displayed as “Home ...
Applies To:
OneNote for Microsoft 365, OneNote 2016, Office for business
Find and remove duplicates - Microsoft Support
In the box next to values with, pick the formatting you want to apply to the duplicate values, and then select OK.
Applies To:
Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Install and set up Office on an iPhone or iPad - Microsoft Support
There are two ways to get Office on your iPhone: Tap the button below to install the new Office app for iOS that combines Word, Excel, and PowerPoint into a single app, which introduces new mobile-centric features to view, edit, and share files without the need to switch between multiple apps.
Applies To:
Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, OneNote 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, OneNote for Microsoft 365 for Mac, Excel for the web, OneNote for the web, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Office 2021, OneNote 2021, Excel 2021 for Mac, Word 2021 for Mac, Outlook 2021 for Mac, PowerPoint 2021 for Mac, OneNote 2021 for Mac, Office 2021 for Mac, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Office 2019, Excel 2019 for Mac, Word 2019 for Mac, Outlook 2019 for Mac, PowerPoint 2019 for Mac, OneNote 2019 for Mac, Office 2019 for Mac, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, OneNote 2016, Office 2016, PowerPoint 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 - Small Business Admin, Office 365 operated by 21Vianet - Admin, Office app for iOS, Outlook Web App, Skype for Business for iPad
Eingabeort für den Office-Product Key - Microsoft-Support
Schritt 1: Wechseln Sie zu www.microsoftstore.com, und melden Sie sich (oben rechts) mit dem Microsoft-Konto an, das Sie für den Kauf von Office verwendet haben.. Schritt 2: Nachdem Sie sich angemeldet haben, wählen Sie oben rechts Ihren Namen und dann Bestellverlauf aus.. Schritt 3: Suchen Sie den Einmalkauf von Office oder der einzelnen Office-App, und wählen Sie dann Office installieren ...
Applies To:
Office 2021, Office 2021 for Mac, Office 2019, Office 2019 for Mac, Office 2016, Microsoft 365 for home, Office.com
Share your network printer - Microsoft Support
In Windows 10, you can share your printer with many PCs on your network. To share a printer from the PC that the printer is connected to (the primary PC) with secondary PCs that the printer is not connected to, you must set up sharing settings for the printer, connect the printer to the primary PC (either wirelessly or by using a USB cable), and then turn on the printer.
Mouse and keyboard problems in Windows - Microsoft Support
Check the device. If the device doesn't appear to work at all (no lights appear on the device when it’s plugged in, or the cursor doesn't move or doesn't appear on the screen), connect the device to another PC and make sure the device works on that PC.