Learn how to define, use & delete names in Excel formulas. It becomes easier to identify & comprehend data when you can add Names to it.

Excel offers many filtering and sorting options, including color, specific text and alphabetical. So, if you have a "Last Name" column, you can alphabetize it in ascending or descending order ...

You can search in Excel with the Search Sheet bar, and use Find and Replace to swap out terms or values. Here's how to do it.

Separating first and last names in an Excel spreadsheet is a common task that can be time-consuming if done manually. Thankfully, Excel offers several efficient methods to automate this process ...

Learn how to find and replace Text Color in Excel. The classic Find and Replace feature can be used to change the color of text in Excel.

Irene Galente asked if she can combine the name data in a number of Excel columns into a single cell. In Irene’s spreadsheet the first column displays each person’s “title” … ...

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook.

Filters are great tools, but you can't remove specific items from the results. When you need to do this, try Find All in Excel instead.

How to Find Cells With Strikethrough in Excel. For a business leader, Microsoft Excel 2010 can be an invaluable tool for monitoring inventory, recording customer information or keeping track of ...