Use AutoSum to sum numbers - Microsoft Support
If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, select AutoSum on the Home tab, press Enter, and you’re done. When you select AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers. Here’s an example.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Make older apps or programs compatible with Windows
Change the application's high-DPI scaling mode. In the High DPI scaling override area, select Override high DPI scaling behavior, and then try one of the following options:. Application – Disable all Windows scaling settings and only use the app developer's setting. This option was called Disable display scaling on high DPI settings in previous versions of Windows.
Change the size of your slides - Microsoft Support
Widescreen won’t fit on an 8.5" x 11" sheet of paper without you having to scale it down. Select OK to accept the dimensions and close the Slide Size dialog box. Choose custom dimensions (in inches, centimeters, or pixels) On the Design tab of the Ribbon, locate Slide Size in the Customize group, near the far right end of the toolbar.
Applies To: PowerPoint for Microsoft 365, PowerPoint for Microsoft 365 for Mac, PowerPoint for the web, PowerPoint 2024, PowerPoint 2024 for Mac, PowerPoint 2021, PowerPoint 2021 for Mac, PowerPoint 2019, PowerPoint 2019 for Mac, PowerPoint 2016
I forgot the account I use with Microsoft 365 - Microsoft Support
Microsoft 365 for business. If your Microsoft 365 product is one of the following, you have a Microsoft 365 for business product. These products are usually associated with a work or school account, and your Microsoft 365 license (if your subscription has one) came from the organization where you work or go to school.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Publisher for Microsoft 365, Visio Plan 2, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, OneNote for Microsoft 365 for Mac, Excel 2024, Word 2024, Outlook 2024, Access 2024, OneNote 2024, Project Professional 2024, Project Standard 2024, Visio Standard 2024, Office 2024, Excel 2024 for Mac, Word 2024 for Mac, Outlook 2024 for Mac, OneNote 2024 for Mac, Office 2024 for Mac, Excel 2021, Word 2021, Outlook 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Excel 2021 for Mac, Word 2021 for Mac, Outlook 2021 for Mac, OneNote 2021 for Mac, Office 2021 for Mac, Excel 2019, Word 2019, Outlook 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, Excel 2019 for Mac, Word 2019 for Mac, Outlook 2019 for Mac, OneNote 2019 for Mac, Office 2019 for Mac, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016, Office 2016, OneNote for Mac, SharePoint in Microsoft 365, 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, Microsoft 365 for Mac, Office 365 Activation, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin, Project for Office 365
Move or copy files in SharePoint - Microsoft Support
In the Choose a destination pane, select the new location in the document library where you want the files to go, and select Move here.. In the Choose destination pane, to add a new folder to the document library, you can also click New folder and move the item to the new folder.In the text box, enter the name of the new folder, select the checkmark, and then select Move here.
Applies To: SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, SharePoint in Microsoft 365, Office for business, Office 365 Small Business, Microsoft 365 admin, SharePoint in Microsoft 365 Small Business
Create and add an email signature in Outlook.com or Outlook on the web
If you've created a signature but didn't choose to automatically add it to all outgoing messages, you can add it later when you write an email message. Go to your mailbox and choose New email . Type your message, and then choose > Insert signature at the bottom of the compose pane.
Applies To: Outlook on the web, Outlook.com, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019
Show, hide, or pin a team or channel in Microsoft Teams
If you know you're a member of a team but don't see it, scroll to the bottom of your teams list and select See all teams. Show a channel. Tap Teams, and go to the bottom of the team list. Tap All teams, then tap on the team the channel is in and tap the circle next to the channel you want to show.
Applies To: Microsoft Teams
View previous versions of Office files - Microsoft Support
This is incredibly important if a mistake was made, you have issues with malware or a virus, or you just prefer a previous version. This is also important when you're collaborating with others and someone makes changes you didn't want in a file. The experience for Version History is similar across your apps.
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, Excel 2024, PowerPoint 2024, Excel 2024 for Mac, Word 2024 for Mac, PowerPoint 2024 for Mac, 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
Sync SharePoint files and folders - Microsoft Support
These files are only available when you're connected to the Internet, but don't take up space on your computer. When you open an online-only file, it downloads to your device and becomes locally available. You can open a locally available file at any time even without Internet access. To make a file always available, even when you're offline:
Applies To: SharePoint in Microsoft 365
Use breakout rooms in Microsoft Teams meetings
Leave a breakout room. To leave a breakout room and return to the main meeting, select Return in the meeting controls.. Interact with breakout room participants. As meeting organizer, you can send announcements to all the breakout rooms and contribute to any of the room chats.
Applies To: Microsoft Teams, Microsoft Teams for Education