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

These four overlooked Excel features completely changed how I design spreadsheets.

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

The Office Scripts action recorder can generate code snippets for Excel changes, but some actions still require manual ...

Although Google Sheets and Excel Online are two of the best free online spreadsheet editing apps, you may not like certain features of them. For example, the date format. In case you do not want to ...

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. Q. I can’t figure out ...