WEEKDAY function - Microsoft Support
This article describes the formula syntax and usage of the WEEKDAY function in Microsoft Excel.. Description. Returns the day of the week corresponding to a date. The day is given as an integer, ranging from 1 (Sunday) to 7 (Saturday), by default.
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
How to search in Outlook - Microsoft Support
When you type in an email address, for example cheryl.parsons64@yahoo.com, Outlook returns all email messages that contain that email address anywhere in the subject, message body, or many types of attachments as well as messages from that email address.To limit your search results to emails from an email address, type from:cheryl.parsons64@yahoo.com in the search box.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook 2013
Display or hide formulas - Microsoft Support
Select the Review tab, and then select Unprotect Sheet.If the Unprotect Sheet button is unavailable, turn off the Shared Workbook feature first.. If you don't want the formulas hidden when the sheet is protected in the future, right-click the cells, and select Format Cells.On the Protection tab, clear the Hidden check box.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Copy visible cells only - Microsoft Support
Tip: To copy a selection to a different worksheet or workbook, click another worksheet tab or switch to another workbook, and then select the upper-left cell of the paste area.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Show the Developer tab - Microsoft Support
After you show the tab, the Developer tab stays visible, unless you clear the check box or have to reinstall a Microsoft 365 program.. The Developer tab is the place to go when you want to do or use the following:. Write macros.
Applies To: Excel for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Visio Plan 2, Excel 2021, Outlook 2021, PowerPoint 2021, Visio Professional 2021, Visio Standard 2021, Excel 2019, Outlook 2019, PowerPoint 2019, Visio Professional 2019, Visio Standard 2019, Excel 2016, Outlook 2016, PowerPoint 2016, Visio Professional 2016, Visio Standard 2016
Copy the window or screen contents - Microsoft Support
Capture screen shots to use in your documents. For more details and instructions, see Use Snipping Tool to capture screenshots.. Use the PRINT SCREEN key. Pressing PRINT SCREEN captures an image of your entire screen and copies it to the Clipboard in your computer's memory.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Project Online Desktop Client, Publisher for Microsoft 365, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, SharePoint Designer 2007
Erstellen von Dropdownlisten - Microsoft-Support
Wählen Sie die Registerkarte Fehlerwarnung aus .. Wenn eine Nachricht angezeigt werden soll, wenn jemand etwas eingibt, das nicht in Ihrer Liste enthalten ist, aktivieren Sie das Kontrollkästchen Fehlerwarnung anzeigen, nachdem ungültige Daten eingegeben wurden , wählen Sie eine Option aus dem Feld Format aus, und geben Sie einen Titel und eine Nachricht ein.
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 an Xbox profile | Xbox Support
If you already have a Microsoft account that you use to sign in to other Microsoft services (such as Windows, Outlook, OneDrive, Office, MSN, and Skype), use that account to create your Xbox account as well.
Show or hide gridlines on a worksheet - Microsoft Support
Gridlines are the faint lines that appear around cells to distinguish them on the worksheet. By default, gridlines are displayed in worksheets using a color that is assigned by Excel. Gridlines are always applied to the whole worksheet or workbook, and can't be applied to specific cells or ranges.
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
How to use alarms and timers in the Clock app in Windows 10
Alarms and timers work even if the app is closed or your device is locked. If you see a warning that notifications only show if the device is awake, make sure your device doesn’t go to sleep (Go to Start > Settings > System > Power & sleep to adjust your device’s sleep settings).