Format Cells In LibreOffice Calc

2860 views

LibreOffice Calc allows you to format cells in any type without changing its value. You can change a value “0.5” to “50%” or “$0.5”, or change the appearance of the cell itself.

Format Cells in Calc

Type any number in any cell of Calc.

By default, Calc uses default number format when you type a number in a cell. To format the number, right-click on the cell and select “Format Cells”.

Format Cell Option in Context Menu
Format Cells - Main

On the Format Cells dialog, choose the category as Currency, Format as USD $ (Or anything you want), select desired formatting in the format list. You can also choose a number of decimal places, leading zeros you want. Once you are satisfied by looking at the preview, press OK.

To change the above number to %, you can click the % icon in the toolbar after selecting the cell. Calc provides common number formats in the toolbar itself for easy access.

Percent in Toolbar

Use Borders, border style, Font Color and alignment from the toolbar to give the cell a different look:

order Styles in Toolbar
Borders in Toolbar
Color Palette in Toolbar

Once it is applied to the cell, it would look like this:

Next Chapter   Find and Replace


Looking for something else?

Read our complete tutorial index of Calc, Writer, Impress and Draw.


Join our Telegram channel and stay informed on the move.

Related


arindam

Creator of libreofficehelp.com. The aim is to help as many people with easy-to-understand tutorials and no BS. Follow us using social channels or send us an email.

Subscribe
Notify of
guest

This site uses Akismet to reduce spam. Learn how your comment data is processed.

0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x