Create, edit, and manage connections to external data
Note The Workbook Connections dialog box is available in Excel stand-alone versions 2010, 2013, and 2016, but was replaced in Microsoft Office 365 for Excel and Excel stand-alone version 2019 with the Queries & Connections pane.. The Workbook Connections dialog box (Select Data > Connections) helps you manage one or more connections to external data sources in your workbook.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007
Using tags in Teams
Team owners can choose which members of their team are allowed to add tags. Select Teams on the left side of the app and find your team in the list. Go to More options , select Manage team , choose the Settings tab, and then navigate to the Tags section. Here you can control whether team members or team owners can manage tags.
Applies To: Microsoft Teams
Undo, redo, or repeat an action
Undo an action. Press + Z until you've fixed the issue.. Or, click Undo in the upper-left corner of the ribbon.. You can't undo some actions, such as clicking commands on the File menu or saving a file. If you can't undo an action, the Undo command changes to Can't Undo.. To undo several actions at the same time, click the arrow next to Undo, select the actions in the list that you want to ...
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Excel for Microsoft 365 for Mac, Word 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, PowerPoint 2021, Excel 2021 for Mac, Word 2021 for Mac, PowerPoint 2021 for Mac, Excel 2019, Word 2019, PowerPoint 2019, Excel 2019 for Mac, Word 2019 for Mac, PowerPoint 2019 for Mac, Excel 2016, Word 2016, PowerPoint 2016, Excel 2016 for Mac, Word 2016 for Mac, PowerPoint 2016 for Mac, Excel 2013, Word 2013, PowerPoint 2013, Excel 2010, Word 2010, PowerPoint 2010, Excel 2007, Word 2007, PowerPoint 2007, Excel for Mac 2011, Word for Mac 2011, PowerPoint for Mac 2011
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
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.
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.
Clear or remove a filter
Clear a filter from a column. Click the Filter button next to the column heading, and then click Clear Filter from <"Column Name">. For example, the figure below depicts an example of clearing the filter from the Country column. Note: You can't remove filters from individual columns. Filters are either on for an entire range, or off.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013
A file is in a different format than its extension indicates in Excel
When you open a file in Excel, you get an message that the file name extension doesn't match the actual file format. For example, the file has an .xlsx file name extension but it's really a text file and should have a .txt file name extension. Before you click Yes to open the file, you may want to consider the reasons why the file might have an ...
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel Starter 2010
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
Remove specific prevalent malware with Windows Malicious Software ...
Click Start , point to All Programs, and then click Windows Update. In the left pane, click Change settings. Click to select Install updates automatically (recommended). Under Recommended updates, click to select the Give me recommended updates the same way I receive important updates check box, and then click OK.