If the Developer tab isn’t visible, click the File tab (the Office button in Excel 2007). Then, choose Options in the left pane or Excel Options, respectively.

How to Scroll Past Frozen Panes in Excel. Freezing panes enables you to lock rows or columns, so they remain static, even when scrolling. For example, you might have descriptive headers used to ...