Round a number to the decimal places I want - Microsoft Support
To. In the Formula Builder, search for, and then double-click. Under Arguments. Round a number up. ROUNDUP. In number, type the number you are rounding up.In num_digits, type 0 to round the number up to the nearest whole number.. Round a number down. ROUNDDOWN. In number, type the number you are rounding down.In num_digits, type 0 to round the number up to the nearest whole number.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel Mobile
Undo, redo, or repeat an action - Microsoft Support
Undo an action. Press + Z, or select Undo in the upper-left corner of the ribbon, until you've fixed the issue.. You can't undo some actions, such as selecting 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, select 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
Filter websites and searches using Microsoft Family Safety
Establishing internet boundaries is an important way to protect yourself and your family from inappropriate web content. Microsoft Family Safety web and search filters work across any Windows, Xbox and mobile device that has the Microsoft Edge browser and Family Safety apps installed.
Applies To: Microsoft Family Safety
Upgrade to Windows 10: FAQ - Microsoft Support
An upgrade moves your PC from a previous version of Windows—such as Windows 7 or Windows 8.1—to Windows 10. An upgrade can take place on your existing device, though Microsoft recommends using Windows 10 on a new PC to take advantage of the latest features and security improvements.
Guidelines and examples of array formulas - Microsoft Support
An array formula (one that spans multiple cells) can do calculations on rows and columns of cells where you might otherwise need to use several formulas. For example, you can count the number of characters that are contained in a range of cells, sum only numbers that meet certain conditions (such as the lowest values in a range or numbers that fall between an upper and lower boundary), and sum ...
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel for iPad, Excel for iPhone
Use conditional formatting to highlight information in Excel
Notes: The formatting options that appear in the Formatting tab depend on the data you have selected. If your selection contains only text, then the available options are Text, Duplicate, Unique, Equal To, and Clear.When the selection contains only numbers, or both text and numbers, then the options are Data Bars, Colors, Icon Sets, Greater, Top 10%, and Clear.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Make text and apps bigger - Microsoft Support
Make text bigger on your screen. If the text size feels too small when navigating through Windows, you can make the text bigger. This affects, for example, title bars, menus, and icon texts.
Hide or Unhide worksheets - Microsoft Support
To select. Do this. A single sheet. Click the sheet tab. If you don't see the tab that you want, click the scrolling buttons to the left of the sheet tabs to display the tab, and then click the tab.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Use add-ins in Outlook - Microsoft Support
Notes: Starting in Outlook for Windows Version 2303 (Build 16215.10000), the All Apps button replaces the Get Add-ins buttonon the ribbon to view installed add-ins and access the Office Store.If you’re using an earlier version of Outlook, you'll see the Get Add-ins button instead.. If you don't see All Apps on the ribbon, your administrator may have turned off add-ins for your organization.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook on the web, New Outlook for Windows, Outlook Web App
Create an organization chart in Office by using SmartArt
Create an organization chart using SmartArt graphics. Although you cannot automatically connect two top-level boxes with a line in the organization chart layouts, such as Organization Chart, you can imitate this look by adding a box to the top level to your SmartArt graphic and then drawing a line to connect the boxes.(On the Insert tab, in the Illustrations group, select Shape, select a line ...
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016