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 Data

To open the Document Inspector, click File > Info > Check for Issues > Inspect Document. The Excel Document Inspection window shown below opens up.

Excel Document inspector window.


Click Inspect to identify hidden content, and then click Remove All to remove the item of your choice.

Review the document inspection results.

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 Data

To selectively edit or remove document data, click File > Info > Properties. Delete or edit information.

> File > Info and edit properties (RHS.)

Selectively Remove or Edit Comments

Microsoft 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 Columns

In 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 Worksheets

Workbooks in Microsoft Excel may contain hidden sheets that contain information.

To unhide sheets:

Remove Tracked Changes manually or selectively


Microsoft Excel includes a Track Changes feature that allows you to track changes made to a shared workbook by a user. To remove tracked changes from a workbook, follow these steps:

Learn more about Tracking and Reviewing Changes at microsoft.com.

Back to Removing Hidden Data Home


TRAINING & DOCUMENTATION

CheckMarq Student Info System

D2L E-Learning

E-Marq Mail & Calendar

Microsoft Office

Network Access & Wireless

Passwords & PINs

Safe Computing & Anti-virus

SharePoint Collaboration

Training Opportunities

Unified Communications

More Documentation...

 

MORE ABOUT OUR SERVICES

Campus Downloads

Computer Labs & Smart Classrooms

Getting Hardware & Software

Help with Computers & Printers

Phones & Telecommunication

Printing at Marquette

 

Are you new to Marquette?

 




SITE MENU