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 ...

Microsoft Excel gives you a boatload of options for changing the format of color charts. You can change the layout of a chart, then customize that layout to the format you prefer. For example, you can ...

I used to think the "Save as type" drop-down menu in Excel was just a list of legacy junk. I was wrong. It's actually a toolkit of superpowers that can shrink massive workbooks, turn macros into ...

It’s not hard to add an alternating band format to a table by applying a table style. It’s quick and easy, but it’s limited. You’ll get a single-row fill color that alternates with a row of white (or ...

Unless you were a math whiz in college, you probably have no great love for Excel. Manipulating Excel formulas can be challenging, but the payoff (like elegantly formatted tables that identify ...

10 ways to format Excel data so that people can actually understand it Your email has been sent Tell the truth, now. When you see a new worksheet arrive in your Inbox, your pulse doesn’t exactly ...

Please note: This item is from our archives and was published in 2016. It is provided for historical reference. The content may be out of date and links may no longer function. You could then take ...