About Spreadsheet

Spreadsheet

A spreadsheet application for »SynthelicZ«

Insert Function

Search:

Category:

Input

Conditional Formatting

Rule:

Value:

Color:

Cell Styles

New Cell Style

Style name:

Font:

Size:

Bold Italic

Text color:

Background:

Border:

Format as Table

Select a table style:

Paste Special

Paste:

All
Values Only
Formulas Only
Formats Only

Custom Sort

Column:

Order:

My data has headers

Format Cells

Number Alignment Font Border Fill Protection

Sample: 1234.5

Category:

Decimals:

Horizontal:

Vertical:

Wrap text

Rotation:

Font:

Size:

Color:

Bold Italic Underline Strikethrough

AaBbCcYyZz 123

Style:

Color:

Apply to:

Background:

Protection settings only take effect when the sheet is protected (Review > Protect Sheet).

Locked — prevents editing when sheet protection is on Hidden — hides formula in formula bar when sheet protection is on

Chart

Labels

Title:

X-Axis:

Y-Axis:

Chart Options

Trendline Enable
Type: Degree:

Data Labels Show Value
Show Percentage
Show Category

Name Manager

Name	Refers To	Scope	Used By

Name:

Refers to:

Data Validation

Allow:

Allow blank

Error title:

Error message:

Create Pivot Table

Source Range:

Destination:

Available Fields:

Row Fields:

Column Fields:

Value Fields:

Goal Seek

Set cell:

To value:

By changing cell:

Unprotect Sheet

Password:

Set Print Area

Range:

Manage Conditional Formatting Rules

Text to Columns

Choose how to split your data:

Delimited
Fixed Width

Remove Duplicates

My data has headers

Sort

My data has headers Case sensitive

Advanced Filter

Action: Filter in place Copy to another location

List range:

Criteria range:

Unique records only

Subtotals

At each change in:

Use function:

Add subtotal to:

Replace current subtotals
Page break between groups
Summary below data

Consolidate

Function:

Reference:

All references:

Top row Left column

Create links to source data

Evaluate Formula

Cell:

Formula:

Evaluation Steps:

Result:

Data Table

Select the result range first, then specify input cells.

Row input cell:

Column input cell:

Scenario Manager

Solver

Set Objective:

To: Max Min Value of:

By Changing Cells:

Subject to Constraints:

Page Setup

Orientation: Portrait Landscape

Paper size:

Scaling:%

New from Template

Built-in Templates:

Saved Templates:

Workbook Theme

Select a theme:

Add Slicer

Select a field to create a slicer for the most recent pivot table:

Field:

Group Field

Field:

Group by:

Change Data Range

Data range (e.g. A1:C5):

Change Chart Type

Chart type:

Format Series Colors

Set colors for each data series:

Insert Sparkline

Data range (e.g. A1:A10):

Sparkline Options

Line/Bar Color:

Markers:

Show axis line at zero

Sparkline Options

Line/Bar Color:

Fill Color (area):

High Point Color:

Low Point Color:

First Point Color:

Last Point Color:

Negative Color:

Marker Color:

Get Data

CSV File JSON File HTML Table

Click to browse or drag & drop a file here

Delimiter: First row is header

SZ Spreadsheet - Free Online Excel Alternative with Formulas & Charts

Features