MATRIXby TRONXVI
Your workspace

YOUR WORKSPACE

Welcome to MATRIX

Start with a blank workbook, pick a template, or open a recent file.

GET A HEAD START

Create with templates

PICK UP WHERE YOU LEFT OFF

Recent workbooks

Loading workbooks…
Ready
Σ
Selection calculations
1 × 1
100%

Workbook statistics

Save As

Save a separate copy of this workbook. The copy in MATRIX becomes active; the XLSX option downloads a file.

Insert Function

Select a function

SUM

Adds the values in a range.

SUM(number1, [number2], …)

Name Manager

Share workbook

Active links

Page Setup

Page margins (inches)

Number Format

Sample1234.50

Row Height

Unhide Sheet

Convert Text to Columns Wizard

Split values from .

Original data type
Delimiters

Data preview

Import Data

Preview

Data Validation

Apply these changes to .

Invalid value

Paste Special

Choose which parts of the copied cells to paste.

Paste
Options

Find and Replace

Wildcards can expand search. For example, “sm?th” finds “smith”.

Search options

Go To

Keyboard shortcuts

Use these shortcuts while the worksheet is selected.

Edit and clipboard

F2
Edit the selected cell
Enter
Commit an edit and move down
Alt + Enter
Insert a line break while editing an ordinary cell
Tab
Commit an edit and move right
Ctrl + C
Copy the selected cells
Ctrl + X
Cut the selected cells
Ctrl + V
Paste cells
Ctrl + Alt + V
Open Paste Special
Alt + =
Insert AutoSum
Alt + F1
Insert a chart from the selection
Ctrl + Q
Open Quick Analysis for the selected data
Alt + F2
Open Save As
Shift + F3
Insert a function
Ctrl + L
Format the selection as a table
Ctrl + Shift + L
Toggle AutoFilter for the selected range

Workbook

Shift + F11
Insert a worksheet
Ctrl + F1
Expand or collapse the ribbon
Ctrl + Z
Undo
Ctrl + Y
Redo
Ctrl + S
Save now
Ctrl + F
Find
Ctrl + H
Find and replace
Ctrl + G
Go To a cell or range

Calculation

F9
Recalculate the workbook
Ctrl + Shift + Alt + F9
Perform a full workbook calculation

Formatting

Ctrl + B
Bold
Ctrl + I
Italic
Ctrl + U
Underline
Ctrl + Shift + 1
Number, two decimals
Ctrl + Shift + 2
Time
Ctrl + Shift + 3
Date
Ctrl + Shift + 4
Currency
Ctrl + Shift + 5
Percentage
Ctrl + Shift + 6
Scientific
Ctrl + Shift + ~
General number format
Ctrl + Shift + 7
Outside border around selection

Selection

Ctrl + ↑ ↓ ← →
Move to the edge of the data region
Ctrl + Home
Go to the first cell
Ctrl + Page Up / Page Down
Switch worksheets
Delete
Clear selected cell contents

What's New

Recent spreadsheet tools in this MATRIX workspace.

New Script

Create a reusable script from worksheet actions.

Actions to run, in order

View Scripts

Scripts are saved for this workbook in this browser.

Automation Templates

Choose a workbook action to run.

Table Data as JSON

JSON data from the selected cells.

Conditional Formatting Rules Manager

Rule
Border sides