Printing Parts of Worksheets in VS .NET

Generate Data Matrix 2d barcode in VS .NET Printing Parts of Worksheets

If the contents of a worksheet will take up more than one printed page, you can have Excel repeat one or more rows at the top of the page or columns at the left of the page. For example, if you want to print a lengthy worksheet containing the mailing addresses of customers signed up to receive your company s monthly newsletter, you could repeat the column headings Name, Address, City, and so forth at the top of the page. To repeat rows at the top of each printed page, on the Page Layout tab, in the Page Setup group, click Print Titles. Excel will display the Sheet page of the Page Setup dialog box. On the Sheet page of the Page Setup dialog box, you can use the commands in the Print Titles area to select the rows or columns to repeat. To choose rows to repeat at the top of the page, click the Collapse Dialog button next to the Rows To Repeat At Top box, select the rows, and then click the Expand Dialog button. The rows you selected appear in the Rows To Repeat At Top box. Similarly, to have a set of columns appear at the left of every printed page, click the Collapse Dialog button next to the Columns To Repeat At Left box, select the columns, and then click the Expand Dialog button. When you re done, click OK to accept the settings. In this exercise, you ll select certain pages of a worksheet to print, have Excel fit your printed worksheet on a set number of pages, define a multi-region print area, center the printed material on the page, and repeat columns at the left edge of each printed page.

11

SET UP You need the HourlyPickups_start workbook located in your 11 practice file folder to complete this exercise. Open the HourlyPickups_start workbook, and save it as HourlyPickups. Then follow the steps.

Excel displays your worksheet in the Backstage view, which includes a preview of how your worksheet will appear when printed.

6. Under Pages in the Settings area, in the From field, type 1; in the To field, type 2. 7. On the ribbon, click the Page Layout tab; in the Scale to Fit group, click the

Excel resizes your worksheet so that it will fit on two printed pages. The new scaling and size values appear in the Scale To Fit group on the Page Layout tab.

11

Excel removes the print areas defined for the JanFeb worksheet. CLEAN UP Save the HourlyPickups workbook, and then close it.

With charts, which are graphic representations of your Excel data, you can communicate lots of information with a single picture. Depending on your data and the type of chart you make, you can show trends across time, indicate the revenue share for various departments in a company for a month, or project future sales using trendline analysis. After you create a chart, you can print it to include in a report or use in a presentation. If you embed a chart in a worksheet, however, the chart will probably obscure some of your data unless you move the chart to a second page in the worksheet. That s one way to handle printing a chart or the underlying worksheet, but there are other ways that don t involve changing the layout of your worksheets. To print a chart, click the chart, click the File tab, and then click Print to display the Print page in the Backstage view. In the Settings area, Print Selected Chart will be the only option available. If you click anywhere on the worksheet outside the chart, the Print What area opens with the Print Active Sheets option selected, meaning that the chart and underlying worksheet are printed as they appear on the screen. When you re ready to print the chart, click the Print button. In this exercise, you ll print a chart. SET UP You need the CorporateRevenue_start workbook located in your 11 practice file folder to complete this exercise. Open the CorporateRevenue_start workbook, and save it as CorporateRevenue. Then follow the steps.