Any short key finding special cell?

W

wing

Hi,

I am new in excel and looking for ways to increase efficiency with it.

I have a long spreadsheet, i am interested in some rows where col A is
a specific value, says, X, for example

Col A Col B Col C
row 1 X B C
....
row 100 X BB CC
....
row 250 X BBB CCC

Is there any ways in excel that i could use to go to row 100 directly?
I am just wild guessing, is it possible to have a macro to access that
row and assign a short key to it.

For example, is it possible that, a marco M to find next row where col
A=X and then assign a short-key to macro M?

Thanks in advance for your ideas and inputs.

Wing
 
A

Andy B

Hi

Have a look at Autofilter. Using this you can filter your column to X and
all the other rows are hidden
 
E

Earl Kiosterud

Wing,

Yes. You could select that column, then do Edit - Find could locate your
stuff, one at a time. It will look only through the one column if you've
first selected it (click in the column heading). A macro could automate
that.

Another possibility is using Autofilter. It will reduce your table to only
those records (X) by hiding the others. You don't have to do them one at a
time. When using the Autofilter, you'll see one of each unique value in the
column, which may be a lot to weed through, depending on what you have in
that column (how many unique values). So this may not be good. But it's
easy to set up. Try it.
 
P

Paulw2k

Why not use the Autofilter (DATA-Filter-Autofilter)? Dropdown buttons
appear in the first row of data block. Click the dropdown button on the
column(say A) you want to filter on.
Select the value you wish to filter on. All the rows not meeting that
criteria are (temporarily) hidden. Best to use with a header row.
To get rid of the filter:DATA-Filter-Autofilter.
 
Top