How to print rows as Forms or Records

We have a spreadsheet with about 26 columns and and 100 rows.

Each row is a record and we would like to print the entire spreadsheet so
that each row is printed on a page and sorta formated like a Form.

You guys have helped me with the Form View of selected rows.

Anyway to print each row as a form?

thanks for any help.

Excel prints sheets they way they're laid out, with a few extras, like
headings, and rows and columns to repeat. That's about it. For a one page
per row layout, you could use Access. You can link the Excel list, and use
an Access Report. Very flexible print layout. You could also use Word mail
merge.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"tmb" <[email protected]> wrote in message
news:Hwn%[email protected]...
> We have a spreadsheet with about 26 columns and and 100 rows.
>
> Each row is a record and we would like to print the entire spreadsheet so
> that each row is printed on a page and sorta formated like a Form.
>
> You guys have helped me with the Form View of selected rows.
>
> Anyway to print each row as a form?
>
> thanks for any help.
>
>

It's pretty much a kludge, but if you must stick to Excel, try copying
the column headings to the first row of a group of sheets.
Then copy the first record to the second row of the first sheet in the
group.
Select the cells from both rows in the first sheet, click copy.
Select a cell below the first two rows.
Choose Paste Special from the Edit menu, click on Transpose.
You'll see what looks like a form now and you'll probably have to adjust
column widths.

Create a macro to automate the process.

I suspect linking to Access or using Word as another poster suggested is
the better approach.

Bill

"tmb" <[email protected]> wrote in message
news:Hwn%[email protected]...
We have a spreadsheet with about 26 columns and and 100 rows.

Each row is a record and we would like to print the entire spreadsheet
so
that each row is printed on a page and sorta formated like a Form.

You guys have helped me with the Form View of selected rows.

Anyway to print each row as a form?

thanks for any help.

Earl,

How can I "link the Excel list" and use an Access Report?

(I'm not sure what you mean by "Excel list")

Must I export the spreadsheet as a comma delimited or whatever file and
import it into Access?

thanks - tmb

"Earl Kiosterud" <[email protected]> wrote in message
news:%[email protected]...
> Excel prints sheets they way they're laid out, with a few extras, like
> headings, and rows and columns to repeat. That's about it. For a one
> page per row layout, you could use Access. You can link the Excel list,
> and use an Access Report. Very flexible print layout. You could also use
> Word mail merge.
>
> --
> Earl Kiosterud
> mvpearl omitthisword at verizon period net
> -------------------------------------------
>
> "tmb" <[email protected]> wrote in message
> news:Hwn%[email protected]...
>> We have a spreadsheet with about 26 columns and and 100 rows.
>>
>> Each row is a record and we would like to print the entire spreadsheet so
>> that each row is printed on a page and sorta formated like a Form.
>>
>> You guys have helped me with the Form View of selected rows.
>>
>> Anyway to print each row as a form?
>>
>> thanks for any help.
>>
>>
>
>

tmb,

Excel list is your table. It needs headings, and the rows need to be
contiguous. It should have headings in row 1, or you should have named the
range, so Access can be told where it is.

In Access, once you've started a database, use File - Get external data. If
this is a one-time deal, use Import. If you'll be doing it regularly, use
Link. Change the file type to xls, and navigate to the folder containing
the workbook. Now lay out your Access report, using that table as the data.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"tmb" <[email protected]> wrote in message
news:EYE%[email protected]...
> Earl,
>
> How can I "link the Excel list" and use an Access Report?
>
> (I'm not sure what you mean by "Excel list")
>
> Must I export the spreadsheet as a comma delimited or whatever file and
> import it into Access?
>
> thanks - tmb
>
> "Earl Kiosterud" <[email protected]> wrote in message
> news:%[email protected]...
>> Excel prints sheets they way they're laid out, with a few extras, like
>> headings, and rows and columns to repeat. That's about it. For a one
>> page per row layout, you could use Access. You can link the Excel list,
>> and use an Access Report. Very flexible print layout. You could also
>> use Word mail merge.
>>
>> --
>> Earl Kiosterud
>> mvpearl omitthisword at verizon period net
>> -------------------------------------------
>>
>> "tmb" <[email protected]> wrote in message
>> news:Hwn%[email protected]...
>>> We have a spreadsheet with about 26 columns and and 100 rows.
>>>
>>> Each row is a record and we would like to print the entire spreadsheet
>>> so that each row is printed on a page and sorta formated like a Form.
>>>
>>> You guys have helped me with the Form View of selected rows.
>>>
>>> Anyway to print each row as a form?
>>>
>>> thanks for any help.
>>>
>>>
>>
>>
>
>

I created a simple "form" for viewing/printing individual records with this solution:

1.Open blank sheet

2."Copy" the heading row from the active sheet, then "paste special - transposed" to col A in new sheet. Headings will now appear vertically.

3. Repeat (2) for each required data row into a new column, pasting into top row to match headings.

That record can now be printed. I keep the headings column as a form of template, and delete the record when I want to process another record.