Many Excel spreadsheets use the IFERROR function to handle errors, but this masks critical structural and data issues.

Text overflow can break a spreadsheet’s appearance, as it might look awkward with overflowing texts coming out of a cell. If you have a spreadsheet with this problem, you can fix the text-overflow ...

If-Then rules allow you to create colorful business spreadsheets that do more than look pretty. Meaningful colors can help you and others identify data quickly, recognize trends and even spot ...

Microsoft Excel 2010 does not include a bullet button on the command ribbon. However, you can still create an indented, bulleted list using shortcut keystrokes. Microsoft Office also allows you to ...

Discover 87 Excel tips and tricks that will take you from a beginner to a pro. Improve your efficiency, productivity and skills with these helpful Excel techniques. Microsoft Excel was first released ...

I'm importing a lot of comma delimited text files into Excel - because they all have the exact same formatting, is there a way to tell Excel to process all of them the same way? (ie, what fields to ...