Editor’s note: These charts accompany our story Excel 2007 Cheat Sheet. Click through to that story for detailed information on getting up and running with Excel 2007. Wondering where your favorite ...

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

Freeze Panes in Excel solves this problem completely. It locks specific rows and columns in place so they remain visible no matter where you scroll. To set it up, go to the View t ...

Q. How do the TRIMRANGE function and trim references in Excel work? A. Excel’s TRIMRANGE function and trim references help users quickly tidy up datasets. This makes for a cleaner, easier-to-follow, ...

10 ways to reference Excel workbooks and sheets using VBA Your email has been sent Excel offers myriad options for referring to workbooks and sheets in your VBA code. See which methods make sense in ...

It's often useful to put a header or footer on the top or bottom of Excel spreadsheets. The header or footer might contain information about who prepared the spreadsheet, a disclaimer about the ...

Some Excel users have reported experiencing the Data source reference is not valid error while creating a pivot table in Excel. We will learn why this error occurs ...

To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting. Data bars are a kind of conditional formatting, with the bar length based on the value of the ...