Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
HT
 
Posts: n/a
Default Filter (do not want the ugly drop-down button)

ExcelXP

I created a chart that has a column of dates. Every week I send out the
chart and filter the column to just show one date. The drop-down button
appears next to all of the columns. I just want the results without the ugly
drop-down button.

Please advise.

Thanks in advance...


  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

You could use an Advance Filter, instead of an AutoFilter. There are
instructions he

http://www.contextures.com/xladvfilter01.html

Or, creating another row of headings, directly above the filter
headings. When you want to print the chart, hide the row with the filter
headings.


HT wrote:
I created a chart that has a column of dates. Every week I send out the
chart and filter the column to just show one date. The drop-down button
appears next to all of the columns. I just want the results without the ugly
drop-down button.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

Copy the visible cells to another sheet and send that out.

Alternative......

Go to ToolsOptionsView and checkmark "hide all" under the Objects section.


Gord Dibben Excel MVP

On Wed, 30 Mar 2005 15:08:04 -0500, "HT" wrote:

ExcelXP

I created a chart that has a column of dates. Every week I send out the
chart and filter the column to just show one date. The drop-down button
appears next to all of the columns. I just want the results without the ugly
drop-down button.

Please advise.

Thanks in advance...


  #4   Report Post  
HT
 
Posts: n/a
Default

Thank you Debra and Gord..

Hiding the object was the easiest..(Tools, Options, View, Hide All).

I am practicing with Advanced Filters for another use.

Thanks again!

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Copy the visible cells to another sheet and send that out.

Alternative......

Go to ToolsOptionsView and checkmark "hide all" under the Objects

section.


Gord Dibben Excel MVP

On Wed, 30 Mar 2005 15:08:04 -0500, "HT"

wrote:

ExcelXP

I created a chart that has a column of dates. Every week I send out the
chart and filter the column to just show one date. The drop-down button
appears next to all of the columns. I just want the results without the

ugly
drop-down button.

Please advise.

Thanks in advance...




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drop Down Filter Bob Beard Excel Discussion (Misc queries) 1 March 11th 05 02:10 PM
In cell drop down button disappeared lunker55 Excel Discussion (Misc queries) 12 February 25th 05 07:42 PM
Is it possible to change the blue colour of an activated Auto Filter button? Marcel Wilmink via OfficeKB.com Excel Discussion (Misc queries) 1 February 24th 05 09:35 PM
Macro to simply bring up the Find dialogue box?? marika1981 Excel Discussion (Misc queries) 14 January 14th 05 11:47 PM
The Auto Filter button lost the column specified option. D Excel Worksheet Functions 1 November 5th 04 12:47 AM


All times are GMT +1. The time now is 06:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"