Author: user

Create different types of charts from spreadsheet data: column chart, bar chart, line chart, pie chart.

In Calc, we can represent our data with the help of different graphical representations like column chart, bar chart, line chart, or pie chart. This makes the data more presentable and also easier to comprehend.
[the_ad id=”12355″]
[show_slider name=create-spreadsheet-charts]
[the_ad id=”12356″]
To create the different types of charts in Calc, first of all we need to select some data which we are going to represent with the help of charts.

Here we have selected the data as shown in the above figure.

After selecting the data, click on the ‘Insert’ button from the main menu bar and from the resulting drop-down click on ‘Chart’.

This will open the chart wizard. Here you can select one of the different types of charts from ‘Choose a Chart Type’.

After making your selection, just click on ‘Finish’, and this will create your chart.

Select a chart.

A chart can be selected by simple double-clicking on it. When selected, the chart is surrounded by a grey border. The chart shown in the above diagram is in selected state. As can be observed, it is surrounded by a grey border.

Change the chart type.

In order to change the chart type, first of all we need to select the chart by double-clicking on it. The chart will become surrounded by a grey border upon selection. After selecting the chart, click on ‘Format’ button on the main menu bar. From the resulting drop-down, click on ‘Chart Type’.

After clicking on the ‘Chart Type’ button, the ‘Chart Type’ dialog box appears. This lists the different chart types available. Any chart type can be selected from this list. After selection of the required chart type, just click on ‘OK’ and the chart type will get changed and a new chart will be created having the updated chart type.

Move, resize, and delete a chart.

To move or resize a chart, select the chart by double clicking on it. Eight different markers appear on the corners and edges of the chart. Place the mouse pointer on any of these markers and click and drag in order to increase or decrease the size of the chart.

To move the chart, place the mouse pointer anywhere on the grey border other than the eight pointers. Simply click and drag the mouse pointer to the location where you want to place the chart and the chart will be moved to the new location.

To delete a chart, click on the chart only once. Eight green pointers will appear on the boundary of the chart but the grey selection border will not appear. When the green pointers appear, just click on ‘Delete’ button on your keyboard and the chart will get deleted.

[the_ad id=”12397″]
[the_ad id=”13529″]

Apply text wrapping to contents within a cell, cell range.

To apply text wrapping to contents within a cell or a cell range, first select the cell or the cell range and then right click anywhere on the entire range. From the resulting menu, click on ‘Format Cells’, this will open the ‘Format Cells’ dialog box. In this dialog box, under the ‘Alignment’ tab, under ‘Properties’ we have a ‘Wrap text automatically’ checkbox. Check this box and click on ‘OK’. This will apply text wrapping to the contents of the cell or the cell range.
[the_ad id=”12355″]
[show_slider name=spreadsheet-formats-alignment-and-border-effects]
[the_ad id=”12356″]

Align cell contents: horizontally, vertically. Adjust cell content orientation.

To align cell contents horizontally or vertically, or to adjust the cell content orientation, open the ‘Format Cells’ dialog box. In this dialog box, under the ‘Alignment’ tab, under ‘Text Alignment’, we have the ‘Horizontal’ and ‘Vertical’ drop-down lists. The appropriate alignment can be chosen from these lists.

To adjust the cell content orientation, in the same dialog, we have ‘Text Orientation’. The appropriate cell content orientation can be set here. After setting all the values, click on ‘OK’. This will save the alignment and orientation changes for the selected cells.

Merge cells and Centre a title in a merged cell.

To merge cells and Centre align a title in the merged cells, first select all the cells which need to be merged. These cells have to be symmetrically adjacent to each other. After this, click on ‘Format’ from the main menu bar and from the resulting menu, click on ‘Merge Cells’. From the resulting sub-menu, click on ‘Merge and Center Cells’. This will merge all the selected cells and will also Centre align the title in these merged cells.

Add border effects to a cell, cell range: lines, colors.

To add border effects to a cell or a range of cells, select the cell or the cell range and then open the ‘Format Cells’ dialog box. In this dialog box, under the ‘Borders’ tab, we have a section called ‘Line’. In this section, we have ‘Style’ and ‘Color’ drop-down lists. Select the appropriate line styles and color for the border of the cells from these lists. After selecting all the values, click on ‘OK’. This will add the selected border effects to the selected cells.

[the_ad id=”12397″]
[the_ad id=”13529″]

Change cell content appearance: font sizes, font types.

In the same ‘Format Cells’ dialog box, under the ‘Font’ tab, we have the ‘Font’ and ‘Size’ drop-down lists. The ‘Font’ drop-down list gives the different font types and ‘Size’ gives the different font sizes. These values can be chosen accordingly. After selecting the required values, click on ‘OK’. This will change the font size and font type of the content of the cell.
[the_ad id=”12355″]
[show_slider name=change-spreadsheet-cell-content-appearance]
[the_ad id=”12356″]

Apply formatting to cell contents: bold, italic, underline, double underline.

To apply formatting to cell contents, open the ‘Format Cells’ dialog box. In this dialog box, under the ‘Font’ tab, we have a ‘Style’ drop-down list. Different styles such as bold or italic can be chosen from this list.

To make the content have a single or a double underline, in the same dialog box, under the ‘Font Effects’ tab, we have ‘Underlining’ drop-down list. The type of underlining required can be selected from this list. After making all the changes, click on ‘OK’. The formatting styles selected will get applied to the contents of the cell.

Apply different colors to cell content, cell background.

To apply different colors to cell content, open the same ‘Format Cells’ dialog which we have been using till now. Under the ‘Font Effects’ tab, we have a ‘Font Color’ drop-down list. Select the color which is required for your cell content from this list and then click on ‘OK’. This will make the cell content to be displayed in the chosen color.

To apply different colors to cell background, open the same ‘Format Cells’ dialog which we have been using till now. Under the ‘Background’ tab, we have an option for choosing the ‘Background Color’. Select the color which is required for your cell background here and then click on ‘OK’. This will make the cell background to be displayed in the chosen color.

Copy the formatting from a cell, cell range to another cell, cell range.

To copy the formatting from a cell or a cell range to another cell or cell range, select the cells whose format needs to be copied. Now right-click anywhere on the entire cell range, and from the menu which gets displayed, click on ‘Copy’.

Now go to the cell where you need to copy the formatting. Right click on this cell and from the resulting menu, click on ‘Paste Special’. This will open the ‘Paste Special’ dialog box.

From this dialog box, deselect all the options other than the ‘Formats’ check box. After this, click on ‘OK’. This will copy only the formatting of the selected cells to the target cells.

[the_ad id=”12397″]
[the_ad id=”13529″]

Numbers/Dates

Format cells to display numbers to a specific number of decimal places, to display numbers with, without a separator to indicate thousands.

It is possible in Calc to format cells to display any input in some particular styles. To format a cell to display numbers to a specific number of decimal places, right-click on that cell and from the resulting menu, click on ‘Format Cells’.
[the_ad id=”12355″]
[show_slider name=formatting]
[the_ad id=”12356″]
 

This will open the ‘Format Cells’ dialog.

In this dialog, under the ‘Numbers’ tab and in the ‘Number’ category, in ‘Options’ we have ‘Decimal places’, where the number of decimal places up to which a number needs to be displayed can be set. If we set 4 here than any number entered in this cell will get displayed up to four decimal places. If the decimal values are less than 4, then zeroes will get displayed and if the decimal values are more than 4, then the number will get rounded off till 4 decimal places.

In the same dialog we have another option, ‘Thousands separator’ checkbox. If this box is checked, then a separator to indicate thousands will get displayed for every number in the cell, otherwise no separator will get displayed.

Format cells to display a date style, to display a currency symbol.

In the same ‘Format Cells’ dialog which has been mentioned above, under the ‘Numbers’ tab, under ‘Category’, we have ‘Date’. Here we have many date format options under ‘Format’. Any of these formats can be selected to display a date in a particular style.

 

In the same dialog box, under ‘Numbers’ tab, we have a category ‘Currency’. Under ‘Format’ we have many different currency formats which can be chosen as per the requirements. After choosing the required format, click on ‘OK’.

This will display the required currency symbol.

 

Format cells to display numbers as percentages.

To display numbers as percentages, open the same ‘Format cells’ dialog box which we have used in the previous sections. In this dialog box, under the ‘Numbers’ tab, we have ‘Percent’ category; and in this category, under ‘Format’, we have different percentage format options in which a number can be displayed.

Select the appropriate option from here and click on ‘OK’. The number will then be displayed in the selected percentage format.

 

[the_ad id=”12397″]
[the_ad id=”13529″]

Use the logical function if (yielding one of two specific values) with comparison operator: =, >, <.

To use the logical function ‘IF’, we need to follow the same steps as before to reach the ‘Function Wizard’. In the ‘Function Wizard’, select ‘Logical’ in the ‘Category’ and from ‘Function’, select ‘IF’. Click on ‘Next’ and the following dialog is displayed.
[the_ad id=”12355″]
[show_slider name=the-if-function]
[the_ad id=”12356″]

The ‘IF’ function takes three arguments, these are ‘Test’, ‘Then_value’ and ‘Otherwise_value’. ‘Test’ is the condition which needs to be tested for being either true or false. A condition could be anything and can be defined with the help of comparison operators. Here we’ll put a simple condition ‘K8>1000’, this will check whether the number present in the cell K8 is greater than 1000 or not. ‘Then_value’ defines the value which will get printed in the target cell if the condition is satisfied and ‘Otherwise_value’ defines the value which will get displayed if the condition is not satisfied. Here we’ll put the ‘Then_value’ as “Is greater than 100” and ‘Otherwise_value’ as “Is less than 1000”. Anything which is put inside “” in Calc is considered to be text by the tool, this should be kept in mind while making inputs to the tool. After making all the inputs, click on ‘OK’.

Since the value in cell K8 here is 1032, which is greater than 1000, so “Is greater than 1000” gets displayed in the selected cell. This is how ‘IF’ function works.

[the_ad id=”12397″]
[the_ad id=”13529″]

Use sum, average, minimum, maximum, count, counta, round functions.

Functions help us in analyzing and referencing data. To use functions in a worksheet, first of all we need some data on which the functions are to be applied. Any function needs some arguments to be passed to it as parameters, upon which the calculations or other operations are performed.
[the_ad id=”12355″]
[show_slider name=functions]
[the_ad id=”12356″]
Say we need to add the numbers present in some cells. We can use the ‘SUM’ function to perform this task. To use the ‘SUM’ function, first select the cell where you want to put the result of the addition operation. Then click on ‘Insert’ from the main menu bar, from the resulting drop-down, click on ‘Function’. This opens the ‘Function Wizard’. All this has been shown below.

The selected cell is the one where the sum of the cell values which have been highlighted needs to be put in. Then in the ‘Function Wizard’, under ‘Category’, select ‘Mathematical’, and then under ‘Function’, select ‘SUM’. Then click on ‘Next’. The below shown dialog will get displayed.

 

Here, as shown, ‘=SUM ( )’ gets displayed in the ‘Formula’ section. Now we’ll pass arguments to this function. For that we’ll use the ‘Select’ icons, which have been highlighted above. For selecting the first number, click on the ‘Select’ icon in front of ‘number 1’. This will minimize the ‘Function Wizard’ and then the required cell(s) can be selected from the sheet.

As has been shown above, the data range from A2 to A14 has been selected here. After making the selection, again click on the ‘Select’ icon from the minimized ‘Function Wizard’. This will again maximize the wizard and the argument will be shown in the formula.

We can pass thirty arguments to the ‘SUM’ function, and each of these arguments can contain any data range. So this shows that we can add almost any amount of data using this function. After selecting the arguments, simply click on ‘OK’, and the result will be shown in the selected cell.

All kinds of different functions can be used in a similar manner in Calc. The steps will all remain the same. Just the arguments and the functionality of the functions vary.

The ‘AVERAGE’ function returns the mathematical average of the numbers present in the cells which are selected. Exactly same steps need to be followed for the ‘AVERAGE’ function as were followed for the ‘SUM’ function. The only variation is that the ‘Category’ for the ‘AVERAGE’ function would be ‘Statistical’.

To get the minimum and maximum values from any list of arguments, we can use the ‘MIN’ and ‘MAX’ functions from the ‘Statistical’ category respectively.

The ‘COUNT’ function form the ‘Statistical’ category counts how many numbers are present in the argument list. This function only counts how many numbers are present in the argument list, and ignores other types of values like text.

The ‘COUNTA’ function from the ‘Statistical’ category counts how many values are present in the argument list. This function counts the number of all kinds of values present in the argument list, be it numbers or text or any other.

The ‘ROUND’ function from the ‘Mathematical’ category rounds a number to a predefined accuracy. The ‘ROUND’ function takes two arguments, ‘number’ and ‘count’. Here ‘number’ is the number which needs to be rounded and ‘count’ is the number of places to which the number needs to be rounded. Say, if the ‘number’ selected from a cell is 1006.5555 and the ‘count’ given is 2, then the result will be 1006.56. This is how the ‘ROUND’ function works.

Use the logical function if (yielding one of two specific values) with comparison operator: =, >, <.

To use the logical function ‘IF’, we need to follow the same steps as above to reach the ‘Function Wizard’. In the ‘Function Wizard’, select ‘Logical’ in the ‘Category’ and from ‘Function’, select ‘IF’. Click on ‘Next’ and the following dialog is displayed.

The ‘IF’ function takes three arguments, these are ‘Test’, ‘Then_value’ and ‘Otherwise_value’. ‘Test’ is the condition which needs to be tested for being either true or false. A condition could be anything and can be defined with the help of comparison operators. Here we’ll put a simple condition ‘K8>1000’, this will check whether the number present in the cell K8 is greater than 1000 or not. ‘Then_value’ defines the value which will get printed in the target cell if the condition is satisfied and ‘Otherwise_value’ defines the value which will get displayed if the condition is not satisfied. Here we’ll put the ‘Then_value’ as “Is greater than 100” and ‘Otherwise_value’ as “Is less than 1000”. Anything which is put inside “” in Calc is considered to be text by the tool, this should be kept in mind while making inputs to the tool. After making all the inputs, click on ‘OK’.

Since the value in cell K8 here is 1032, which is greater than 1000, so “Is greater than 1000” gets displayed in the selected cell. This is how ‘IF’ function works.

[the_ad id=”12397″]
[the_ad id=”13529″]

Related Lesson

This lesson will teach us about the various database functions available. Specifically, the DSUM function, which adds all of the cells in a data range that matches the search criteria.
Advanced Spreadsheets – Database Functions

Arithmetic Formulas

Recognize good practice in formula creation: refer to cell references rather than type numbers into formulas.

We have been entering either text or numbers into the cells till now, but in case the data in a cell is dependent on the value of data of other cells, we use formulas. Formulas use numbers and variables to get the required values. These variables are the cell references of the cells from where we need to get the data to be used in the formulas.
[the_ad id=”12355″]
[show_slider name=formulas-and-functions]
[the_ad id=”12356″]

Whenever a formula is created in Calc, one thing should always be taken into consideration. We should always try and use cell references in the formulas instead of directly using numbers. This helps in decreasing the efforts in changing the formulas every time a value needs to be changed. If we keep such values directly in a formula, we’ll have to change the formula each time the value is changed. But if we keep such values in a separate cell and use the cell reference in the formula, then we’ll have to simply change the value in one cell and all the formulas will be updated. This saves time and effort.

Create formulas using cell references and arithmetic operators (addition, subtraction, multiplication, division).

There are four types of arithmetic operators; addition, subtraction, division and multiplication. These return numerical results.

Any formula must always begin with an ‘=’ symbol. The formulas can be entered by either using the function wizard or by typing directly into the cell or the input line.

‘=b4+b6’ gives the sum of the values stored in the cells ‘B4’ and ‘B6’. ‘B4’ and ‘B6’ are the cell references here and ‘+’ is the arithmetic operator.

To create this formula, double click on the cell where this formula needs to be entered. Then type in the formula in the cell and press ‘Enter’ from the keyboard.

This will showcase the result of the formula in that cell.

The subtraction, multiplication and division operators can be used in the same way.

Identify and understand standard error values associated with using formulas: #NAME?, #DIV/0!, #REF!.

While using formulas, it is very common to get errors. These can occur due to a variety of reasons, but the important part is to identify these, so that we can correct them. Error messages or values are the simplest tools which help us in identifying these errors. Some of the most common error-values associated with using formulas are given below,

#Name? : This error value is displayed in place of the error code Err:525. This code signifies that no valid reference exists for the argument. This means that if we provide some argument to the function incorrectly, say ‘b’ in place of ‘b6’ or any such mistake, then this error value will get displayed.

#DIV/0! : This error value is displayed in place of the error code Err:532. This signifies division by zero. This means that if we write a formula of the type, ‘=b4/b6’ and b6 here contains 0, then this error value will get displayed as division by zero is not a proper mathematical operation.

#REF! : This error value is displayed in place of the error code Err:524. This signifies that the column, row, or sheet for the referenced cell is missing. This means that if we are referring a sheet in a formula or a function, which has been deleted, then this error value will get displayed.

Understand and use relative, absolute cell referencing in formulas.

Referencing is the way by which we refer to the location of any cell in Calc. There are two types of references, absolute and relative.

In relative referencing, when we use a formula to refer to two or more cells, and then when we copy this formula to a new location, then the new formula does not refer to the same cells. It refers to new cells which have the same relative position to the formula as was the case with the original referencing.

To understand in a better way, let us take an example. As shown below, we have put the formula ‘=b4+b6’ in the cell ‘b9’. Thus the answer of this calculation, 11, is being displayed in this cell. When we copy the formula and paste it in ‘c9’, then the result will be 10 and not 11. This is because, the formula copied will have new references ‘c4’ and ‘c6’ as these have the same relative locations to ‘c9’, as was the case with ‘b4’, ‘b6’ and ‘b9’. Thus the sum of the values stored in ‘c6’ and ‘c9’ will get displayed, which is 10. This is how relative referencing works.

In absolute referencing, the references do not change with the formula and the same reference is copied when the formula is copied to another cell. This is achieved by writing the formula as, ‘=b4+$b$6’. This will change the ‘b4’ reference when the formula is copied, but the ‘b6’ reference will remain as it is. This has been shown in the diagram given below.

[the_ad id=”12397″]
[the_ad id=”13529″]

Switch between worksheets.

To switch between different open worksheets, we just need to click on the appropriate sheet name from the bottom of the Calc window, as has been shown in the below given illustration.
[the_ad id=”12355″]
[show_slider name=worksheets]
[the_ad id=”12356″]

When we click on a particular sheet name, that sheet will get opened. This is how we can switch between different open worksheets.

Insert a new worksheet, delete a worksheet.

To insert a new worksheet in Calc, you can simply click on the ‘Add Sheet’ button. This button has been shown in the diagram below. This button simply creates a new sheet with the default name. After the creation of the sheet with the default name, double click on the sheet name to open the ‘Rename Sheet’ dialog. Enter the new name for the sheet in this dialog and click on ‘OK’. The name of the sheet will get updated.

Another method to insert a new worksheet is by double-clicking on the white area in front of the ‘Add Sheet’ button, as has been shown in the diagram. Double-clicking here will open the ‘Insert Sheet’ dialog.

Enter the name for the sheet here, and change the other options as per the requirements and click on ‘OK’. This will create a new worksheet.

To delete a worksheet, simply right-click on the sheet name and click on the ‘Delete Sheet’ button from the resulting menu.

Recognize good practice in naming worksheets: use meaningful worksheet names rather than accept default names.

Whenever new worksheets are created, then Calc provides default names for these worksheets. These names are generic in nature and provide no information about the type of sheet or the type of data contained in that sheet.

So rather than accepting these default names, we should use meaningful names for our spreadsheets which convey some information about the type or nature of the data contained in the spreadsheets.

Copy, move, and rename a worksheet within a spreadsheet.

To move a sheet to a different position within the same spread sheet, click on the sheet tab and drag it to its new position before releasing the mouse button.

To copy a sheet within the same spread sheet, hold down the ‘Ctrl’ key and then click on the sheet tab and drag it to its new position before releasing the mouse button. This will create a copy of the existing worksheet in the new position.

To rename a spreadsheet, double click on the sheet name to open the ‘Rename Sheet’ dialog. Enter the new name for the sheet in this dialog and click on ‘OK’. The name of the sheet will get updated.

[the_ad id=”12397″]
[the_ad id=”13529″]

Rows and Columns

Select a row, range of adjacent rows, and range of non-adjacent rows.

To select a row, simply click on the row header for that row. It should just be a single click and not a double click. This will select the entire row.

To select a range of adjacent rows, click on the row header for the first row in that range and without releasing the mouse button, drag the cursor to the last row header in the range. This will select the entire range of adjacent rows.
[the_ad id=”12355″]

[show_slider name=managing-worksheets]
[the_ad id=”12356″]
To select a range of non-adjacent rows, click on one of the row headers from any of the rows and then press the ‘ctrl’ key on the keyboard. Without releasing the ‘ctrl’ key, select each of the non-adjacent row headers individually. But the ‘ctrl’ key should not be released throughout. This is how we can select a range of non-adjacent rows.

Select a column, range of adjacent columns, and range of non-adjacent columns.

To select a column, simply click on the column header for that column. It should just be a single click and not a double click. This will select the entire column.

To select a range of adjacent columns, click on the column header for the first column in that range and without releasing the mouse button, drag the cursor to the last column header in the range. This will select the entire range of adjacent columns.

To select a range of non-adjacent columns, click on one of the column headers from any of the columns and then press the ‘ctrl’ key on the keyboard. Without releasing the ‘ctrl’ key, select each of the non-adjacent column headers individually. But the ‘ctrl’ key should not be released throughout. This is how we can select a range of non-adjacent columns.

Insert, delete rows and columns.

To insert a row or a column, right-click on the column header to the left of which you want to insert a new column or right-click on the row header above which you want to insert a new row. From the resulting menu, in the case of column, click on ‘Insert Columns Left’, and in the case of rows, click on ‘Insert Rows Above’. This will insert a new row or a new column to the worksheet.

To delete a row or a column, simply right-click on the row or column header which needs to be deleted, or select multiple columns or rows and then right click on any one of the headers from the entire range. From the resulting menu, click on ‘Delete Selected Columns’ or ‘Delete Selected Rows’. The selected rows or columns will get deleted.

Modify column widths, row heights to a specified value, to optimal width or height.

To modify column widths or row heights, right click on the column header and then click on ‘Column Width’ from the resulting menu or right click on the row header and then on ‘Row Height’ from the resulting menu respectively. This will open the ‘Column Width’ or ‘Row Height’ dialog box where the width or height of the column or the row can be set. After giving the appropriate value, click on ‘OK’. This will change the height or width of the row or column accordingly.

To modify the column width or row height to optimal values, right click on the column or row header and from the resulting menu, click on ‘Optimal Column Width’ or ‘Optimal Row Height’. This will open the ‘Optimal Column Width’ or ‘Optimal Row Height’ dialogs. Click on ‘OK’ and the width or the height will get modified to the default values.

Freeze, unfreeze row and/or column titles.

Freezing locks a number of rows at the top of a spreadsheet or a number of columns on the left of a spreadsheet or both rows and columns. Then, when moving around within a sheet, the cells in frozen rows and columns always remain in view.

To freeze a row or a column, click on the row header below the rows you want the freeze or click on the column header to the right of the columns where you want the freeze. After this, click on ‘Window’ from the main menu bar. From the resulting drop-down, click on ‘Freeze’. This will freeze the rows and columns as per your selections.

To unfreeze these rows and columns, click on ‘Freeze’ again from the ‘Window’ drop down menu from the main menu bar.

[the_ad id=”12397″]
[the_ad id=”13529″]

Copy the content of a cell, cell range within a worksheet, between worksheets, between open spreadsheets.

To copy the content of a cell or a range of cells within a worksheet, between worksheets or even to another open spreadsheet, simply select the cell or the range of cells. Then right click anywhere on the selected portion and from the resulting menu, click on ‘Copy’.
[the_ad id=”12355″]
[show_slider name=copy-move-delete-cell-content]
[the_ad id=”12356″]
After this go to the cell location where you want to copy the selected cell or cell range. This location can be in the same worksheet, or in some other worksheet of the same spreadsheet or also in some other open spreadsheet. Right click on this cell and from the resulting menu click on ‘Paste’. This will copy the content from one location to another.

Use the auto fill tool/copy handle tool to copy, increment data entries.

You can use the ‘Fill’ tool in Calc to duplicate existing content or to create a series in a range of cells in your spreadsheet.

To use the ‘Fill’ tool to copy data, click on the cell from which you want to copy the data and then without releasing the mouse button select the cells where the data needs to be copied by dragging the mouse to any direction.

After this, click on ‘Edit’ from the main menu bar. From the resulting drop down, click on ‘Fill’. From the sub-menu, click on ‘Down’, ‘Up’, ‘Left’ or ‘Right’ as per the cells which have been selected. This will copy the data of the selected cell to the rest of the cells.

To make incremental data entries, select the cell from where you want to start the series and then without releasing the mouse button select the cells where the series needs to be created. After this, click on ‘Edit’ from the main menu bar. From the resulting drop-down, click on ‘Fill’, and from the sub-menu click on ‘Series’. This will open the ‘Fill Series’ dialog box.

Make the entries of the ‘Start Value’ and the ‘Increment’ here and also select the ‘Series Type’ and ‘Direction’. After selecting everything, click on ‘OK’. The series will get created in the selected cells.

Move the content of a cell, cell range within a worksheet, between worksheets, between open spreadsheets.

To move the content of a cell or a range of cells within a worksheet, between worksheets or even to another open spreadsheet, simply select the cell or the range of cells. Then right click anywhere on the selected portion and from the resulting menu, click on ‘Cut’.

After this go to the cell location where you want to copy the selected cell or cell range. This location can be in the same worksheet, or in some other worksheet of the same spreadsheet or also in some other open spreadsheet. Right click on this cell and from the resulting menu click on ‘Paste’. This will move the content from one location to another.

Delete cell contents.

To delete the contents of a cell, right click on the cell and from the resulting menu, click on ‘Delete Contents’.

This will open the ‘Delete Contents’ dialog box. Select the appropriate options here and click on ‘OK’. This will delete the contents of the cell.

[the_ad id=”12397″]
[the_ad id=”13529″]