Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
wolfpack95
 
Posts: n/a
Default make autofilter buttons more discernable?


My eyesight is getting worse and I'm having trouble discerning the blue
or black arrow when using autofilter. Besides increasing the view
percentage (not desirable), is there anything I can do?


--
wolfpack95
------------------------------------------------------------------------
wolfpack95's Profile: http://www.excelforum.com/member.php...info&userid=93
View this thread: http://www.excelforum.com/showthread...hreadid=388697

  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Debra Dalgleish posted a response from Tom Ogilvy to get the filter criteria:

http://groups.google.co.uk/group/mic...00cb43ac5960ae

or
http://tinyurl.com/ajndr

Maybe you could use it in the cell above each filter. Then you could use some
kind of conditional formatting to even color those cells.

(I don't think that there's anything you can do to "fix" those arrows/colors.)

But some things that may make it easier.

If you go through each column to reset the autofilter to show all the data, you
can use:

Data|Filter|Show All
(or even drag that icon to your favorite toolbar)

Tools|customize|commands tab|Data Category
look for ShowAll

And if you're just trying to notice if the worksheet has any filters turned on,
take a look at the row numbers of that filtered range. If they're blue, then
you do.




wolfpack95 wrote:

My eyesight is getting worse and I'm having trouble discerning the blue
or black arrow when using autofilter. Besides increasing the view
percentage (not desirable), is there anything I can do?

--
wolfpack95
------------------------------------------------------------------------
wolfpack95's Profile: http://www.excelforum.com/member.php...info&userid=93
View this thread: http://www.excelforum.com/showthread...hreadid=388697


--

Dave Peterson
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
Any insight into cause of Autofilter buttons to stop working? Michael Excel Discussion (Misc queries) 4 August 18th 05 04:21 PM
How do I make hide detail buttons in Excel 2002? nrg Excel Worksheet Functions 1 July 8th 05 01:08 AM
Strange Results with Autofilter Joyce Excel Discussion (Misc queries) 1 January 17th 05 02:42 AM
make hidden window or workbook visible without specify the name mango Excel Worksheet Functions 1 December 30th 04 03:05 PM
How can I make autofilter show the filtered number of rows bsell123 Excel Worksheet Functions 1 October 28th 04 06:12 PM


All times are GMT +1. The time now is 03:54 PM.

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

About Us

"It's about Microsoft Excel"