Navigating a large database?

[Arsenio Oloroso]

I've imported a huge data base into Excel that doesn't have field (column)
headings. The file layout indicates that the info I want is in field 117.
Can anyone suggest a way for me to locate this field quickly. I would
prefer not to have to do it by tapping the right arrow and counting off the
numbers until I get there.

Thanks for any advice.

[Rowan Drummond]

Hit F5. In the Reference field type DM1. Click Ok. That's column 117.

Hope this helps
Rowan

Arsenio Oloroso wrote:
> I've imported a huge data base into Excel that doesn't have field (column)
> headings. The file layout indicates that the info I want is in field 117.
> Can anyone suggest a way for me to locate this field quickly. I would
> prefer not to have to do it by tapping the right arrow and counting off the
> numbers until I get there.
>
> Thanks for any advice.
>
>

[Biff]

Hi!

You could change the column headings from alpha to numeric:

Tools>Options>General tab>R1C1 reference style

That way you don't have to try to figure out that column DM = 117.

Biff

"Rowan Drummond" <[email protected]> wrote in message
news:[email protected]...
> Hit F5. In the Reference field type DM1. Click Ok. That's column 117.
>
> Hope this helps
> Rowan
>
> Arsenio Oloroso wrote:
>> I've imported a huge data base into Excel that doesn't have field
>> (column) headings. The file layout indicates that the info I want is in
>> field 117. Can anyone suggest a way for me to locate this field quickly.
>> I would prefer not to have to do it by tapping the right arrow and
>> counting off the numbers until I get there.
>>
>> Thanks for any advice.

[Dave Peterson]

When I'm too lazy to toggle R1C1 reference style, I insert a temporary row and
put this in A1:

=column()

and drag across as far as I need.

Arsenio Oloroso wrote:
>
> I've imported a huge data base into Excel that doesn't have field (column)
> headings. The file layout indicates that the info I want is in field 117.
> Can anyone suggest a way for me to locate this field quickly. I would
> prefer not to have to do it by tapping the right arrow and counting off the
> numbers until I get there.
>
> Thanks for any advice.

--

Dave Peterson