Brand Control logo

Make it easy for users to stick to your brand — not to ignore it. 

Content Enablement Logo

Make it easy for users to find the right content instantly.

Content Creation logo

The solution for maximum efficiency in presentation creation.

Document Automation logo

The document editing and assembly process is streamlined.

People

Learn more about our clients and their success stories

Gears

Integrate empower® with your existing applications.

Blog

Get practical office tips, inspirational stories, and exclusive market assessments of the MS Office world

E-Books

Find MS Office related guides, e-books, whitepapers, videos, infografics and more 

Asset_Library

Everything you need to know about the MS Office world. Clearly summarized.

Office_Study

The Ultimate Global Office Suite Study - conducted by Nielsen

Office_Study

The Ultimate Office Suite Study for USA - conducted by Nielsen

Powerpoint_Study

Download our global PowerPoint Study conducted by Nielsen

Support

Our support is always there for you. You can also reach out to our Help Center. 

Best_Practice_Series

Our empower® Best Practice Series shows empower use cases in short 15min videos

Company

Learn about our values and why we get out of bed every morning

Microsoft_Partnership

Find out more about our very unique relationship with Microsoft

Press

An overview of the press releases about empower

Contact

Contact us at any time if you have any questions or feedback

Security

Your data is private and secure with empower®

Career

Find out now about the most important reasons for a career with us! Apply now!

Protect targeted formulas in your Excel spreadsheet

Theresa Spiller
February 1, 2022

In addition to the familiar option of protecting a spreadsheet or an entire workbook, Excel also offers the option of only locking cells for editing containing certain formulas. This ensures that formulas are protected while still allowing normal working in the rest of the spreadsheet. Want to know how this works? Then keep reading. 

Protecting Excel formulas is easier than you think

You have created a spreadsheet, maybe from web imported data, with overviews in the form of tables in which cell contents are generated via complex formulas and now want to make this available to team members for further processing. However, it is important to you that you can work in the spreadsheet without changing your formulas.


  1. Select the entire worksheet (Ctrl + A) and then right-click to open the "Format Cells" window.

    protect excel formulas format cells
  2. Select the "Protection" tab and uncheck the "Locked" box.

    protect excel formulas protection tab uncheck locked
  3. Now activate all cells of the spreadsheet that contain formulas by selecting the "Go to" dialog box via "Ctrl + G" and clicking on "Contents" there.

    protect excel formulas open go to window

    Get your free Excel cheat sheet with 16 tricks and shortcuts now!

  4. Another window will open. You activate the item "Formulas" and select all cells containing formulas you want to lock and protect.

    protect excel activate formulas in go to window
  5. Now open the "Format Cells" dialog box again and select the Protection tab. Check the "Locked" box again, which you unchecked before. Because you have only selected the cells that contain formulas, this format will only be applied to these cells and all other cells will be left out.

  6. In the last step, you now lock the worksheet via the "Review" "Protect Sheet" tab.
    protect excel formulas review tab protect sheetprotect excel formulas protect sheet lock cells

A dialog box opens again. Keep the checkmarks that have been preset here. Now only cells that contain formulas are locked instead of the whole spreadsheet.

Do you spend a lot of time working with Excel and waste a lot of time formatting charts? Then read more about our Content Creation solution! Our practical Office add-ins will help you create documents and charts faster and you will not have to lift a finger to adjust them to your corporate design. Our solution will take the annoying and time-consuming formatting works out of your hands, not only in Excel but also in Word, PowerPoint and even Outlook!

Interested? Contact us for further information. Our experts will be happy to answer any questions you may have!

Document Automation Whitepaper

You May Also Like

These Stories on Office

Subscribe by Email