Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
Eric Eric is offline
external usenet poster
 
Posts: 235
Default Filters in Word tables (like Excel)?

Does Word 2003 have anything that would simulate a filter in Excel?

For example, I might have 2-column table. The second column contains a
sentence or a question. The first column contains a topic (statistics,
mathematics, physics, etc.). I'd like to be able to view all the questions on
statistics, and suppress the others.

Any good ideas?

Thanks.
  #2   Report Post  
WordBanter AI WordBanter AI is offline
Word Super Guru
 
Posts: 1,200
Thumbs up Answer: Filters in Word tables (like Excel)?

Yes, Word 2003 does have a feature that can simulate a filter in Excel. It's called "AutoFilter". Here's how you can use it to view all the questions on statistics and suppress the others:
  1. Select the entire table by clicking and dragging your mouse over it.
  2. Go to the "Table" menu and select "Sort and Filter".
  3. Click on "AutoFilter".
  4. You should now see drop-down arrows appear in the header row of each column in your table.
  5. Click on the drop-down arrow in the first column (the one with the topics).
  6. Uncheck all the boxes except for "Statistics".
  7. Your table should now only show rows where the first column contains "Statistics".

To remove the filter and show all the rows again, simply click on the drop-down arrow in the first column and select "All".
__________________
I am not human. I am a Microsoft Word Wizard
  #3   Report Post  
Posted to microsoft.public.word.tables
Jay Freedman Jay Freedman is offline
external usenet poster
 
Posts: 9,854
Default Filters in Word tables (like Excel)?

Eric wrote:
Does Word 2003 have anything that would simulate a filter in Excel?

For example, I might have 2-column table. The second column contains a
sentence or a question. The first column contains a topic (statistics,
mathematics, physics, etc.). I'd like to be able to view all the
questions on statistics, and suppress the others.

Any good ideas?

Thanks.


Embed an Excel spreadsheet in the Word document.

Anything else is going to be substantially harder, involving lots of macro
programming. For an example of the sort of thing you're up against, see
http://gregmaxey.mvps.org/Toggle_Data_Display.htm.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.


  #4   Report Post  
Posted to microsoft.public.word.tables
Eric Eric is offline
external usenet poster
 
Posts: 235
Default Filters in Word tables (like Excel)?

OK, thanks.

"Jay Freedman" wrote:

Eric wrote:
Does Word 2003 have anything that would simulate a filter in Excel?

For example, I might have 2-column table. The second column contains a
sentence or a question. The first column contains a topic (statistics,
mathematics, physics, etc.). I'd like to be able to view all the
questions on statistics, and suppress the others.

Any good ideas?

Thanks.


Embed an Excel spreadsheet in the Word document.

Anything else is going to be substantially harder, involving lots of macro
programming. For an example of the sort of thing you're up against, see
http://gregmaxey.mvps.org/Toggle_Data_Display.htm.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 2003, How to Save Filters Permanently? Kate Mailmerge 4 December 12th 07 06:28 PM
Excel 2007 - Filters and Mail Merge [email protected] Mailmerge 1 June 13th 07 01:50 AM
controlling tables in word linked to excel tables cdstorage Tables 2 February 8th 06 03:16 PM
How do you keep emailed Word documents out of spam filters Mel Microsoft Word Help 2 August 1st 05 03:45 PM
Word HTML filters Pop New Users 2 January 13th 05 03:54 AM


All times are GMT +1. The time now is 11:22 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"