Date
|
: Tuesday, May 22, 2012
|
Written by
|
: Y. Harry Siswanto H / harry.siswanto@gmail.com
|
Type
|
: Tips and Tricks / Manual Documents
|
Engine
|
: Microsoft Windows Win7 SP1 – Microsoft Office 2007
|
Subject
|
: Freeze and Filter in MsExcel 2007
|
Application
|
: MsExcel 2007
|
I. Using Freeze
View the sample data;
Click on View-Freeze Panes
Click Freeze Panes
Result;
When you Scroll-Right; the column A to E will fix
When you scroll-down; the row 1 and 2 will fix
To Unfreeze; you can click View-Freeze Panes-Unfreeze Panes
II. Using Filtering
View the sample data;
Click Tab Data-Filter
Result;
To Remove Filtering, you can click again the Filter Button;
Good Luck !!!
