MyOffice Help Center

Products and documentation
Applications
Q&A

Purchase

How can we help you?

Home
Applications
How to use MyOffice Spreadsheet
Desktop version
Charts

Charts

General information

About
Abbreviations
Key terms

Before you begin

Install the application
License agreement
Subscription activation

Subscribe
Enter activation code
Log in to your account
Offline work
Subscription details

Interface overview

Screen elements
Command menu
Main menu
Toolbar

Change the display mode
Hide or display tool group titles
Hide or display the content of tool groups
Customize the composition of the Favorites group of tools

Add a button
Change a button to run a macro
Move an element
Delete an element
Clear the Favorites group

Hide or display the Favorites group

Formula bar

Range field
Input field
Change the height of the bar

Quick actions pane
Workspace
Sheet tabs
Sidebar
Status bar
Focus on cell
Theme
Language

Files

New file
Save as template
New from template

Configure automatic template selection
Select a template manually

Open a file

File in .xls format
File in .xlsb format
File in .xml format
View-only file
File is used by another application or user

Convert a file
Recent files
Send a file
Preview and print

Print document without opening the application
While working in the application

Select the print area
Print with presets
Page break parameters
Quick print

Save a file

Save as
Save

Autorecovery of documents

Configure autorecovery of documents
Document recovery
Recovered files pane

Close a file

Cells, columns, and rows

Expand the workspace
Select a cell range
Active cell of the range
Select colums or rows
Multiple selection
Resize cells
Resize a column or row

Change the size manually
Adjust automatically
Specify the exact size

Merge or unmerge cells
Insert columns or rows
Hide or unhide a column or row
Freeze columns, rows, or area
Group columns or rows
Delete columns or rows

Data

Enter data

Enter data in a cell
Automatically adjust cell width
Floating cell
Autofill cells
Text formatting of formulas and numbers

Sort and filter

Create a range of filtering
Sort

Single-level sorting

Sort by value
Sort by cell fill color
Sort by font color
Sort by icons
Sort with user lists

Operations with lists and list items

Multi-level sorting

Create a multi-level sorting
Operations with levels
Edit a multi-level sorting

Filter

Filter by values
Filter by cell fill color
Filter by condition

Filter by numeric values
Filter by date
Filter by text
Filter using the advanced filter
Transfer of conditions between filters

Use of wildcards
Clear filter

Clear filter by value
Clear filter by condition or cell fill color
Clear all filters

Copy and paste filtered data
Reapply a filter
Finish work with sorting and filtering range

Split into columns
Data validation

Add data validation
Edit data validation
Remove data validation
Actions with cells containing data validation
Enter a date
Enter a value in a cell with a drop-down list

Track and view changes
Find and replace
Delete data
Remove duplicates
Links

Insert a link to a web page or email address
Insert a link to a place in the document
Insert a link to a file
Quick link insertion
Follow the link
Copy a link
Edit a link
Delete a link
Keyboard shortcuts for moving between window elements

Notes

Create a note
Edit a note
Delete notes

Special characters

Quick insert special characters pane
Special characters window

Current date or time
Spelling and grammar

Check spelling
Grammar check
Custom dictionary

Number formats

Define cell format
Open number format settings window
General
Number

Split the number into digit groups
Change the number of decimal places
Customize negative number display style

Currency

Select a currency code or symbol
Change the number of decimal places
Customize negative number display style

Accounting

Select a currency code or symbol
Change the number of decimal places

Date, Time, and Date and time

Using formats in calculations
Change the date and/or time display format

Percentage
Fraction
Scientific
Text

Formulas and functions

Formulas and functions basics
Order of operations in a formula
Reference cells and cell ranges

А1 cell reference style
R1C1 reference style
Cell range reference
Quick change of reference type

Recalculation of formulas

Select formula recalculation mode
Sheets

Insert a sheet
Switch to another sheet
Rename a sheet
Hide or unhide sheets
Change the color of the sheet tab
Duplicate a sheet
Copy a sheet
Move a sheet
Select a sheet from the list
Zoom a sheet
Hide or display zero values
Delete a sheet

Recalculation of formulas in automatic mode
Recalculate formulas manually
Recalculate formulas when saving a document

Automatic calculation
Enter functions

Enter into a cell or the Formula bar
Enter using the Insert function pane
Autosum

Function wizard

View and edit formulas
View the structure of formulas

Replace a formula with its result
Names in formulas and functions

Define name
Find a name

Find a name using the range field
Find using Name manager

Enter a name into formula or function
View name properties
Delete a name

Reference to data in another document

Create a reference with a mouse click
Enter the reference manually
Update data

Structured references

Use of structured references
Structured reference syntax
Enter a structured reference in a formula

Array formulas

Create an array formula
Manual input of arrays
Use of named arrays
Use of mathematical operators
Use of comparison operators
Edit array formulas
Copy and past array formulas
Delete array formulas

Calculation operators

Arithmetic operators
Comparison operators
Text concatenation operator
Reference operators

Tables

Create a table
Open the table settings pane
Customize the appearance
Rename the table
Automatic table expansion
Add a calculated column
Select the type of calculation in the total row
Convert a table to a regular range
Delete a table

Pivot tables

Create a pivot table

Create a pivot table based on the data in the current file
Create a pivot table based on data from an external source

Open the pivot table settings pane
Define the structure of the pivot table

Add fields
Change the field order in a section
Rename a field
Select value calculation functions

Select a function for the main calculation
Select a function for additional calculation

Delete a pivot table field

Customize the pivot table parameters

Change the data source
Select the pivot table layout
Customize the display of grand totals
Customize the display of subtotals
Enable viewing of cell details
Edit captions

Manage external sources

View the list of external sources
View information about an external source
Change information about an external source
Add an external source
Delete an external source

Filter data in a pivot table

Filter data using the report filter
Filter rows and columns by values
Filter rows and columns by condition
Clear the filter

Sort data in a pivot table
Collapse or expand the elements of pivot table
View cell details
Refresh a pivot table
Copy a pivot table
Delete a pivot table

Charts

Insert a chart
Open the chart settings pane
Chart settings
Open chart elements settings
Customize the appearance of an element
Customize element text formatting
Adjust the parameters of axes and gridlines
Hide or display an element
Move a chart
Move the chart title
Copy, cut or insert a chart
Change chart type
Resize a chart
Change source data
Change the data range for the chart
Delete a chart or a chart element

Images

Insert an image

Insert an image from computer
Insert image from browser or other editor

Replace an image
Resize an image
Move an image
Save an image
Delete an image

Shapes

Insert a shape
Insert a text box
Fill a shape

Fill a shape with color
Fill a shape with image
Remove the fill color

Outline

Select the color of the shape outline
Select the thickness and line type of the shape outline
Apply outline settings of the previous shape
Remove the shape outline

Line style

Select a line color
Select the thickness and line type
Apply the style of the previous line
Remove the line style

Resize a shape
Fit shape size to text
Change line length and angle
Select arrowhead type
Move a shape
Delete a shape

Format

Font
Font size
Text formatting
Text color
Highlight color
Alignment
Rotate text
Wrap text
Character spacing
Cell fill color
Cell borders
Conditional formatting

Create a formatting rule
Create a rule of the Regular highlighting type
Create a rule of the Color scale type
Create a rule of the Data bars type
Create a rule of the Icons type
Clear formatting rules

Copy and apply formatting

Copy and paste formatting rules
Copy and apply formatting
Formatting history

Clear formatting

Edit content

Undo and redo
Cut or copy data
Paste the last cut or copied data

Paste data while maintaining the original formatting
Paste data without preserving the original formatting
Insert a formula
Insert the result of the formula calculation
Paste data and transpose

Clipboard history

Paste data
Clear the clipboard history

Change paste parameters

Automation tools

Macros

Macros in Lua

Create a macro
Find a macro
Run a macro
Edit a macro
Debug a macro
Delete a macro

Macros in VBA

Convert VBA macro code
Rewrite the macro code

Document protection

Protect content from changes

Protect a sheet
Protect the document structure
Unprotect a sheet
Unprotect sheet structure

Functions manual

Financial functions

COUPPCD
DOLLARDE
DOLLARFR
IRR
NPV
PMT
PV
XNPV

Date and time functions

DATE
DATEDIF
DATEVALUE
DAY
EDATE
EOMONTH
HOUR
ISOWEEKNUM
MINUTE
MONTH
NOW
TODAY
YEAR
YEARFRAC

Math and trig functions

Statistical functions

AVERAGE
AVERAGEIF
CORREL
COUNT
COUNTA
COUNTBLANK
COUNTIF
COUNTIFS
F.DIST
F.DIST.RT
FISHER
LARGE
LINEST
MAX
MEDIAN
MIN
MODE
NORM.DIST
RANK.EQ
SMALL
STDEV.S
VAR
VARA
VARPA

Lookup and reference functions

ADDRESS
AREAS
CHOOSE
COLUMN
COLUMNS
GETPIVOTDATA
HLOOKUP
HYPERLINK
INDEX
INDIRECT
LOOKUP

Vector form
Array form

MATCH
OFFSET
ROW
ROWS
TRANSPOSE
VLOOKUP

Database functions

DSUM

Text functions

ASC
CLEAN
CODE
CONCATENATE
DBCS
EXACT
FIND
FINDB
JIS
LEFT
LEFTB
LEN
LENB
LOWER
MID
MIDB
PROPER
RIGHT
RIGHTB
SEARCH
SEARCHB
SUBSTITUTE
TEXT
TRIM
UNICODE
UPPER
VALUE

Logical functions

AND
FALSE
IF
IFERROR
IFNA
OR
SWITCH
TRUE

Information functions

CELL
ISBLANK
ISERR
ISERROR
ISEVEN
ISLOGICAL
ISNA
ISNUMBER
ISODD
ISREF
ISTEXT
NA

Engineering functions

COMPLEX
IMABS

Additional information

Keyboard shortcuts
Supported file formats
List of supported currencies
List of supported methods

Product: MyOffice Professional

Application: Spreadsheet Desktop version

MyOffice Spreadsheet provides the ability to create and edit charts of various types.

Share:

Was this helpful?

Yes

No

Благодарим вас за обратную связь! Вы помогаете нам стать лучше.

Уточните, почему вам понравился материал:

Уточните, почему вам не понравился материал:

Найден ответ на мой вопрос
Инструкции помогли
Другая причина

Недостаточно информации в материале
Заголовок материала не соответствует содержанию
Текст сложен для понимания
Недостаточно фото-, видеоинструкций
Инструкции не помогли
Другая причина

Не более 250 символов

Previous
Pivot tables

Next
Images

Мы используем cookie-файлы и другие технологии для улучшения работы сайта.

Подробную информацию Вы можете найти в Политике конфиденциальности

Согласен, больше не показывать

Still have questions?

Contact us

support@service.myoffice.ru

8 (800) 222-1-888

Ask a question

Solutions
About
Support
For partners

More
Info
Miscellaneous
Contacts

All products

Log in

© New Cloud Technologies Ltd., 2013–2026. All rights reserved.

Digital data processing and safety policy Condition of use Site map

Ask us a question

Your name: *

E-mail: *

Your question:

I agree to the processing of my personal data

We have received your message

and will get back to you shortly.