You may want to create mandatory fields in your Excel spreadsheet -- fields that must be filled in before you can save the document. When a field is made mandatory, there is no risk of leaving out ...

One of the most underused lookup and reference functions in Microsoft Excel is the DROP function. This powerful yet simple ...

Restoring the drag-and-drop menu in your Excel Pivot Table is typically a quick fix. By using either right-click options or ribbon commands, you can easily access the field list again. If all else ...

The TOCOL and TOROW functions are just two ways to rearrange data in Microsoft Excel. For example, you can flip the rows and columns using the TRANSPOSE function, transform large datasets using ...

Q. I am trying to create a formula in our accounting system, but I keep getting errors. What can I do to get the formula to work? A. All Excel users know how powerful formulas are, but sometimes it ...