Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Apply a filter in a Word table to view certain records
I think the closest you can come to a filter function without making any VBA
programming is to use the sort functionality in Table Sort. You do not need to select the entire table before sorting. Just click anywhere in the table to position the insertion marker before you select Table Sort. When you want to find, e.g., all items assigned to a certain person, sort on the column that contains the name/initials/ID information, sort by *text*. All rows will still be there but the items will be grouped according to your sort criteria. If you need to be able to return to a certain order of your table rows, you could add a column, e.g. to the left in the table, and enter sequential numbers (use 1, 2, 3, etc.) in that column. The numbers need to be normal text, not fields that would be changed if you change the row order and update fields. When you want to return to your original row order, sort by that numbered column, sort by *number* (if you sort by text, 11 would come before 2, etc.). In order to make it faster to change the sort order, you could assign a keyboard shortcut to the Sort command. See Word help on €śAssign or remove a shortcut key€ť if needed (in the Customize Keyboard dialog box, select €śTable€ť in the Categories list, select €śTableSort€ť in the Commands list). -- Regards Lene Fredborg "Ferdie" wrote: I want to use a Word table for status tracking of agenda items during follow-up meetings. Each item is assigned to a specific person/code. I want to know if I can in this table have a feature such as the Auto filter feature in Excel or an Access table. Reason for not using Excel - cannot bullet items in a single cell. Using Office 2003. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting WordPerfect 12 files to Word 2003 | New Users | |||
take yet another lesson from wordperfect "reveal codes" | Microsoft Word Help | |||
Change paper size; Word changes to invalid margins | New Users | |||
WP merge file to Word | Tables | |||
Word applies direct format on File open | Microsoft Word Help |