Manipulation of Cells & Spreadsheet in Calc


In LibreOffice Calc, you can manipulate cell values by using following two modes. 

Manipulation of cells means:

Manipulation of  spreadsheet means :

Modify or editing cell contents

Selecting spreadsheet , inserting spreadsheets

Formatting cell contents

Deleting spreadsheet, moving spreadsheet

Cut, Copy, paste and paste special cell contents

Renaming spreadsheet, Copying spreadsheets

Wrapping text and merging cells

Zoom your spreadsheet, Split your spreadsheet

Changing cell height and width

Freeze panes, group spreadsheet

Inserting ,deleting, moving, and hiding cells

View multiple spreadsheet

Sorting and filtering Freezing panes etc.

Get spreadsheet name

 

Spell check in spreadsheet


Editing Spreadsheet data

Modifying \ Editing Cell content

You can edit the data in the sheet given in the cell. You have several option to edit data in the sheet like selecting the data, changing font face, font size, font color and its style, Formatting styles of cell, formatting spreadsheet and soon.

Selecting cells

In Calc spreadsheet, we type a data in the cell, here we have number of options to an operation upon like we can select, cut or copy the value to paste it somewhere we want. We can replace the data entered in the cell by selecting it and Typing again. We can edit the data entered by double clicking it and update it according to the need. We can even the operation on a range of cell values by selecting it for e.g. we can select the range of cell values to make any king of arithmetical operations like addition, subtraction, or average values of the range and so on.

Post a Comment

0 Comments