Auto Filters

[Steved]

Hello from Steved

When using Auto Filters and I am in cell A2 is their a
Macro I can use so I can use to put it back to cell A2.
An example would be in cell AA200 to put it back I would
have to go into filter and select all for it to go back to
A2, there has to be a better way.

ps I'm new to Auto Filters

Thankyou

 

[Frank Kabel]

Hi
not really sure what you're trying to achieve. what do you mean with
'put it back'

 

[Steved]

Hello Frank from Steved

Sorry Frank my terminology is not the best.
My cursor is in cell A2 I use the auto filter and my cusor
say end up in cell AA200 how do I get the cusor back to A2
hopefully Frank I given you an I'dea as to what I mean.
Cheers

 

[Debra Dalgleish]

After filtering, you can choose Data>Filter>Show All
This will show all the rows that have been hidden by filtering.

You can also add the Show All button to one of your toolbars, to make it
easier to use:

Choose Tools>Customize
Select the Commands tab
Select the Data category
Scroll down to find the Show All command
Drag the Show All command to one of your existing toolbars
Close the Customize dialog box.

 

[Frank Kabel]

Hi
just hit CTRL+HOME

 

[Steved]

Thankyou, Thankyou.

-----Original Message-----
After filtering, you can choose Data>Filter>Show All
This will show all the rows that have been hidden by filtering.

You can also add the Show All button to one of your toolbars, to make it
easier to use:

Choose Tools>Customize
Select the Commands tab
Select the Data category
Scroll down to find the Show All command
Drag the Show All command to one of your existing toolbars
Close the Customize dialog box.


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

.