Before you run the macro, select the cell(s) to use as the freeze location (se the chart above).If you have lots of sheets in a workbook, and want to freeze all of them at the same spot, you can use this Freeze All Worksheets macro. Click Freeze Panes, to freeze at the selected location – OR, choose a command to freeze the first row or first column.On the Excel Ribbon, click the View tab.First, select a cell, row or column, below and to the right of the area that you want frozen.If you just want to freeze one sheet, you can do it manually. If I missed something, please let me know.Īll cells above and to the left of centerĪll cells above and to the left of the selected cell
Here’s a chart, with all the options that I can think of. In an Excel worksheet, the cells(s) that you have selected will control what gets frozen. Anyway, in that movie, everything got frozen. If you’re not familiar with that song, lucky you! My granddaughter loved that movie, and had a birthday cake with Elsa on it, a couple of years ago (see the picture at the end of this post). When I hear “Frozen”, I think of the Disney movie, and the song, “Let It Go!” pops into my head. You can freeze each sheet individually, or use this macro to freeze all worksheets at once. That way, your headings are always visible, along with other key information that you’ve put at the top of the sheet. If you’re working with a large worksheet in Excel, it usually helps if you freeze the cells at the top and/or the left side of the sheet.