Page 40 - 2501_KVS_C-6

3 LIBREOFFICE CALC

Your Aim

3.1 Format Menu 3.2.10 Delete Sheet
3.1.1 Cells 3.2.11 Clear Cells
3.1.2 Rows 3.2.12 Rename Sheet
3.1.3 Columns 3.2.13 Hide Sheet/Show Sheet
3.1.4 Merge Cells 3.2.14 Move or Copy Sheet
3.2 Sheet Menu 3.3 Data Menu
3.2.1 Insert Cells 3.3.1 Sort
3.2.2 Insert Rows 3.3.2 Autofilter
3.2.3 Insert Columns
3.2.4 Delete Cells
3.2.5 Delete Rows
3.2.6 Delete Columns
3.2.7 Insert Sheet
3.2.8 Insert Sheet at End
3.2.9 Insert Sheet from File

Aryan: Remember Gowri, we made a table of foods liked by our classmates.
Gowri: I do remember Aryan and we used options from View, insert and Format menu for
various tasks.
Aryan: Yes Gowri, But what if I forgot to enter a name. Can I add a name in the middle of the
table?
Gowri: Yes, you can add row and column in a table anywhere. You can also increase or decrease
row/column width. We have different menus for that. Let me explain them to you.

3.1 FORMAT MENU

The Format Menu is the fifth menu located on Menu Bar. It has various submenus associated
with it. It has options to format cells, rows and columns.

3.1.1 Cells
We can format cells using the following option:

1. Select the Cell
2. Right-click on the selected cell and click on Format Cells.

or

3. Click on the Format à Cells

38 KVS DELHI REGION 2025