Microsoft Office Excel contains many features to customize the final appearance of the workbooks you create. For a closer look at its settings, it is best to consult the specialized literature on working in Office.
Necessary
MS Excel program
Instructions
Step 1
Select the cell, the formula of which you want to hide, by pressing the left mouse button. If you need to select everything at once, use the keyboard shortcut Ctrl + A. If you need to select several adjacent cells, press and hold the left mouse button while highlighting the required ones. To select cells that are not adjacent, use the simultaneous pressing of the Ctrl key on the keyboard and the left mouse button.
Step 2
Go to the cell formatting menu, select the "Cells" item. Open the protection settings and uncheck the box next to Protected cell. Check the box next to "Hide formulas" and then apply this action. Open the Tools menu. Go to the table protection settings, select the "Protect sheet" item.
Step 3
If you need to hide the formulas of each sheet of an Excel workbook, perform this action sequentially on each page, if your version supports applying settings to the entire workbook, follow this action and check if the formulas are not available for all parts. This function is often used when creating educational material, when writing manuals, when performing various computational work, and so on.
Step 4
Please note that the sequence of steps may vary depending on which version of Microsoft Office Excel you have installed. If you are not well versed in this program or it is rather difficult for you to master its new version, use the special reference literature on this topic.
Step 5
Also visit thematic formulas more often and read additional material on the Internet. Look for special courses to improve your Microsoft Office skills, which are certainly available in your city.
