Help Documentation

Spreadsheet Basics

Formula

A formula always starts with an equal sign (=). It can contain constants, cell references, functions, and operators. Few examples of formula are listed below,

=5*7 A simple formula that multiplies 2 constants (5 and 7) using the operator (*).

=A5-B7 A formula that subtracts the value in B7 from the value in A5.

=SUM(B2:B8) A formula that uses SUM function to calculate the sum of values from B2 to B8.

To write a formula in your spreadsheet

  1. Select the cell and start typing the formula.
  2. Alternatively, you can also click on the formula bar or use the shortcut key F2 and start typing the formula.

Note:

Sorting Data

To sort data in a range of cells

Select the range and use one of the methods given below.

  1. Use quick sort button You will find this under Data tab on the main tool bar. (or)
  2. Right click on the range of cells and select Sort > Sort Ascending/Sort Descending option from the contextual menu.

When you sort data in more than one column, sorting will always be done on the left most columns in the selection and all the values in other columns in the selection will be re-arranged accordingly.

In certain cases, you may want to specify the column to be sorted among the selected columns. In certain other cases, if there are any duplicate entries in the column taken for sorting, you may want to sort the values further by specifying more columns. And in some cases, you may want to sort based on the row values. In such cases, right click on the selected cell range or column headers and select Custom Sort under the Sort option in the contextual menu. Click here, to know more about Custom Sort.

Freezing Rows and Columns

To freeze a row:

Click on the row header below the row up to which you want to freeze. For example, if you want to freeze the first 2 rows, select the row header of the 3rd row. Then select the Freeze Panes option from the contextual menu (or) click the More menu on the toolbar and select the Freeze Panes option.

Similarly, to freeze a column, click on the column header to the right of the column up to which you want to freeze. For example, if you want to freeze the first 3 columns, select the column header of the 4th column. Then select the Freeze Panes option as mentioned above.

To freeze both the rows and columns at the same time, select the cell that is just below the row and to the right of the column up to which you want to freeze. For example, if you want to freeze the first 2 rows and 2 columns, select C3.

Note: Freeze Top Row and Freeze First Column options enable you to freeze the top row or the first column quickly irrespective of the current active cell.

For more details, click here.

Create Hyperlink

To create hyperlink

Select the range and use one of the methods given below.

  1. Right click on a cell and click the Hyperlink menu item or use the shortcut Ctrl+K.  
  2. Use the HYPERLINK() formula.

For more details, click here.

Top