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.

You use Microsoft Excel 's built-in function to freeze specific rows and columns (often row or column headers), so when you’re scrolling through, these cells remain stationary on the page.

Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it.

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

Adding a new column to either an entire spreadsheet or just a portion is an easy thing to do in Microsoft Excel. Here's how.

A simple trick lets you copy source column's width to a target column in Excel. Refer to the steps in the post to copy column widths in Excel.

If you have ever used Excel to review a large database, you know how useful it is to be able to freeze cells, such as the top row or the first column. It’s so handy because these two places are ...

You can alphabetize data in an Excel spreadsheet by row or column using the "Sort" feature, or through the "Data" and "Home" tabs.