Each cell in an Excel spreadsheet has a unique address, called a cell reference. This reference combines the letter that represents the cell's column with the number that represents its row. Cells in ...

Microsoft Excel relies on two fundamental reference types when addressing other cells. Absolute references -- which are denoted with a "$" -- lock a reference, so it will not change when copying the ...

These charts accompany our story Excel 2010 cheat sheet. Click through to that story for detailed information on getting up and running with Excel 2010. If you’ve upgraded to Excel 2010 directly from ...

Structured references in Excel often get a bad reputation for being overly complex, but this perception usually stems from misunderstanding their purpose and functionality. Unlike traditional cell ...

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

If you’re a full-time spreadsheet jockey, or just a casual number-cruncher, you’ve come to know and either love or hate Excel’s interface. Well, your world just changed. Throw away almost everything ...

Excel’s chart features can turn your spreadsheet data into compelling visual communications—if you know what to do. This guide will walk you through the basics of setting up trends, percentages, ...