Navigating a large database?

A

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.
 
R

Rowan Drummond

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

Hope this helps
Rowan
 
B

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
 
D

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.
 
Top