world of flexo
FlexoExchange Home
home bulletin board employment visit flexoDepot!
Articles

Home: Gorilla Flexo™ArticlesOperating EfficientlyNextPrevious

Scheduling Article
Page:
 1, 2, 3, 4, 5, 6, 7, 8, 9, 10


Another feature you might find useful when searching through a long list is the Filter function. Try this:

Select the top left-most cell on the sheet (it should be “Press” in this discussion). Now click on Data > Filter > AutoFilter on your menu bar. You should see little grey boxes with downward pointing arrows to the right of each cell in row 1. (If some of the headings become partly obscured by the Filter buttons, simply “Auto-Format” the column width. See appropriate Help Section in Excel to learn how to do this.)
 


See what happens when you click on them and select items from the pull-down lists. Experiment for a while to get a feel for how to use “Filter”. This feature can help you find things in a hurry. Note that when you select from the pull-down menus, all but those orders matching the selected criteria disappear. Also note that the arrow on the selected menu button becomes colored, indicating that the list is filtered by at least that criterion. You may filter by multiple criteria, each time rendering the list of orders down to shorter lists. Click Data>Filter>Show All to bring them back, or select the top choice “All” from the pull down lists involved in filtering. To remove the filters altogether, click on Data > Filter > AutoFilter again, and the buttons disappear.

(You may find it very useful to create a custom toolbar for scheduling, and create buttons that turn filters on and off, as well as other frequently used functions.)
 

 

Next Page

Get a Printer-Friendly Version of this Article!

Get a Printer-Friendly Version of this Page!

Contact Us

E-Mail:
info@flexoexchange.com

Toll-Free: 866-416-1484
Phone: 336-812-3784
Fax: 
336-884-5382

Postal Mail:
3219 Timberwolf Ave.
High Point, NC  27265
USA

 

[home] [industry news] [break room] [employment] [suppliers] [flexoDepot]

[packaging] [labels] [education] [book store] [publications]

[gorilla printing] [trade associations

[our mission] [link to us] [privacy policy]

© Copyright 1997-2006; FlexoExchange, LLC; All Rights Reserved
No portion of this site may be copied or reproduced without the express written permission of the copyright holder.