Please note: This item is from our archives and was published in 2000. It is provided for historical reference. The content may be out of date and links may no longer function. The July Technology Q&A ...

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

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

Have you ever tried to drag the header columns in an Excel spreadsheet to make them fit the text? I have and just when I think I’ve got it right, a quick glimpse down the line of columns usually ...

The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of all data in a PivotTable. In fact, the only thing you need to type is the ...

Hide everything but the working area in an Excel worksheet Your email has been sent If you’ve ever opened a Microsoft Excel workbook to find no columns, rows and/or scrollbars, this is probably why: ...

Microsoft has been adding new features to Excel lately, and the latest one could change the way people work with formulas.