Page Breaks, Page Setup, Print Preview, Workbook Protection

Get unlimited access to the best preparation resource for ICSE/Class-10 Hindi: fully solved questions with step-by-step explanation- practice your way to success.

Download PDF of This Page (Size: 177K)

Page Breaks

  • To set page breaks within the worksheet, select the row you want to appear just below the page break by clicking the row’s label.

  • Then choose Page Layout Setup Group vBreaks Input Page Break.

  • Excel will start a new page from the row selected.

Page Setup

Select File Page Setup from the menu bar to format the page, set margins, and add headers and footers.

  • Page: The page option allows you to set the paper size, orientation of the data, scaling of the area, print quality, etc. Select the Orientation under the Page tab in the Page Setup window to make the page Landscape or Portrait. The size of the worksheet on the page can also be formatted using Scaling. To force a worksheet to print only one page wide so that all the columns appear on the same page, select Fit to 1 page(s) wide.

  • Margins: Change the top, bottom, left, and right margins by selecting Margins from the page setup group of age Layout Tab. Enter values in the header and footer fields to indicate how far from the edge of the page this text should appear. Check the boxes for centering horizontally or vertically on the page.

  • There are three predefined margin settings. You can choose from them or you can also customize the margins.

  • Add or change the header or footer text: For worksheets, you can work with headers and footers in Page Layout view. For other sheet types, such as chart sheets or for embedded charts, you can work with headers and footers in the Page Setup dialog box.

Add or change the header or footer text for a worksheet in Page Layout view

  • Click the worksheet to which you want to add headers or footers, or that contains headers or footers that you want to change.

  • On the Insert tab, in the Text group, click Header & Footer.

  • Do one of the following:

    • To add a header or footer, click the left, center, or right header or footer text box at the top or at the bottom of the worksheet page.

    • 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 you want to change.

  • Type the text that you want.

  • To close the headers or footers, click anywhere in the worksheet, or press ESC.

  • Sheet tab has the option to select the area to be printed (that is, range of cells). Check Gridlines if you want the gridlines dividing the cells to be printed on the page. If the worksheet is several pages long and only the first page includes titles for the columns, select Rows to repeat at top to choose a title row that will be printed at the top of each page.

Print Preview

Print Preview

Print Preview

  • Print preview helps to view the worksheet before the final printout is taken. It helps to edit the worksheet if required as per the need.

  • The steps to see the print view of document

    • Select Print from Office Button

    • Select print

    • Click Print Preview.

  • Click the buttons like Next and Previous with respect to Print Preview Tab. Select the Zoom button to view the pages closer. Make page layout modifications needed by clicking the Page Setup button. Click Close to return to the worksheet or Print to continue printing.


To print the worksheet, select Print from Office Button.

  • Print Range - Select either all pages or a range of pages to print.

  • Print What - Select selection of cells highlighted on the worksheet, the active worksheet, or all the worksheets in the entire workbook.

  • Copies - Choose the number of copies that should be printed. Check the Collate box if the pages should remain in order.

  • Click OK to print.

File Open, Save and Close

(A) You can open an existing File by several methods

  • Go to windows explorer and find out the file you want to open. Double-click on the file.

  • Start MS Excel. Click on office button on the drop- down menu click ‘open’. Select the file you want to open from the pop-up menu.

(B) When you have finished your work on the file you can save it by either clicking on the ‘file save’ icon at the top left corner or Click on office button click on save at the drop- down menu.

(C) When you are saving the worksheet for the first time follow the steps given below:

  • Click office button

  • Select ‘file save as ‘on the drop-down menu.

  • On the pop-up menu select the location where you want to save the file.

  • Type the file name

  • Click on ‘save ‘in the pop-up menu.

(D) When your work is finished, and it has been saved properly: Select Print from Office Button

  • Select (Click) Close Command to close your file

  • Select (Click) Exit Excel Command to exit from MS Excel

Workbook Protection

Set a Password for a Workbook

  • Click the Microsoft Office Button, and then click Save As.

  • Click Tools, and then click General Options.

  • Do one or both of the following:

    • If you want reviewers to enter a password before they can view the workbook, type a password in the Password to open box.

    • If you want reviewers to enter a password before they can save changes to the workbook, type a password in the Password to modify box.

  • If you don’t want content reviewers to accidentally modify the file, select the Read-only recommended check box. When opening the file, reviewers will be asked whether or not they want to open the file as read-only.

  • Click OK.

  • When prompted, retype your passwords to confirm them, and then click OK.

  • Click Save.

  • If prompted, click yes to replace the existing workbook.

Developed by: