Compare two versions of a workbook by using Spreadsheet Compare
Differences are highlighted with a cell fill color or text font color, depending on the type of difference. For example, cells with "entered values" (non-formula cells) are formatted with a green fill color in the side-by-side grid, and with a green font in the pane results list.
Applies To: Spreadsheet Compare 2013, Spreadsheet Compare 2016, Spreadsheet Compare 2019, Spreadsheet Compare 2021
Update to enable TLS 1.1 and TLS 1.2 as default secure protocols in ...
Note In addition to the DefaultSecureProtocols registry subkey, the Easy fix also adds the SecureProtocols at the following location to help enable TLS 1.1 and 1.2 for Internet Explorer.. The SecureProtocols registry entry that has value 0xA80 for enabling TLS 1.1 and 1.2 will be added in the following paths: HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings
Troubleshooting the Phone Link - Microsoft Support
Check for updates in the Phone Link by opening Settings > About > Check for updates.Install any pending updates to make sure your content stays up-to-date. You may also need to check for updates in the Link to Windows app on your Android device.
Turn on OneDrive Backup - Microsoft Support
Try it! You can back up your important folders on your PC & Mac (your Desktop, Documents, and Pictures folders) with OneDrive, so they're protected and available on other devices.
Applies To: OneDrive for Business, OneDrive (work or school), OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
Boot Surface from a USB device - Microsoft Support
For all Surface models Before you start, make sure you don’t have any other USB devices connected to your Surface, including USB mouse devices, keyboards, or other storage drives.
Apply shading to alternate rows or columns in a worksheet
Another way to quickly add shading or banding to alternate rows is by applying a predefined Excel table style. This is useful when you want to format a specific range of cells, and you want the additional benefits that you get with a table, such the ability to quickly display total rows or header rows in which filter drop-down lists automatically appear.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2024, Excel 2021, Excel 2019, Excel 2016, Excel 2013
Keyboard shortcuts in Microsoft Edge - Microsoft Support
Command + G. Jump to the next result for find on page. Command + Shift + G. Jump to the previous result for find on page. Command + Shift + H . Open your home page in the current tab. Command + Option + J. Open the JavaScript Console. Command + L. Select the URL in the address bar to edit. Command + Option + L. Open Downloads Ctrl + M. Toggle ...
DATEDIF function - Microsoft Support
Argument. Description. start_date . Required. A date that represents the first, or starting date of a given period. Dates may be entered as text strings within quotation marks (for example, "2001/1/30"), as serial numbers (for example, 36921, which represents January 30, 2001, if you're using the 1900 date system), or as the results of other formulas or functions (for example, DATEVALUE("2001 ...
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 2016, Windows SharePoint Services 3.0
View display settings in Windows - Microsoft Support
To change your screen resolution, use the drop-down menu next to Display resolution.. Note: You should use the Recommended resolution. If you change the resolution, content might appear blurry or pixelated.
COUNTIFS function - Microsoft Support
This video is part of a training course called Advanced IF functions.. Syntax. COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…) The COUNTIFS function syntax has the following arguments:
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 2016, Excel Web App