CREATING A NEW WORKBOOK

Steps to create a new workbook are as follows:

Step 1 Click at Microsoft Office button.

Step 2 Select New. The New Workbook dialog box opens and Blank Workbook is highlighted by default.

Step 3 Click Create. 

Opening an Existing Workbook

Steps to open an existing workbook are as follows:

Step 1 Click at Microsoft Office button.

Step 2 Select Open. The open dialog box appears.

Step 3 Choose the location and select the file which you want to open.

Step 4 Click Open button.

Addressing of Cells

A cell address or cell reference identifies the location of a cell or group of cells in the worksheet. It consists of the column letter row number that intersect at the cellss location. e.g. Al where A is the column letter and 1 is row number.

We can also refer to a group or range of cells for addressing. Ranges are identified by the cell references of the cells in the upper left and lower right corners of the range. The two cell references used for a range are separated by a colon (:) which tells Excel to include all the cells. between starting and ending points. e.g. A5 : B10 

There are three types of addressing as follows:

1. Relative cell addressing Relative means that the reference of area will be adjusted automatically when you copy the formulas. We can say the cell addressing that change when the formula is auto filled into different cell is known as relative cell addressing. e.g. A5 * B4 will automatically change when it copy into another cell. 

2. Absolute cell addressing If you dont want to change the certain part of your cell address when you copy the formula into a new cell, you need to placed dollar sign ($) before each letter and number in an absolute address e.g. in $A$5 * B4, $A$5 address will not changed when it copy into another cell. 

3. Mixed cell addressing It is a combination of absolute and relative cell addressing. e.g. in $A5 * B$4, only relative part will change when it copy into another cell. 

Printing of Spreadsheet

When you are ready to print your workbook, you can change the workbook’s properties to ensure that your worksheet display all your information properly. 

Page Setup in Spreadsheet

We can setup the page according to your need from the Page Setup dialog box. To open the Page Setup dialog box:

Click Page Layout tab → Page Setup dialog box (↓) 

There are four tabs in page setup dialog box which is used to make different changes in page setup.

Tabs and the groups are as follows:

TabGroups
PageOrientation, Scaling, Paper size, Print quality, etc.
MarginsSet margins from left, right, bottom, top and set header or footer margins, etc.
Header/FooterHeader or footer settings etc.
SheetPrint area, Print titles, Print, Page order.

Setting Print Area

On the worksheet, select the cells that you want to define as the print area. To set the print area:

Click Page Layout tab → Print Area in Page Setup group → Set Print Area 

To Clear the print area:

Click anywhere on the worksheet for which you want to clear the print area.

or

Click Page Layout tab → Print Area in Page Setup group → Clear Print Area.

Print the Print Area

To print the print area of a spreadsheet following steps are as follows:

Step 1 Click at Microsoft Office button.

Step 2 Select Print.

or

Press Ctrl + P After doing this Print dialog box will appear. 

Saving Workbook

Steps to save the workbook are as follows:

Step 1 Click at Microsoft Office button.

Step 2 Do one of the following:

• Choose Save As if you would like to save the file for the first time or save the file as a different name.

• Choose Save if the file has already been named.

Step 3 Select Excel workbook. Save As dialog box will appear.

Step 4 Type the file name in File name box and choose Excel Workbook from the Save As type list box. 

Step 5 Click at Save button.

• You can press Ctrl+S to save the spreadsheet. The default extension of Excel Workbook is .xlsx.

Leave a comment

Your email address will not be published. Required fields are marked *