SUMIF function | Microsoft Support
How to use the SUMIF function in Excel to add the values in a range that meet criteria that you specify.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016
Copy and paste using the Office Clipboard | Microsoft Support
Copy and paste multiple items using the Office Clipboard Open the file that you want to copy items from. Select the first item that you want to copy, and press CTRL+C. Continue copying items from the same or other files until you have collected all of the items that you want. The Office Clipboard can hold up to 24 items.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Publisher for Microsoft 365, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, Outlook for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Excel 2024, Outlook 2024, PowerPoint 2024, Access 2024, Excel 2024 for Mac, Word 2024 for Mac, Outlook 2024 for Mac, PowerPoint 2024 for Mac, Excel 2021, Word 2021, PowerPoint 2021, Access 2021, Publisher 2021, Excel 2021 for Mac, Word 2021 for Mac, Outlook 2021 for Mac, PowerPoint 2021 for Mac
Where is Save As? | Microsoft Support
The Save As feature in Word, Excel, and PowerPoint has been replaced by Save a Copy. To save a copy of a file, do the following: Tap File > Save a Copy. Choose where you want to save the file. Enter a file name and then tap Save a Copy.
Applies To: Excel for iPad, Word for iPad, PowerPoint for iPad, Excel for iPhone, Word for iPhone, PowerPoint for iPhone
Find and transfer Outlook data files from one computer to another ...
You can move this file to a new computer and retain your information. Moving a .pst file from one computer to another doesn't transfer your email account settings. If you need to set up Outlook on a new computer, copy your .pst file from the old computer, then set up your email account on your new computer.
Applies To: Outlook for Microsoft 365, Outlook 2024, Outlook 2021
Open a second workbook in another copy of Excel
When you open multiple Excel workbooks, each workbook opens in a separate window but in the same copy or instance of Excel. There may be times when you want to open a workbook in a new instance of Excel.
Applies To: Excel for Microsoft 365, Excel 2024, Excel 2021
Create a document in Word | Microsoft Support
With Word you can: Create a document from scratch or from a template . Add text, images, art, and videos. Research a topic and find credible sources. Access your documents from a computer, tablet, or phone via OneDrive. Share your documents and collaborate with others. Track and review changes.
Applies To: Word for Microsoft 365, Word 2024, Word 2021
Microsoft Store doesn't open | Microsoft Support
How to open Microsoft Store on Windows To open the Microsoft Store on Windows, click the button below.
Save a copy before editing to prevent changing the original file
Save a Copy lets you download a copy of a file so you can work in it in the cloud without making changes over the original.
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
Using the clipboard | Microsoft Support
Learn how to use and troubleshoot the clipboard in Windows to paste multiple items, pin items, and sync your clipboard to the cloud.
Clear the Clipboard | Microsoft Support
To delete all clips or an individual clip, first open the Clipboard task pane. On the Home tab, in the Clipboard group, select the Clipboard dialog box launcher. The Clipboard task pane appears on the left side of your spreadsheet and shows all clips in the Clipboard. To clear the entire Clipboard, select the Clear All button.
Applies To: Excel for Microsoft 365, Excel 2024, Excel 2021, Excel 2019, Excel 2016