11 Calc Archives - libreofficehelp.com


Count Cells with Strings, Numbers Using COUNTIF Function – Calc

June 20, 2018

This tutorial would explain various ways of COUNTIF function in LibreOffice Calc which can be used to count strings, numbers from a cell, range, rows, columns etc.

Read More

Data Validation Using Double Dependent Dropdown List – LibreOffice Calc

May 29, 2018

This tutorial would explain how to create dependent dropdown list in LibreOffice Calc.

Read More
Data Validation - List

Data Validation Using DropDown List – LibreOffice Calc

May 27, 2018

This tutorial would show how to use a basic range based data validation in LibreOffice Calc using a drop down list.

Read More
Sample Data for Empty Rows

How to Delete Empty Rows in LibreOffice Calc Sheet

May 19, 2018

This tutorial will explain how to delete blank rows from LibreOffice Calc sheet.

Read More
Where to enter the custom format

Custom Number Format Basics – LibreOffice Calc

March 29, 2018

This tutorial will explain the basics of custom number format in LibreOffice Calc. Calc provides different types of number formats which is explained in earlier tutorialsĀ  e.g. Decimal, Numbers, Date and Time etc. All the formats that comes as default caters to basic needs. But if you want to format your numbers as per your […]

Read More
Convert Text to Numbers

Convert Text to Number in LibreOffice Calc

March 26, 2018

This tutorial would explain on how to convert a list of “text which represents numbers” to numbers.

Read More
Formatting Cells - Fractions with multiple denom

How to Enter, Display Fractions in LibreOffice Calc

March 25, 2018

This tutorial explains how to enter, display, manipulate, format various fractions in Calc.

Read More
Format Cells-DD-MM-YY

Date and Time Formats in LibreOffice Calc

March 3, 2018

Date and Time formats and how they are represented in LibreOffice Calc is explained in this tutorial.

Read More
Toolbar - Decimal Places - Minus

Decimal Places in LibreOffice Calc

February 18, 2018

This tutorial would explain how to show fewer decimal places in a Calc Cell. Show Few Decimal Places Any decimal number that contains multiple digits after the point can be entered in a Cell. However if the digits are huge, it is often wise to show only fewer digits for better visibility and understanding. For […]

Read More
Translate Ā»