If you've ever had an Excel formula break because you added a few rows of data, you know how frustrating it can be to go back and manually update every cell reference. The # symbol (also called the ...

Please note: This item is from our archives and was published in 2004. It is provided for historical reference. The content may be out of date and links may no longer function. Q. I have a spreadsheet ...

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

Stop Excel errors by using these 8 key symbols, like ' to keep leading zeros and ~ to search for literal * or ? characters in data.