The formatting combination includes all the formatting options available in Excel, such as font size and style, adding borders and colors to cells or text, etc.

Pro Tip: To open formatting options, just select the cell (s) you want to format and press Ctrl-1 (Mac: Command-1). This actually works for anything in Excel: charts elements, images, etc.

To clear formatting from the selected cells in your workbook in Microsoft Excel, you can use Clear Formats, Keyboard shortcuts, Format Painter tool, etc.

Here are five of my favorite Excel formatting tricks. Double-click to fit columns and rows When you enter or paste text and numbers into Excel, the cells don't expand to fit their contents.

Use Excel's conditional formatting feature to look at a specific cell in the row, determine if it's negative or positive and format the row based on the results.

Format Conversions Excel offers different spreadsheet, basic text and Web page file formats to save your work. Often, saving a spreadsheet in a different format can lead to missing data.

Your worksheets will be more polished and easy to read if you learn a few sophisticated formatting techniques. Most Excel users know how to apply basic numeric and text formats. But users who push ...

Excel's conditional formatting lets you customize how your data displays, from changing colors and shading to adding icons and more. Here's how it works.