Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How can I freeze a column in excel? I want to make my first column always visible even if I scroll for long.

How can I freeze a column in excel? I want to make my first column always visible even if I scroll for long.

user-image
Question added by Abdul Kareem Chala Mohammed , Senior Designer , iSmarthome
Date Posted: 2016/06/16
Ghada Eweda
by Ghada Eweda , Medical sales hospital representative , Pfizer pharmaceutical Plc.

You want to scroll down and see your rows of data, but when you get to the bottom of the screen, your column names in the top row have disappeared. To fix this, you freeze the top row so that it's always visible. Good news – the command is easy to get to. Click View > Freeze Panes > Freeze Top Row.

Freeze the top row

Freezing top row

Notice that the border under row 1 is a little darker than other borders, meaning that the row above it is frozen.

Row 1 frozen

Freeze the first column

If you'd rather freeze the leftmost column instead, click View > Freeze Panes > Freeze First Column.

Freezing first column

Now, the line to the right of column A is a little darker than the other lines, meaning that the column to its left is frozen.

Column A frozen

Joel Thomas
by Joel Thomas , Auditor , DME HoldingGroup

Freeze the first column

Click View > Freeze Panes > Freeze First Column.

 

Chinnu Chandran Girija
by Chinnu Chandran Girija , Sr. Project Manager , D+H Financial Solutions India Pvt Ltd

Select the first column or row in you excel sheet, then select the view tab. You can find a sub menu item or a icon called Freeze Panes and click the option you required.

 

Abdul Rasheed Mohammed
by Abdul Rasheed Mohammed , accountant general , New Generation Consultants

Freeze  First Column

First of all select the column than click View than  choose the Freeze Panes and go to the the Freeze First column .

Usama Arshad Lodhi
by Usama Arshad Lodhi , Engineering Intern

  1. select the column.
  2. go to View Ribbon
  3. select the Freeze Panes.
  4. select the the First column 

now if u scroll for long the First column is always be visible.

First select the column which you want to freeze. i.e.first column,then got to view select freeze panes and select freeze first column. Thus you can scroll for long with first column always visible.

Jay Zacarias
by Jay Zacarias , Sales Coordinator , NAFFCO Qatar

Place your cursor to the next column after the column you want to freeze then on your View menu select Freeze Panel. For example if you want to freeze Column A place your cursor to Column B1 then go to View Menu then select Freeze Panel.

Sarath Raghunath
by Sarath Raghunath , Assistant Engineer trainee in Radisson Blu , Radisson Blu Hotel, Doha

Click view -> freeze panes -> Freeze top column

BAL KRISHNA JHA
by BAL KRISHNA JHA , ACCOUNTS MANAGER , Advertising & Construction

BY CLICKING ON VIEW MENU >FREEZE PANE>FREEZE FIRST COLOUM

WE CAN FREEZE FIRST ROW BY THIS WAY BY SELECTING THEM.

 

Firas Shahadi
by Firas Shahadi , Training And Development Director , Muhayal Assir National Hospital

just select the cell next to left of your needed column and go to 

view tab >> windows group >> Freeze options

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.