frozen panes

  1. D

    Freezing Panes

    Hello all, I wish to freeze a pane like one normally would then, if you are scrolling down and meet a particular row while scrolling down, that row becomes another part of the frozen pane area. Example... An employee list: Two different tables with one row gap between them, one for Full Time...
  2. L

    Scrolling selected cell to top left position of unfrozen pane

    I have a big honkin' spreadsheet. By selecting Cell D7 and using the "Freeze Panes" command, I have ensured that the left 3 columns and the top 6 rows will always be on the screen. The rest of the spreadsheet is for data entry, and there can be hundreds of rows & columns. I have successfully...
  3. K

    Frozen Panes not Alphabetizing

    I am using excel 2007 I need to freeze the top of my document to maintain headings. When I freeze or split the cells, I loose the option to Alphabetize ONLY after I protect the sheet. The sheet works well until I protect it. How can I freeze the heading, protect the sheet, and still maintain...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top