View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ian Ian is offline
external usenet poster
 
Posts: 238
Default In Excel how do I show the contents of just 1 row as a form?

By default there is no way to do as you wish. As you point out, Excel is not
a database and therefore lacks some built-in database type facilities.

It is, however, possible to use VBA to create a form which will do as you
wish.

--
Ian
--
"Sasha" wrote in message
...
In Microsoft Works database you can change between looking at all the
entries
(i.e. all the rows and columns) in list format, you can switch to Form
format
and see just all the columns for one entry. As an example, say you have
the
following column heads: First name, last name, address, city, state,
postal
code, phone #. In MS Works database you can click From view and see just
one
persons info/record. Then to switch back to seeing the whole list (i.e all
rows/entries and columns.

How do you view just one whole row all on one screen as the only record
you
are viewing in Excel. Or, can this only be done in Access, since Excel is
not
a database?

I am just trying to find a way to see one entry, w/o scrolling left and
right to view a long row. Is there a way to view all the columns for one
record/entry/row on screen but ONLY see just that entry?