Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display Row of Data as Form/Page
If I have records in rows with various columns of data, is there any way to
get Excel to display the columns as rows, one record per page? In other words to flip the columns and rows and print it out as if it were a data entry form? For example, let's have a list of employees with their name address and phone# as columns. Like this: Name Address Phone# Name 1 Name 2 Name 3 Can I get Excel to print out one page per employee like this? Name: Name 1 Address: Phone#: ---------- Name: Name 2 Address: Phone#: ---------- I've looked at pivot tables and they don't actually "pivot" the rows and columns, they just summarize data. I've seen the "data entry form" in Excel, but its for entry not printing. I've tried to experiment with the "transpose" function, but I can't get it to work either. It also doesn't look like it would handle a variable number of records/rows very well either. I know I can export or link to Access, but I really don't want to have to do that. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need 2 rows to display X axis data points for a line graph | Charts and Charting in Excel | |||
ranking query | Excel Discussion (Misc queries) | |||
Excel control cell display of data with passwords | Excel Worksheet Functions | |||
In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
Printing data validation scenarios | Excel Worksheet Functions |