Both the Currency and Accounting number formats in Excel are used to display monetary values, including the symbol for the chosen currency. However, in this article, I'll explain their subtle ...

How to Format JMP in Excel. When you run a small business, specialized software might not be in your budget. Fortunately, the statistical application JMP includes an add-in that makes it possible ...

How to Auto-Format the Date in MS Excel. When you create Microsoft Excel spreadsheets that contain one or more columns of dates, you can make things a bit easier if you pre-format your cells to ...

Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets.

Learn how to add, configure and use checkboxes in Excel to create interactive task lists and trigger formatting without ...

Susan Harkins shows you how to visually identify holidays using Excel's conditional formatting feature.

Use a custom format in Microsoft Excel to reduce the number of digits in a large number without losing its scale.

Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

While you could tediously copy and paste names and addresses from a text document, with a little know-how in Excel, you can make the process far easier.

If you cannot open an Excel file and see Excel cannot open the file because the file format or extension is not valid error, see this post.