Group or ungroup data in a PivotTable. Grouping data in a PivotTable can help you show a subset of data to analyze. For example, you may want to group an unwieldy list date and time fields in the PivotTable into quarters and months. Windows Mac.

Use the Office offline installer to install Office 2016 or Office 2013 if you don't have an active Internet connection or you're having problems with slow speed or unreliable connections.

Manage suggested recipients in Outlook for iOS and Android. Add, find, edit, or delete a contact in Outlook. As you type inside the To, Cc, or Bcc boxes, Outlook suggests recipients. The Auto-Complete List can be turned off.

If you are trying to set up an Exchange account in Outlook, ask the organization that gave you the email address for the name of your Exchange server. It's standard for them to provide you with this information so you can add your email address to a computer or phone.

Use a contact group (formerly called a “distribution list”) to send an email to multiple people—a project team, a committee, or even just a group of friends—without having to add each name each time you want to send them an email message. A contact group is stored in your contacts folder.

Right-click on a file to access the new context menu. For more info, see Finding items in the File Explorer context menu. Find and open File Explorer in Windows 10 and Windows 11, and customize Quick access by pinning and removing files and folders.

選取群組的 或 時按住 shift，然後移至 [數據 > 大綱] > [取消群組 ]> [取消群組]。 重要: 如果在詳細數據隱藏時將大綱取消群組，詳細數據列可能會保持隱藏。

The Microsoft .NET Framework 4.8 is a highly compatible, in-place update to the Microsoft .NET Framework 4, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1 and 4.7.2. The offline package can be used in situations in which the web installer cannot be used because of lack of Internet connectivity.

The first step to use S/MIME is to obtain a certificate from your IT administrator or helpdesk. Your certificate might be stored on a smart card, or might be a file that you store on your computer. Follow the instructions provided by your organization to use your certificate. Install the S/MIME control.

Splits text strings by using column and row delimiters. The TEXTSPLIT function works the same as the Text-to-Columns wizard, but in formula form. It allows you to split across columns or down by rows. It is the inverse of the TEXTJOIN function .