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
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
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.
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
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
Insert a table of contents
Put your cursor where you want to add the table of contents. Go to References > Table of Contents. and choose an automatic style. If you make changes to your document that affect the table of contents, update the table of contents by right-clicking the table of contents and choosing Update Field. To update your table of contents manually, see ...
Applies To: Word for Microsoft 365, Word for Microsoft 365 for Mac, Word for the web, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016, Word 2016 for Mac, Word 2013, Word 2010, Word 2007
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)
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.
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.