Learn about the latest feature updates and bug fixes for the OneDrive sync app across all devices.

The SORT function will return an array, which will spill if it's the final result of a formula. This means that Excel will dynamically create the appropriate sized array range when you press ENTER.If your supporting data is in an Excel Table, then the array will automatically resize as you add or remove data from your array range if you're using Structured References.

You can change your name on the Account Settings screen. To change the name that displays when you send email, update the Your name field. Unless you specifically need to change any of the other fields, you can leave the default values in place.

Enable this setting to give participants more discretion over how they want to be presented in a meeting. Allow attendance report. Attendance reports contain meeting attendance details, including how long attendees stayed, and how long your meeting lasted, and more.. Turn on the Allow attendance reporttoggle to generate, view, and download attendance reports.

Note: If you have previous activity history stored in the cloud before Windows 11 23H2 and 22H2, January 23, 2024-KB5034204 update, you can use the Clear activity history button to delete previously stored data in the cloud. Otherwise, your activity history will be automatically deleted within 30 days from when your data was last synced to the cloud

Note: If you don’t see the Change link, it may be because some information, such as your name, photo, or title, is collected from systems that your IT or human resources department control.If you want to update those details, contact your administrator. If you need help finding your administrator, see How do I find out who my admin is?

Here’s how to do it: Select the range of data you want to rearrange, including any row or column labels, and press Ctrl+C.

Excel gives you the ability to protect your work, whether it’s to prevent someone from opening a workbook without a password, granting Read-Only access to a workbook, or even just protecting a worksheet so you don’t inadvertently delete any formulas.

Note: Microsoft is updating the way we ask for permission to use your voice data to improve Microsoft products that use our speech recognition technology.This may impact the data you see on your privacy dashboard. To learn more about these changes, see How does Microsoft protect my privacy while improving its speech recognition technology?

There are times when you don't want messages from a specific person or domain to end up in your Junk Email folder. Messages from addresses or domains on the safe senders list won't get moved to your Junk Email folder.