Now it is time for you to print your excel work, here in this printing option you can preview your work before printing.
To preview each page of a worksheet exactly as it will appear when it is printed, we can use Excels print preview feature. This feature will enable us to adjust the margins, header, footer, and page breaks. Click on the Print Preview button. The Print Preview window opens to display the worksheet as it will look when printed. When you place the mouse pointer over the worksheet, the cursor becomes a magnifying glass. Click on the preview’s header. The Print Preview window zooms in, focusing where you clicked the mouse button. In this case, it is the header. Click on the worksheet. The view of the worksheet has zoomed out so that a whole page is displayed. You can use this technique of zooming in and out to get a better look at any part of the worksheet when Excel is in Print Preview mode. The status bar tells us the current page and total number of pages. Click on Setup, select the Margins tab. The Margins tab on the Page Setup dialog box enables us to control how much white space fills the margins, and to center the worksheet horizontally and vertically.
Under Center On Page, check Horizontally. Click on OK. E.g. click on Margins. The dotted lines around the perimeter of the page are the margin, header, and footer markers. When you click and drag one of these margin lines. The status bar displays the distance in inches from the edge of the paper.
Click on Setup select the Margins tab. Change the Left margin value and press Enter. Moving the left margin causes the text to shift to the left. We used the Page Setup dialog box to change the margins because we wanted more precision than we could get by dragging the margin lines.
Click on Setup select the Header/Footer tab. You can choose to add headers and footers from a selection of predefined formats, or you can create custom headers and footers. Click on Custom Header. In the Left Section box, type Draft Report. You can use the Custom Header and Custom Footer buttons to format or edit the selected header or footer.
Press Tab twice. Click on the Date button. Click on Ok. E.g. under Footer, click on the down arrow. Select Page 1 of ?, click on Ok and click on Close button.
Page Setup when a Long Report workbook has been opened, and now let’s use print titles. Choose File, Page Setup. Select the Sheet tab. The Sheet tab enables us to choose which rows should be used as print titles. These rows will be repeated at the top of each page of the printout. In the Rows to repeat at top text box, type $1:$3. To see the print titles, go back into Print Preview mode. In the Page Setup dialog box, click on Print Preview. Press the Page Down key.
Click on Setup. Select the Page tab. Under Scaling, select Fit To. Click on the up arrow to change the settings. These setting will scale the printout to fit the number of pages you prefer. Apply these changes and view the results. Click on Ok. Press the Page Up key. NB: the status bar now reads “Preview. Page 1 of 2”, indicating that our attempt to reduce the number of pages has been successful. However, the break between the two pages now falls in an undesirable location. Click on Page Break Preview. Press the Page Down key.
To override the page breaks that were inserted automaticall by Excel, we can use the Page Break Preview to drag a page break to the correct row, or we can insert page break directly into the worksheet.
Choose View, Normal. Select row e.g 36 choose Insert, page Break. (the new page break will displayed as a dotted line between the rows).
Using a Multiple-Sheet Workbook
A default Excel workbook contains three worksheets, named Sheet1 through Sheet3. A sheet’s name is displayed on the sheet tab. When a sheet is active, its name is displayed in boldface. Click on the tab scroll right button. The tab scroll right button allows us to see the sheet tabs that are hidden behind the scroll bar by scrolling the sheet tabs one to the left. Click on the tab scroll last right button. Click on the tab scroll far left button. We can use these tab scrolling buttons to get access to any of the sheet tabs. Then, we can just click on the tab of the sheet we want to work with. Click on the Sheet 2 tab. Double-click on the tab for Sheet 1 by double-clicking on the tabs for the sheets, we can rename sheet tabs. Also by clicking on sheets while holding down the shift key, we can easily create formulas with 3-D references. In order to sum the values in cell from each worksheet, we need to select the cells for our formula. E.g. select the sheet tab. Select a cell B4. While pressing the Shift key, select another sheet. Press the Enter key. Excel will updated the formula with a reference to cell B4 from each of the first four worksheets, and the result of the sum function is displayed. Select the sheet tab. Choose Edit, Delete Sheet. Click on Ok. Select the other sheet tab. With the sheet deleted, the formula that we created in cell B4 on the other sheet has automatically been recalculated for us. Choose Tools, Options. Select the General tab. The options dialog box will display which allows us to see and change the default settings for Excel. E.g. change the number of sheets to 200 and press the Enter key. Click on Ok. Now, if we create a new workbook, it will contain 200 worksheets rather than 3.
Excel as a Web Tool
You can save all or part of an Excel workbook as a web page. When you save Excel data as a web page, it is saved as an HTML file, which is assigned the extension .htm. You can then post this file to an Internet web site or an intranet site.
To save Excel workbook as a web page.
Choose File, Save as web Page. Click on the Change Title button. Type the file name and click on Ok. Now, when someone opens your web page, this title will be displayed on the title bar of the web browser. Click on the Web Folder icon. Change the filename to and click on Save.
To preview the page in a Web browser. Choose File, Web Page Preview. Now we are looking at the Web page as it will appear to others who view it by using a Web browser. If you place your mouse pointer on any of the sheet tabs on the bottom of the page, the cursor will change to a hand with pointing finger. This indicates that each sheet tab is a hyperlink. Click on sheets tab to view.
NB: the worksheets do not contain grid lines, column headings, or row headings. Also take note that since you save an entire workbook, all sixteen sheets are contained in the web page—even those that contain no data. Choose View, Source. by choosing to view the source of our Web page, we can see all of the HTML tags that Excel generated. These tags format our work book's data to mimic the layout and format as it appears when viewed in Excel. Click on the Close(X) button.
Regards,
BEM T. CELESTINE
Social Plugin