

Insert images in a range of file formats.Comprehensive drawing and image functions: Draw and design directly in your document with Excel-compatible AutoShapes.Headers and footers (split into left, center and right sections).Conditional formatting like in Microsoft Excel 2019.Cell styles like in Microsoft Excel 2019.Database functions for totals, averages, variance etc.Create database ranges within worksheets.With pivot tables you can display data in a targeted way according to your individual specifications, summarize them, sort them into categories, compare and evaluate them.Sheet, workbook and document protection with encryption.Select and format multiple worksheets simultaneously.External references (calculations that access data in other files).AutoFill: intelligent filling of cell areas with values and rows of values.Perpetual time format (20:00 + 5:00 is not 1:00 but 25:00) which also allows negative times.Numbers can be formatted as currency units, with fixed decimal places and thousands separators, as percentages or fractions, as dates and times etc.Calculation with complex numbers and array functions.

Worksheets with 1 million rows and 16,384 columns.Document preview straight from the file dialog.Print 2, 4, 8 or 16 pages on one sheet of paper (only in Windows).Scale the printout so that it fits on a specified number of pages (five different scaling methods).
#Excel for mac 2018 filter print pdf#
Create PDF files directly in FreeOffice PlanMaker.

