How to change the column width and row height, including how to use the AutoFit feature, in your Excel worksheet.

Changing default formats includes things like changing the font color, style, size, text alignment in a cell, or apply formatting effects. This article shows you how you can apply different formats and also undo …

Format cells by including predefined formatting styles, and things like borders and fill colors.

You can apply conditional formatting to a range of cells (either a selection or a named range), an Excel table, and in Excel for Windows, even a PivotTable report.

The CELL function returns information about the formatting, location, or contents of a cell. For example, if you want to verify that a cell contains a numeric value instead of text before you perform a …

Use the Format Painter in Office to quickly apply the same text formatting and other formatting, such as borders and fills to multiple pieces of text or shapes.

Formatting cells on your worksheet can make the right information easy to see at a glance, but formatting cells that aren't being used (especially entire rows and columns) can cause your …

In that case, you can turn off automatic formatting for one cell or your whole workbook. Move your mouse pointer over the text that was just automatically formatted, and then click the AutoCorrect …

A cell style is a defined set of formatting characteristics, such as fonts and font sizes, number formats, cell borders, and cell shading. To prevent anyone from making changes to specific cells, you can …

Fix data that is cut off in cells by having the text wrap automatically, changing the alignment, decreasing the font size to fit data in a cell, or rotating the text so everything fits inside a cell.