Import or export text (.txt or .csv) files - Microsoft Support
网页There are two ways to import data from a text file with Excel: you can open it in Excel, or you can import it as an external data range. To export data from Excel to a text file, use the Save As command and change the file type from the drop-down menu. There are two commonly used text file formats:
File formats that are supported in Excel - Microsoft Support
网页Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016. You can save an Excel file in another file format by clicking the File > Save As. The file formats that are available in the Save As dialog box vary, depending on what type of sheet is active (a worksheet, chart sheet, or other type of sheet).
Repair a corrupted workbook - Microsoft Support
网页Click File > Open. Click the location and folder that contains the corrupted workbook. In the Open dialog box, select the corrupted workbook. Click the arrow next to the Open button, and then click Open and Repair. To recover as much of …
Open files from the File menu - Microsoft Support
网页Search for your file. If you have a document on your computer, but you're not sure exactly what folder it's saved in, you can find it as long as you know at least part of the name or a bit of text that is in the document. Click the Browse …
Open XML Formats and file name extensions - Microsoft Support
网页What are the XML file name extensions? Can different versions of Office share the same files? What are the benefits of Open XML Formats? The Open XML Formats include many benefits — not only for developers and the solutions that they build, but also for individual people and organizations of all sizes:
TEXT function - Microsoft Support
网页Technical Details. Overview. In its simplest form, the TEXT function says: =TEXT (Value you want to format, "Format code you want to apply") Here are some popular examples, which you can copy directly into Excel to experiment with on your own. Notice the format codes within quotation marks.
Reduce the file size of a picture in Microsoft Office
网页With your file open in your Microsoft Office application, select the picture or pictures that you want to compress. Under Picture Tools, on the Format tab, in the Adjust group, select Compress Pictures. If you do not see the Picture Tools - Format tab, make sure that you selected a picture.
Trusted documents - Microsoft Support
网页2022年1月24日 · Click the File tab. Click Options. Select Trust Center, and then Trust Center Settings. Click Trusted Documents. Clear the Allow documents on a network to be trusted check box. View or modify Trusted Documents settings in the Trust Center. You can view or change Trusted Documents settings in the Trust Center.
Excel specifications and limits - Microsoft Support
网页In Excel 2010, the maximum worksheet size is 1,048,576 rows by 16,384 columns. In this article, find all workbook, worksheet, and feature specifications and limits.
Get notified when members of your team update your shared file
网页2019年4月4日 · In App - You can receive notifications right within Word, PowerPoint, or Excel, when people you've shared your file with make changes, edits, comments, etc. Notification Center - When your collaborators start to edit your file, you can receive a notification in the Windows 10 Action Center or in the notification center of your mobile …
Reduce the file size of your Excel spreadsheets - Microsoft Support
网页Removing unused data will reduce your file size. Save pictures at lower resolutions. Go to File > Options > Advanced. Under Image Size and Quality, do the following: Select Discard editing data. This option removes stored data that's used to restore the image to its original state after it's been edited.