This article shows how to count nonblank cells in Excel by using differnt functions and built-in feature in Microsoft Excel.

Sometimes it's necessary to split cells in a spreadsheet, and Microsoft Excel makes it easy enough to do.

You can sum cells across multiple sheets in Excel. This article presents steps for Adding single-cell values or Adding values in the range of cells.

How to Display a Tooltip in Excel. In Microsoft Excel, tooltips are simply small windows that pop up when you select or highlight certain cells. These windows generally include a message specific ...

Do you want to keep important labels and data in view as you scroll through your Excel worksheets? Here are the steps to freezing those columns and rows.

Entering fractions in Microsoft Excel isn’t exactly intuitive, but it is easy. Learn how to enter and display fractions as either fractions or as decimal values.

Specifically, in cell H2, you want to create a drop-down list of all the nations listed in column B, and in cells I2 and J2, display the player names and average score, respectively, according to ...

Or you might want a count by colors. In this article, I’ll show you a simple way to evaluate values by the cell’s fill color using Excel’s built-in filtering feature.

Locking cells in a Microsoft Excel spreadsheet is among the most commonly used functions. Here’s a guide on how to lock cells in Excel.

How to Create a Report to Display Quarterly Sales in Excel 2007. Excel is the spreadsheet program of the Microsoft Office suite. Using Excel, you can store and track all the information that's ...

Q. Is there a way to include both a formula and text in the same cell? A. You can include both a formula and text in the same cell in Excel. You can do this in many ways, depending on what you are ...