This article applies to Office Home & Business, Office Professional, and individually purchased Office apps. To switch an Office install to or from Microsoft 365, see Switch your Office license.. Change the product key for your version

Import a text file by opening it in Excel. You can open a text file that you created in another program as an Excel workbook by using the Open command. Opening a text file in Excel does not change the format of the file — you can see this in the Excel title bar, where the name of the file retains the text file name extension (for example, .txt or .csv).

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.

Notes: If you don't see an option to Cancel, but instead see a link that says Turn on recurring billing, this means your subscription is already set to expire on the date shown and you won't be automatically charged after this date. There's nothing further to do at this time, and you can continue to use the product until your Microsoft 365 subscription expires.

To zip (compress) files. In the search box on the taskbar, type file explorer, and then select it from the list of results.Right-click the file you want to zip, and then select Send to > Compressed (zipped) folder.. To decompress files. Open File Explorer and find the compressed folder.

We would like to show you a description here but the site won’t allow us.

Note: If you receive a prompt asking whether to allow the app to access your camera (iOS) or to allow the app to take pictures and record video (Android). select Allow so the authenticator app can access your camera to take a picture of the QR code in the next step.If you don't allow the camera, you can still set up the authenticator app as described in Manually add an account to the app.

Find your files in Windows 11 using one of these methods. Search from the taskbar: Type the name of a document (or a keyword from it) into the search box on the taskbar.You'll see results for documents across your PC and OneDrive.

After you set up your security verification methods for your work or school account, you can update the related details. Using the Security info page

How to find and remove duplicates in Excel. Filter for unique values in large or small datasets to clean up your worksheets and workbooks.