Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down Filter | Excel Discussion (Misc queries) | |||
In cell drop down button disappeared | Excel Discussion (Misc queries) | |||
Is it possible to change the blue colour of an activated Auto Filter button? | Excel Discussion (Misc queries) | |||
Macro to simply bring up the Find dialogue box?? | Excel Discussion (Misc queries) | |||
The Auto Filter button lost the column specified option. | Excel Worksheet Functions |