Open your spreadsheet in Microsoft Excel 2007. Click the first data point in the column to select it. Hold the "Shift" key and click the last data point in the list.

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.

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. $3,500 iPhone possible?

How to Group Rows and Columns in Excel. Open an Existing Spreadsheet. Highlight the row or column you want to group. On the Data tab, click the Outline button on the right corner of the Excel ...

Yes, in Excel it’s called Freezing Panes, which can be applied to columns or rows (or both), and it’s super-simple. We’ll also show you how to split screens, a similar feature.

Figuring out whether or not an Excel spreadsheet contains hidden rows or columns is fairly simple: Look for a double line between the two sections (normally you'll only see one), or if the ...