ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Need to input data in excel that will print to pre printed sheets (https://www.excelbanter.com/setting-up-configuration-excel/31146-need-input-data-excel-will-print-pre-printed-sheets.html)

Q

Need to input data in excel that will print to pre printed sheets
 
I am trying to use a worksheet that looks exactly like a pre-printed sheet.
When I input data to the sheet, I ONLY want the data that was input to print
off. How can I set this up?

Anne Troy

Try Word instead. You can print only data for forms in Word.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Q" wrote in message
...
I am trying to use a worksheet that looks exactly like a pre-printed

sheet.
When I input data to the sheet, I ONLY want the data that was input to

print
off. How can I set this up?




Need to input data in excel that wil

1.Select the only data you'd like to print
2. Select File --Print Area --Set print Area
3. Select File --Print Preview
4. Select Setup
5. Select Fit to one page
6. Print

"Q" wrote:

I am trying to use a worksheet that looks exactly like a pre-printed sheet.
When I input data to the sheet, I ONLY want the data that was input to print
off. How can I set this up?



All times are GMT +1. The time now is 01:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com