SPECIAL PRINT FUNCTION IN EXCEL

[KN3M3SIS]

I have about 300 Rows on an EXCEL sheet that I need to print.

I need for each line to print on a seperate page with the headers included. How can this be done?

 

[combo]

You can try to increase row heights (just to be less precise) and increase top/bottom margins in page setup.
Alternatively, if your worksheet has a database table layout, consider printing from word via serial correspondence with worksheet as a data source.

combo

 

[KN3M3SIS]

Thank you for your response. I've never printed excel information in word. Could you help me or point me towards a reference sheet to use.

Thank you in advance.

 

[jonsi]

It sounds like you need to use Mail Merge from Excel into Word? Then each single page would be unique to the line of data but each would follow the same layout.



hwyl
Jonsi B-)
"We live in a society exquisitely dependent on science & technology, in which hardly anyone knows anything about science & technology"

 

[KN3M3SIS]

I have a table in acces.
Name >> Position >> Hours

I need for letters to be printed for each name and the corresponding data.
In the event that the same name pops up twice, which will happen, how can I have access or word print out those 2 lines on the same letter for that person?

The tables are sorted alphabetically so that the duplicates are always back-to-back.

Are there any sites or templates that someone can e-mail me to aid in this. It's rather pertinent and I've just hit a brick wall. Please advise.

 

[BlueHorizon]

Hi,

Is there any way you can use the Subtotals command? Click in your data. Then select Data | Subtotals. Under At each change in: select your first column (Name). Then under Use function: Select Sum. Under total to: select your last column (Hours). Then, at the bottom of the screen, check Page break between groups.

Now each one will print on a separate page if you want.

Good luck,
BlueHorizon

 

[combo]

Hi,
It seems that the best tool will be access report. You can use grouping option to select records with duplicates (Name). You can use for this section ForceNewPage set to AfterSection to get each person on a separate page.

combo