ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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
تم إضافة السؤال من قبل Abdul Kareem Chala Mohammed , Senior Designer , iSmarthome
تاريخ النشر: 2016/06/16
Ghada Eweda
من قبل 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
من قبل Joel Thomas , Auditor , DME HoldingGroup

Freeze the first column

Click View > Freeze Panes > Freeze First Column.

 

Chinnu Chandran Girija
من قبل 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
من قبل 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
من قبل 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.

Noaf Khalid
من قبل Noaf Khalid

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
من قبل 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
من قبل Sarath Raghunath , Assistant Engineer trainee in Radisson Blu , Radisson Blu Hotel, Doha

Click view -> freeze panes -> Freeze top column

BAL KRISHNA JHA
من قبل 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
من قبل 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

المزيد من الأسئلة المماثلة

هل تحتاج لمساعدة في كتابة سيرة ذاتية تحتوي على الكلمات الدلالية التي يبحث عنها أصحاب العمل؟