How do I freeze a column in Excel while viewing other columns?

Solution 1:

Office 2010, do the following:

1. Make your selection that you want to remain in place
2. Go to ribbon view - freeze panes
3. Choose to freeze the top row the first column or your selection
4. The chosen selection will be frozen in place as you move up or down the sheet

Solution 2:

You can't do only specific column.

But you can target specific column and that corresponding row using

View Menu --> Freeze Pane

Example: If you are on Cell F5 (that is column F & row 5) and select Freeze Pane from View Menu then

Freezed Column will be, till Column E
Freezed Row will be, till Row 4

EDIT:

For more clarity, refer this screenshot:-