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.

If Excel is not highlighting cells in the formula, enable 'Allow editing directly in cells' and 'Enable fill handle and cell drag-and-drop' in Excel options.

Excel's main function is to interlink cells, through the use of formulas, so that the formula cell changes when data is inputted into linked cells. The best way to store information in ...

Save this for the spreadsheet jocks in your office—we'd bet even the experts don't know all of these formula tips.

Excel allows defined functions to be executed in Worksheets by a user. Instead of a formula based on the color of a cell, it is better to write a function that can detect the color of the cell and ...

This column shows how to use the Data Table option in Excel’s What-If Analysis tool.

Microsoft Excel application designs spreadsheets, tables and documents. Data can be entered in several ways to create formulas and charts formatted in varying sizes, colors and layouts. With the ...

Microsoft Excel updates cell references when you copy an expression. Here are a couple of workarounds for those rare occasions when you don't want to change the cell references.

Learn how to extract specific data from Excel cells using formulas, tools, and techniques to clean and organize messy datasets.

When creating formulas and equations on Microsoft Excel, users have the option of inserting multiple functions and conditions into a formula to attain a desired result. This action is often referred ...

Learn how to easily hide and unhide columns, including the tricky column A, in Excel with this step-by-step guide.