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 ...
Hosted on MSN
Excel's # symbol looks like a typo — it's actually one of the most useful things in the app
You can use Excel for years without ever noticing the # symbol, let alone understanding what it does. That changes when you inherit a workbook, spot a formula with a cell reference ending in #, and ...
One of the best features in Excel is the ability to plug in a formula and then easily drag it into new cells and have it automatically shift to the corresponding cell values. But sometimes this can ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results