How to use And and Or operators with Excel’s Advanced Filter Your email has been sent Editor’s Note: This article was originally published in July 2010 and the video tutorial for this article ...

If the object was created in Microsoft Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C. The Creator property is designed to be used in Microsoft ...

Filters are used to create subsets of data in a Microsoft Excel worksheet. The "AutoFilter" or "Sort and Filter" function in Excel allows you to create views of data matching your specified criteria.

I have an (output) worksheet which takes its information about Supplier Purchase Orders from a second (input) worksheet. I would like to allow the users to produce lists of purchase orders from a ...

Autofilter is one of the great features of Excel. But it’s a little long-winded as you work your way through the menus. Speed up filtering by bringing the Autofilter and Show All icons into your ...

When I created a table and merge something in this table, I got an error when opening the excel file. Excel completed file level validation and repair. Some parts of ...

With Microsoft Excel 2003, you can create complex spreadsheets that contain anything from formulas to images. If you want to print an Excel spreadsheet but don't want to include rows that have a cell ...

Editor’s Note: To read more about spreadsheets, share a tip with other readers, or suggest a topic for Bill Jelen to cover in an upcoming column, click here to visit CFO.com’s Spreadsheet Tips Page.

Throwing a lot of work into a shared Excel sheet can be rewarding, which is why it’s even more soul-crushing to wake up one day to find it destroyed. Unfortunately, whether by accident or malice, ...