MS Excel - Freeze panes

By xngo on August 31, 2019

In MS Excel, using Freeze Panes feature on selected columns is tricky. First, you have to select from the right to the left and you have to select 1 extra column from the right. Then, navigate to View > Freeze Panes and select Freeze Panes.

MS Excel - Freeze Panes path

For example, suppose that you have the following data. If you want to freeze columns Segment and Country, then you have to select columns in the following order: Product, Country, Segment. Finally, select the Freeze Panes.

MS Excel - Selected columns

The same principle apply to the rows. Therefore, you have to select from the bottom to the top and you have to select 1 extra row from the bottom.

About the author

Xuan Ngo is the founder of He currently lives in Montreal, Canada. He loves to write about programming and open source subjects.