Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on certain arguments you input. However, combining—or nesting—functions ...

The Microsoft Excel Status Bar is now more advanced than before with the new ability to copy and paste values.

Thats strange, because when I filter then copy rows in Excel 2007, it only copies the selected rows, not the hidden values.<BR><BR>This is Office 2007 SP1, BTW.