in the attach file I want the selected area will be fixed. I mean when I page down this section not go up. this will fixed and the above thing only move. how I do it?
Hi Abu,
Click 4 (4th column) to select the entire line. Then go to 'Window' option on the Menu Bar and select 'Freeze panes'. For more information, please visit: http://office.microsoft.com/en-us/excel/HP052038611033.aspx