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

In my Excel 2000, Menu DataForm does just what I think you want.

Noel

"Sasha" wrote in
...
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?


 
ExcelBanter Database Error
Database Error Database error
The ExcelBanter database has encountered a problem.

Please try the following:
  • Load the page again by clicking the Refresh button in your web browser.
  • Open the www.excelbanter.com home page, then try to open another page.
  • Click the Back button to try another link.
The www.excelbanter.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
 
We apologise for any inconvenience.