Choose the Page size, Orientation and Page Margin Before printing the worksheet, it is necessary to verify the Print Preview , in order to check the required format. For print preview, go to File -> Page Preview If the worksheet appears in the required format, press close preview, otherwise choose Format →Page Tab in the top of the screen. . .
Inserting Header and Footer Header and Footer are some titles (such as Document Title, Author Name) or references (such as page no, number of pages, date) or remarks to be printed in the top (called as Header) and bottom of the page (called as Footer). The header and footer dialoge boxes are shown in Figure . and . .
Figure . Header Dialogue Box Figure . Footer Dialogue Box . .
Repeating Rows / Columns in all pages If a sheet is printed on multiple pages, you can set up certain rows or columns to repeat on each printed page. For example, if the top two rows of the sheet as well as column A need to be printed on all pages, do the following steps: Step : Choose Format → Print Ranges → Edit. Figure . Printing Repeatative Rows/Columns Step : On the Edit Print Ranges dialog box, type the rows in the text entry box under Rows to repeat.
For example, to repeat rows and , type $ :$ . This automatically changes Rows to repeat from “- none –“ to “- user defined –“. Points to Remember: Data Tools are used to manipulate the information in the spread-sheet Conditional format gives different font size, font colour and background colour for different data based on the user requirements. Sorting is used to re-arrange the items in ascending or descending order based on alphabets or based on values.
Filters are used to show only the selected portion of data from a large size database Input Help is used to provide various options like week, month etc Header and Footer are some titles (such as Document Title, Author Name) or references (such as page no, number of pages, date)