Reference: The cell or range of cells or range of cells for which you want to return the column number. It is optional. Array: An array or array formula, or a reference to a range of cells for ...

Thankfully, Excel makes it easy to hide or unhide rows and columns, allowing you to declutter your spreadsheet and focus on the information that matters most. How to Hide Columns and Rows in Excel ...

An easy way to do that is to lock a row (or column), so it stays in a fixed location while the rest of the spreadsheet scrolls up and down (or side to side). There are two ways to do this ...