Forum Home
Press F1
Thread ID: 113636	2010-10-29 01:16:00	Excel 2007 - data filter	johcar (6283)	Press F1

Post ID	Timestamp	Content	User
1148507	2010-10-29 01:16:00	I have been experiencing some inconsistent behaviour with a command on the QAT. On my personal laptop, if I click the Autofilter button on the QAT, the filters are applied to whatever is highlighted in the spreadsheet. If I click it again, the filters are toggled off. At work, the same button on the QAT will set the filters (just like at home), but if I click the button again, nothing happens - the filters are still present. I know there is a keyboard shortcut (Ctrl+Shift+Alt+L) that will toggle the filters on and off, but I am more interested to find out why the install of Excel 2007 behaves differently (and as I like it) on my personal laptop... Anyone with any suggestions?	johcar (6283)
1148508	2010-10-29 02:00:00	Doh! Just discovered I have applied the "Autofilter" button to the QAT on the work machine and the "Filter" button to the QAT on the personal machine. The "Filter" button enables toggling on and off! Fixed! Resolved.	johcar (6283)
1148509	2010-10-29 08:00:00	There are many things I could say right now ... I could point the finger and say "what a bloody dropkick he'd be" .... but I wont .... coz while I point at you ... 4 fingers are pointing back at me. Not that I've ever done a dumb thing like that though :blush:	SP8's (9836)
1148510	2010-10-29 08:41:00	This is just the latest in a series of stupid things for me. I specialise in idiotic stuff. Great way to learn... :pf1mobmini:	johcar (6283)
1