Stopping | search
Click here to view Stopping news from 60+ newspapers.
Bookmark or Share- Remove or allow a circular reference in Excel - Microsoft SupportRemove or allow a circular reference in Excel. You've entered a formula, but it’s not working. Instead, you’ve got this message about a “circular reference.”. Millions of people have the same problem and it happens because your formula is trying to calculate itself.
- Block or unblock external content in Office documentsTo help protect your security and privacy, Microsoft Office is configured by default to block external content—such as images, linked media, hyperlinks, and data connections—in workbooks and presentations. Blocking external content helps to prevent Web beacons and other intrusive methods that hackers use to invade your privacy and lure you ...
- Turn automatic completion of cell entries on or offMicrosoft Office Excel completes text entries that you start to type in a column of data — if the first few letters that you type match an existing entry in that column. If you want to stop automatic completion, you can turn this option off. Click File > Options.
- Open a document after a file corruption error - Microsoft SupportOpen a document after a file corruption error. Applies To. Sometimes a file can be damaged in such a way that Word, Excel, or PowerPoint can't open it normally. But all is not lost. The Open and Repair command might be able to recover your file.
- Lock or unlock specific areas of a protected worksheetLock only specific cells and ranges in a protected worksheet. Follow these steps: If the worksheet is protected, do the following: On the Review tab, select Unprotect Sheet (in the Protect group). Select Protect Sheet to change to Unprotect Sheet when a worksheet is protected.
More
