You can use the Freeze Panes command to “freeze” (lock) rows and/or columns in place so that headings remain visible at the top of your report as you scroll down your spreadsheet.
The Autofilter allows you to find, show or hide specific data faster within a database. You can filter data based on two or more criteria by using Excel’s advanced filtering features. Excel provides the Custom AutoFilter and Advanced Filter tools for specifying multiple filtering criteria. Filtering refers to displaying only the information that meets specific criteria.
Ask us how we can service your company's training requirements.
Reviews
There are no reviews yet.