Want to to alternate row colors in Excel? You can apply color in alternate row & column in Excel spreadsheet using Conditional Formatting.

Excel is a potent tool that can easily handle tons of data. A beneficial improvement to increase your user experience is to change cell color based on their value so that you can effortlessly read ...

Counting records or values in Microsoft Excel is easy. Counting individual cells by their fill color definitely isn't. Using an old function and a matrix tames the problem.

Excel ROW function will return the row number of a reference. ROWS will return the number of rows in a column. Learn how to use the Row and Rows function in Excel.

A row-by-row formatting rule is as easy to apply as a column-by-column in Microsoft Excel, but you might not get the results you thought you would.

Looking for a way to make your Excel spreadsheets read more clearly? Why not try freezing some of the rows and columns. Here’s how.

Use Excel's "Freeze Panes" functionality to lock rows or columns in place. Use Excel sort features to organize data in alphabetical or numerical order.