I have a spreadsheet where I have a frozen pane (rows 1:15). This information I want to have on the screen all the time as I scroll down through the rest of the spread. My question is this...why can't I put a validation for a cell in row 8 (or any within this frozen area)? I can put formulas that reference both cells within and outside of the frozen area, and they work fine. You folks have been very helpful in the past...look forward to your answer to this one!