The first step in making a spreadsheet readable is to tidy up the cell formatting. By smartly using cell borders, shading, ...

How to Format Debits and Credits in Excel. When you use Microsoft Excel to analyze your company's data, you want to spot trends, successes and problems at a glance. Before you dive into an in ...

If you want to rotate text in Excel spreadsheet, follow this tutorial. Use Orientation feature in Excel to rotate text manually in a cell.

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.

Microsoft Excel 2007's conditional formatting feature allows you to format cells based on certain criteria. As an example, you might want the row color to change based upon a credit or debit on a ...

When you think VBA code is your only hope, try combing built-it conditional formatting tools. You might just find an easier solution than writing code.

If the Merge and Center button is missing, greyed out or in Excel, then this post offers a workaround that will help you move forward.