The cells in a Microsoft Excel spreadsheet can hold various types of numerical data, including fractions and percentages. If some or all of your cells contain fractions, Excel enables you to convert ...

Number formats in Microsoft Excel define how data is displayed in your spreadsheet without changing the underlying values. As well as using number formats to present data as dates, times, percentages, ...

The accounting format in Microsoft Excel 2010 is very similar to the currency format---both display the currency symbol next to every number. But the accounting format has a few differences that make ...

Microsoft Excel’s conditional formatting is a wonderful “automatic” feature that allows you to formats cells based on the value of those cells or the value of the formulas in those cells. For example, ...

Susan Harkins shows you how to format and unlock input cells in Excel at the same time by assigning a modified style. It’s common to highlight input cells so users know which values to change, and ...

We all know that, when you right click on a cell in an Excel worksheet, it is possible to change the format of the cell, from its numeric type, alignment, and text property to its surround and ...

Structured references use table columns instead of cell coordinates, making formulas easier to read, update, and trust.