Show
Excel can import and export many different file types aside from the standard .xslx format. If your data is shared between other programs, like a database, you may need to save data as a different file type or bring in files of a different file type. Export DataWhen you have data that needs to be transferred to another system, export it from Excel in a format that can be interpreted by other programs, such as a text or CSV file.
Import DataExcel can import data from external data sources including other files, databases, or web pages.
FREE Quick ReferenceClick to Download Free to distribute with our compliments; we hope you will consider our paid training. Avoid unintentionally distributing hidden information, such as the document's author, names that are associated with comments or tracked changes, or hidden cells or worksheets, by removing hidden data. Use the Document Inspector to Remove Hidden DataTo open the Document Inspector, click File > Info > Check for Issues > Inspect Document. The Excel Document Inspection window shown below opens up. After you have completed these steps, save the document, and the spreadsheet will not contain the hidden data that you have removed. Edit Document Properties, Personal Information and Other Document DataTo selectively edit or remove document data, click File > Info > Properties. Click Show All Properties. Delete or edit information. Selectively Remove or Edit CommentsMicrosoft Excel offers the ability to add comments to workbooks. Typically, comments contain the name of the person who created them, and they appear as a small red triangle in the upper-right corner of a cell. To view a comment, click the cell and the comment will pop up. To delete a comment, right-click the cell containing the comment, and then click Delete Comment on the shortcut menu. Selectively Display Hidden Cells, Rows, and ColumnsIn Microsoft Excel, it is possible to hide entire rows and columns of cells within a worksheet. To unhide all of the cells in a worksheet:
Selectively Display Hidden WorksheetsWorkbooks in Microsoft Excel may contain hidden sheets that contain information. To unhide sheets:
Remove Tracked Changes manually or selectively
Learn more about Tracking and Reviewing Changes at microsoft.com. Back to Removing Hidden Data Home When you edit the source file of a linked object on a slide What happens to the linked object?When an object is linked, information can be updated if the source file is modified. Linked data is stored in the source file. The Word file, or destination file, stores only the location of the source file, and it displays a representation of the linked data.
What is a collection of related data points called?A collection of related data is called Database. A database is a data structure that stores organized information.
When you edit an embedded object from within the destination program you use the tools of?The object can be edited in the destination program using the tools of the source program.
What is embedded data in Excel?Embedding generally refers to inserting an object created in an alternative software (Word or PDF, etc. ) in Excel. Embedding is the process of incorporating an object from another software into an Excel worksheet.
|