Here is a tutorial to lock or hide only the formula cells in an Excel workbook. You can also lock formulas in all worksheets in a workbook.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

Is there a way to hide the numbers in certain Excel cells without a lot of formatting fuss or the use of passwords? I need to be able to print versions of a spreadsheet without showing certain data.

In Excel, the formula bar is the toolbar at the top of the spreadsheet that lets you enter or view the information in a cell.

Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.

Select a cell range and a function, and your result appears with no muss or fuss. Here are a few examples: =MAX (B4:B13) returns the highest value in the list.

Boolean logical operators in Excel formulas make searching easier, and you can apply the same methods in Internet or database searches.