Page 240 - IT_Play_V1.0 Class9
P. 240
UNIT-4 ELECTRONIC SPREADSHEET
3 FORMAT DATA IN THE
SPREADSHEET
Formatting data in a spreadsheet improves its readability and presentation, helping users highlight key
information, organise data effectively, and create clear, professional-looking sheets for better data analysis
and communication
FORMATTING THE SHEET
Cells in a spreadsheet can hold various types of data and can be formatted
using the Formatting toolbar or the Format Cells dialog box. Formatting includes
changing the appearance of cell contents, such as font styles, text alignment,
borders, and patterns.
Use of Dialog Boxes to Format Values
The Format Cells dialog box can be used to find more about formatting a cell or
range of cell. You can open this Format Cells dialog box by pressing the shortcut
key Ctrl+1 or by selecting Cells option from the Format menu.
Changing Font
Changing the font in LibreOffice Calc involves selecting different Font, Size, and Style to alter the appearance
of text in the spreadsheet cells. To change the font in a spreadsheet, follow these steps:
Step 1: Select a cell or a range of cells.
Step 2: Click on the Format menu from the Menu bar.
Step 3: Select the Cells option from the drop-down menu. The Format Cells dialog box appears on the
screen.
Step 4: Click on the Font tab.
Step 5: Select the desired font, font style and font size in the Font, Style and Size drop-down lists, respectively.
2
4
5
3
1
238 Information Technology Play (Ver 1.0)-IX

