Overview of formulas in Excel
Note: Formulas in Excel always begin with the equal sign. Select a cell or type its address in the selected cell. Enter an operator. For example, – for subtraction. Select the next cell, or type its address in the selected cell. Press Enter. The result of the calculation appears in the cell with the formula.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007
Virus & threat protection in Windows Security
Windows Security will send notifications about the health and safety of your device. You can turn these notifications on, or off, on the notifications page. In Virus & threat protection, under Virus & threat protection settings, select Manage settings, scroll down to Notifications and select Change notification settings.
Applies To: Microsoft account dashboard
How do I create macros?
In the list under the button that you want to reassign, select Macro. Click Create a new Macro. An empty macro is created and added to the macro list. In the Name box, type the name of the new macro. Click in Editor, and enter your macro. You can record events such as keystrokes, mouse clicks, and delays between actions.
Block pop-ups in Microsoft Edge
The Microsoft Edge feature that blocks pop-ups is effective in preventing websites from automatically opening a new window or tab, or a partial window on top of your current web page. This feature is turned on by default. There are many different types of pop-ups, including advertisements, notices, offers, or alerts that can appear at various times on any web page. Some can be helpful, such as ...
Applies To: Microsoft account dashboard
Samsung Gallery and OneDrive
Notes: Samsung Gallery connection to OneDrive is available for certain models and markets only. Your Samsung Gallery can only be connected to OneDrive personal accounts (i.e. not OneDrive for work or school users).
Applies To: OneDrive (home or personal)
Open Snipping Tool and take a screenshot
Take a screenshot with the Snipping Tool. Rectangular mode is selected by default. You can change the shape of your snip by choosing one of the following options in the toolbar: Rectangular mode, Window mode, Full-screen mode, and Free-form mode.
Pair a Bluetooth device in Windows
Here's how: In Settings. Select Start > Settings > Bluetooth & devices, and then turn on Bluetooth . In quick settings. To find the quick setting for Bluetooth, select the Network icon ( or ) next to the time and date on the right side of your taskbar. Select Bluetooth to turn it on.
Sign in to SharePoint
Sign in to SharePoint. SharePoint is a browser-based app that you connect to through your web browser, like so: Go to office.com, and sign in to your work or school account. In the upper left corner of the window, select the app launcher > All apps > SharePoint. Tip: If you don't see the SharePoint app under All apps, use the Search box near ...
Applies To: SharePoint in Microsoft 365
Device protection in Windows Security
Windows Security provides built-in security options to help protect your device from malicious software attacks. To access the features described below, tap the Windows Start button, type windows security, select it from the results, and then select Device security. Notes: What you actually see on the Device security page may vary depending ...
Map a network drive in Windows
Windows 11 Windows 10. Map a network drive to get to it from File Explorer in Windows without having to look for it or type its network address each time. Open File Explorer from the taskbar or the Start menu, or press the Windows logo key + E. Select This PC from the left pane. Then, on the File Explorer ribbon, select More > Map network drive.