954,301 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

filter of excel

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?

Attachments auto_filter.JPG 144.76KB
abu taher
Practically a Posting Shark
845 posts since Jul 2008
Reputation Points: 14
Solved Threads: 78
 

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

pcs365_4
Light Poster
40 posts since Apr 2010
Reputation Points: 10
Solved Threads: 4
 

This question has already been solved

Post: Markdown Syntax: Formatting Help
You
View similar articles that have also been tagged: