Manage layers, hide overlapping charts, and find ghost objects using Excel’s powerful Selection Pane.

Sometimes you need to scan some files for a piece of data like a string, phrase or some number, and one of those files just happens to be an Excel spreadsheet. You could open up the file, launch the ...

Modules are just bags of code, intended to be shared between more than one worksheet or object. You can't explicitly place modules into the Objects folder; code that lives there is actually contained ...

How to split a column using an IF() function in Excel Your email has been sent We all inherit Microsoft Excel sheets that don’t suit our working routine. If it’s a simple tracking sheet of some sort, ...

Windows may get all the attention, but when you want to get real work done, you turn to the applications that run on it. And if you use spreadsheets, that generally means Excel. Excel is, of course, ...

How do we add geometric shapes in Excel, and can they be custom-designed? Excel provides over 16 dozen geometric shapes that you can size and manipulate to your specific needs, plus hundreds of ...