## You are here

Home › formulas# formulas

## Protecting Data in MS Excel

Many times it is necessary to protect worksheet information that is used and shared with others. Private information should be protected from unauthorized access. An expense report worksheet with complex formulas should be protected so that someone ... cannot unintentionally destroy the design of the report. Excel proves several ways to control and restrict the use of workbooks, worksheets and the data they contain. Protection can be established in a variety of ways depending on the extent of control that is needed. Below you will bee the levels of protection that are available to you: File Saves ... (view more)

## Embed Excel Worksheets in a Table: MS Word

Rather than just pasting raw numbers into a table, you can embed a worksheet into a document. Embedding retains the formulas that ride behind your numbers and all the functionality of Excel. You can create an Excel worksheet from scratch, or, if the ... worksheet already exists, you can insert it using the Paste Special command. Although an embedded worksheet behaves as a picture in the document, when you double-click to modify it, Excel opens within MS Word, allowing you to use Excel's formulas to calculate results. One drawback to embedding an Excel worksheet is that it increases the file size ... (view more)

## Enter Formulas in a Cell: MS Excel

You can type formulas in a cell to do all sorts of calculations. Formulas always begin with an equal sign (=). Then, to calculate the result, they combine numbers, cell references, and these arithmetic operators: + to add - to subtract * to multiply ... / to divide % to take a percent ^ to raise to a power (or exponent) ( ) to change the order of calculation Excel calculates formulas from left to right, following a set order of operations. Enclosing part of a formula in parentheses changes the order in which the items are calculated. Look at this example: =(48 12)*2/9 +1 This formula equals 9 ...<a href="/news/1334/enter-formulas-cell-ms-excel" class="more-link">view more

## Most popular articles

- Which Processor is Better: Intel or AMD? - Explained
- How to Prevent Ransomware in 2018 - 10 Steps
- 5 Best Anti Ransomware Software Free
- How to Fix: Computer / Network Infected with Ransomware (10 Steps)
- How to Fix: Your Computer is Infected, Call This Number (Scam)
- Scammed by Informatico Experts? Here's What to Do
- Scammed by Live PC Expert? Here's What to Do
- How to Fix: Windows Update Won't Update
- Explained: Do I need a VPN? Are VPNs Safe for Online Banking?
- Explained: VPN vs Proxy; What's the Difference?
- Explained: Difference Between VPN Server and VPN (Service)
- Forgot Password? How to: Reset Any Password: Windows Vista, 7, 8, 10
- How to: Use a Firewall to Block Full Screen Ads on Android
- Explained: Absolute Best way to Limit Data on Android
- Explained: Difference Between Dark Web, Deep Net, Darknet and More
- Explained: If I Reset Windows 10 will it Remove Malware?

**Do you need Tech Support?**

I can help! Send me a message on the bottom left of the screen (using the Zopim Chat button), or click my picture to read more about how I can fix your computer over the Internet. Optionally you can read all about my credentials, here.