Solved

printing in EXCEL sheet

Posted on 2011-09-06
3
186 Views
Last Modified: 2012-06-21
I have an excell document containg two sheets : sheet1 & sheet2.
i enter data in sheet 1 & the outcome is in sheet 2.
i need to print the out come, i dont want to print all the sheet,i want to print part of the sheet(sheet2)
so after entering the data in sheet 1 , i want to click somewhere and then sheet2 appears in print view.
can this be done.
Please give me an example
0
Comment
Question by:Hassanay
3 Comments
 
LVL 15

Expert Comment

by:WalkaboutTigger
ID: 36491738
Set a print area, then record a macro which does File/Print
then stop the macro recording.
Add a button on sheet 1 that runs that macro.
0
 

Author Comment

by:Hassanay
ID: 36492043
i dont know exce, how to set the print area, and what ill write in the macro
0
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst earned 500 total points
ID: 36492379
Hello,

the exact steps differ depending on your Excel version. In Excel 2007 and later:

Click Sheet2
Select the area you want to print
click the Page Layout Ribbon > Print Area > Set Print Area

If you're not familiar with Excel, I don't think using a macro would be suitable.

Without a macro, you can then enter data into Sheet1, click on Sheet2 and open the Print Preview (again, this differs from version to version). In Excel 2007 or later, you can quickly add the Print Preview icon to the Quick Access Toolbar (QAT), so you only need one click to open the Print Preview.

cheers, teylyn
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now