LearnFast.Ninja

How to freeze columns (cells) in Excel 2010

For freeze columns select the column you want to start with. Note: For freeze rows select row. Click View then Freeze Panes then Freeze Panes. Result: keep columns visible while the rest of the worksheet scrolls, based on your selection.

Step 1: For freeze columns select the column you want to start with.


Note: For freeze rows select row.

Step 2: Click View > Freeze Panes > Freeze Panes.


Result:


Tags

excel

freeze