Structured references use table columns instead of cell coordinates, making formulas easier to read, update, and trust.

Please note: This item is from our archives and was published in 2021. It is provided for historical reference. The content may be out of date and links may no longer function. Consider the following ...

What’s the difference between a table and a range of columns and rows on an Excel spreadsheet? How do I create and populate tables? And, once a table is created, how do we custom filter, format, and ...

If you want to apply color in alternate rows and columns in an Excel spreadsheet, here is what you need to do. It is possible to display the desired color in every other row or column using ...

The accounting format in Microsoft Excel 2010 is very similar to the currency format---both display the currency symbol next to every number. But the accounting format has a few differences that make ...

When you add or subtract currency-formatted numbers, Excel 2013 automatically adopts the currency format for the results. Adding and subtracting figures follows similar procedures, but you must be ...