When you're configuring data in a Microsoft Excel worksheet, you may realize that the information you entered in rows makes better sense in columns or vice versa. For example, you're especially ...

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.

In this guide, you'll learn how to freeze top 2 rows in your Microsoft Excel spreadsheet and keep headers visible while ...

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.

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

In Microsoft Excel, there are row and column headings on your spreadsheet by default. The column header is the grey color alphabetical columns above the spreadsheet, and it identifies each column ...

Q: I read your colleague David Einstein's description of how to make row and column headings repeat on each page of an Excel spreadsheet in Windows. The Mac version appears to be just a bit ...

How to Hide Columns and Rows in Excel Hiding rows and columns in your Excel spreadsheet is straightforward, as expected. To do this, select the column or row you want to hide. Then, right-click on ...

The typical unhiding techniques don't work everywhere in Excel. Learn an easy to remember method for unhiding row 1 and column A.