Formulas in visible sheets that reference cells in very hidden sheets still work as expected. As well as hiding whole worksheets within Excel workbooks, you can also hide rows and columns within ...

There are two ways to do this: You can freeze the first visible row, or you can freeze a set of rows. Keep in mind that this doesn't have to literally be the top row in your spreadsheet - this ...