Information technology IT code 402 CBSE- 10.

UNIT – 4


Autosum - Autosum is used for adding the values given in cells automatically without writing the
formula to perform the operation.
Steps to perform Autosum:

1. Select the cell in which you want sum.
2. Click on Home Tab, then click the Autosum option in the Editing group.
3. The values in the cell will be calculated automatically.

Note: Autosum automatically selects the values around the cells either horizontally or vertically.

Conditional Formatting - Conditional formatting allows you to change the formatting (font color,
border, shading) of the cells based on the values in it. So, you specify a condition for the values in the
cell, and if the condition is satisfied then automatically the formatting of the cell changes.

You can control the following formats:
 Number format
 Font, font style, and font colour (but not font size)
 Fill colour and fill pattern
 Border colour and border style (but not border thickness)
Steps to perform Conditional Formatting:
1. Select all the cells you want to format conditionally.
2. Click on Conditional Formatting option available under Styles group in the Home tab. A drop
down list appears.
3. Select the desired formatting option, then specify the required values.
4. Click OK

Freeze Rows and Columns - When you are dealing with a huge amount of data that spans several
rows or columns, you may want the headers to remain constant (frozen) while you scroll through the
data so that you can see the identifying names of the rows/columns is called Freezing of rows and

Steps for Freezing Rows and Columns
1. Click on Freeze Panes option available under Window group in View tab.
2. A drop down list appears as shown below.
3. Click on Freeze Panes.
Note: The panes are formed where your cursor is placed. You can also freeze the entire row or
column by selecting the entire row or column and click “Freeze Panes” to freeze the entire row or

Hide / Unhide Rows and Columns - Sometimes you have data in rows and columns which are
needed for formulas or charts, but you do not want the data to be visible. So, you can Hide / Unhide
that rows and columns. The data in hidden row/column is available for calculations though not visible.

Steps to Hide a row / column:-
1. Either select the particular row/column or just one cell in the corresponding row/column.
2. Click on Format option available under Cells group in the Home tab.
3. A dropdown list appears. Click on Hide & Unhide > Hide Rows.
Select the row/column, right click and select Hide.
Steps to Unhide a row / column:-
1. Select any cells before and after the cell that is hidden.
2. Click Unhide Rows in the Format option available under Home tab.


To print a worksheet with the exact number of pages that you want, you can adjust the page breaks in
the worksheet before printing it. This feature is very useful especially when printing huge sheets.

Steps To Set Page Break
1. On the View tab, in the Workbook Views group, click Page Break Preview.
2. To insert a vertical page break, select the row below where you want to insert the page break.
To insert a horizontal page break, select the column to the right of where you want to insert the
page break.
3. Click on Breaks down arrow under Page Setup group in the Page Layout tab.
4. Click on Insert Page Break option.
5. To move a page break, simply drag the page break to the desired location.

Steps to Remove Page Break
Click the Remove Page Break option in Breaks drop down list.
Note: To return to Normal view after you finish working with the page breaks, click Normal
in the Workbook Views group under the View tab.


Spread sheet software provides various page layout options for organizing pages using the Page
Layout option.
Steps to set the page layout options
Click on Page Layout option under Workbook Views group on View tab. We can set
◦ Margins
◦ Orientation
◦ Page headers and footers
◦ Hide or display grid lines
◦ Size of the page
◦ Define the print area
◦ Specify the background

Click on Margins option under Page Setup group, a dropdown list appears.
You can either select anyone of the predefined margin options available or else you can define your
own margin settings by clicking Custom Margins option and set the margin values manually from the
options available under the dialog box.
You can set the orientation of the page to either Portrait or Landscape by clicking the Orientation
option under Page Setup group in the Page Layout tab.

You can set the size of the page by clicking the Size option under Page Setup group in the Page

Layout tab.
Click on Set Print Area to set the selected to get printed. You can also clear the print area by clicking
the Clear Print Area option.

FOR DOWNLOAD:) Click here
Previous Post Next Post