There's a fine line between a well-formatted Microsoft Excel worksheet and one that's full of issues that take time to fix. Whether you're an Excel newbie or a seasoned pro, avoiding these formatting ...

Microsoft Excel’s conditional formatting is a wonderful “automatic” feature that allows you to formats cells based on the value of those cells or the value of the formulas in those cells. For example, ...

How to use conditional formatting to highlight rank in Microsoft Excel Your email has been sent Microsoft Excel’s RANK.EQ() function shows the relationship between values by ranking those items by ...

However, when you're creating a spreadsheet in Microsoft Excel, the double-click shortcut can be just as useful. In this guide, I'll share 11 of my favorite double-click Excel tricks. After typing a ...

How to add a conditional format that highlights groups in Excel Your email has been sent The article, How to use a border to discern groups more easily in Microsoft Excel, shows you how to use a ...

Unless someone's calculator needs an upgrade, one plus one usually adds up to two. With Microsoft Excel, you can put that math to work when you input two separate columns of data into a single ...

Excel documents come in the form of spreadsheets, also known as worksheets, made up of a collection of cells on a single sheet of data. The 2003 version of MS Excel gives you options for rotating – ...

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, ...

Excel responds to certain letter and number entries with automatic formatting. This makes sense in most cases, but sometimes it can be very annoying, as the user then has to switch back to the desired ...