Editing Content :: Admin Scraper

Chapter

Content type

Position

Value

Spreadsheet ▪ To change a header or footer, click the header or footer text box at the top or at the bottom of the worksheet page that contains header or footer text, and then select the text that we want to change. Figure 2.53(b) 3. Type the text that we want. • Use Format Painter To copy quickly formatting from one cell or group of cells to another part of the spreadsheet uses the format painter. This feature is very useful when extending a spreadsheet and we need to format the newly added cells to match the original ones. • Use of AutoFormat Option To quickly apply a number of formatting features to a spreadsheet we can use one of the 17 AutoFormat styles available (in Excel 2007). These styles combine a number of formatting options that will instantly give our spreadsheet a professional look. 2.4 OUTPUT REPORTS We can print entire or partial worksheets and workbooks, one at a time, or several at once. The MS Excel can print just the Excel table or also it provides to: (a) Print a partial or entire worksheet or workbook. (b) Print several worksheets at once. (c) Print several workbooks at once. (d) Print an Excel table. (e) Print a workbook to a file. (f) Print a graphic Charts and Pivot Tables. We can also print a workbook to a file instead of to a printer. This is useful when we need to print the workbook on a different type of printer from the one to another printer. The printing option is available to print Figure 2.54 quickly or to preview the printout before printing, click Microsoft Office Button, click the arrow next to Print, and then click Quick Print or Print Preview (Figure 2.54). To print worksheet or table; basic preparation for printing is required and describe below: 2.4.1 D EFINING THE PRINT A REA By default, Excel prints all data on the current worksheet but for specific and formatted print we have to define print area from the Page Setup dialog box or the Print Area command from the Page Layout 67 option of the Ribbon (Figure 2.55). Reprint 2026-27