View Single Post
  #1   Report Post  
Dave Peterson
 
Posts: n/a
Default Navigating a large database?

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