How to freeze a row in an excel sheet

Last update on June 19, 2009 10:00 AM by jak58
Published by netty5

How to freeze a row in an excel sheet








To freeze a line in an excel sheet, for example line 1:

Select line 2.

Go to menu Window¯ and select Freeze panes¯.
Best answers for « How to freeze a row in an excel sheet » in :
Create an Attendance Report with Excel sheet Show Create an Attendance Report with Excel sheet Issue Solution Issue In the case you want to create an attendance report with Excel , here below you will find a nice example: Consider that your report will have the following...
Compare 2 excel sheet and combine uniq data Show
Comparing two excel sheets Show
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
Excel – Comparing cell A1 to entire A column in Sheet 2 ShowExcel – Comparing cell A1 to entire A column in Sheet 2 Issue Solution Note Issue I have been trying to compare sheet1 A2 to sheet2 A2 through A500 and if it exists somewhere in sheet2's a col then copy that entire row to a new sheet....
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
They need your help