MyOffice Help Center
Products and documentation
Applications
Q&A
Ru
En
Fr
Purchase
How can we help you?
Home
Applications
How to use MyOffice Spreadsheet
Home Edition
Formulas and functions
Structured references
Structured references
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
ABS
ACOS
ACOSH
ACOT
ASIN
ATAN
ATAN2
ATANH
COSH
COTH
CSC
CSCH
DEGREES
EXP
FACT
FACTDOUBLE
INT
LN
LOG
LOG10
PI
POWER
PRODUCT
QUOTIENT
RAND
ROUND
ROUNDDOWN
ROUNDUP
SEC
SECH
SINH
SQRT
SQRTPI
SUBTOTAL
SUM
SUMIF
SUMIFS
SUMPRODUCT
SUMSQ
TANH
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
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
ABS
ACOS
ACOSH
ACOT
ASIN
ATAN
ATAN2
ATANH
COSH
COTH
CSC
CSCH
DEGREES
EXP
FACT
FACTDOUBLE
INT
LN
LOG
LOG10
PI
POWER
PRODUCT
QUOTIENT
RAND
ROUND
ROUNDDOWN
ROUNDUP
SEC
SECH
SINH
SQRT
SQRTPI
SUBTOTAL
SUM
SUMIF
SUMIFS
SUMPRODUCT
SUMSQ
TANH
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
Application:
Spreadsheet Home Edition
You can use structured references in the
tables
.
Share:
Was this helpful?
Yes
No
Благодарим вас за обратную связь! Вы помогаете нам стать лучше.
Уточните, почему вам понравился материал:
Уточните, почему вам не понравился материал:
Найден ответ на мой вопрос
Инструкции помогли
Другая причина
Недостаточно информации в материале
Заголовок материала не соответствует содержанию
Текст сложен для понимания
Недостаточно фото-, видеоинструкций
Инструкции не помогли
Другая причина
Не более 250 символов
Пропустить
Отправить
Previous
Reference to data in another document
Next
Array formulas
Ask us a question
Your name:
*
E-mail:
*
Your question:
I agree to the processing of my
personal data
Send
We have received your message
and will get back to you shortly.
Close
