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
About
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
Сhange the height of the bar
Quick actions pane
Workspace
Sheet tabs
Sidebar
Status bar
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
Sheets
Insert a sheet
Rename a sheet
Hide or unhide sheets
Duplicate a sheet
Change sheets order
Select a sheet from the list
Zoom a sheet
Hide or display zero values
Delete a sheet
Cells, columns, and rows
Expand the workspace
Select cell ranges
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
Define sort and filter range
Automatic detection of the sort and filter range
Sort
Single-level sorting
Sort by value
Sort by cell fill color
Sort by font color
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 date
Filter by numeric values
Reset all filters
Copy and paste filtered data
Refresh the filter
Finishing work with sorting and filtering range
Data validation
Add data validation
Edit data validation
Delete data validation
Actions with cells containing data validation
Enter a date
Enter a value in a cell with a drop-down list
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
Custom dictionary
Grammar check
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
Recalculation of formulas
Select formula recalculation mode
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 Function pane
Autosum
Function wizard
View and edit formulas
View the structure of formulas
Replace a formula with its result
Copy and insert formulas
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
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
Copy, cut or insert a chart
Change chart type
Resize a chart
Change data in chart
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 line
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
Delete shape outline
Line style
Select a line color
Select the thickness and line type
Apply the style of the previous line
Reset 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
Font formatting
Font сolor
Choose a color from the color sets provided
Specify the color code manually
Copy the color with an eyedropper
Highlight color
Alignment
Rotate text
Wrap text
Character spacing
Cell fill color
Choose a color from the color sets provided
Specify the color code manually
Copy the color with an eyedropper
Remove the fill color
Cell borders
Choose a color from the color sets provided
Specify the color code manually
Copy the color with an eyedropper
Apply the last selected border style
Delete borders
Conditional formatting
Create a formatting rule
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
Paste data and transpose
Clipboard history
Paste data
Clear the clipboard history
Automation tools
Macros
Create a macro
Find a macro
Run a macro
Edit a macro
Debug a macro
Delete a macro
View VBA macro code
Document protection
Protect content from changes
Protect a sheet
Protect the document structure
Unprotect a sheet
Unprotect sheet structure
Additional information
Key terms
List of functions
SUBTOTAL function
Keyboard shortcuts
Supported file formats
List of supported currencies
About
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
Сhange the height of the bar
Quick actions pane
Workspace
Sheet tabs
Sidebar
Status bar
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
Sheets
Insert a sheet
Rename a sheet
Hide or unhide sheets
Duplicate a sheet
Change sheets order
Select a sheet from the list
Zoom a sheet
Hide or display zero values
Delete a sheet
Cells, columns, and rows
Expand the workspace
Select cell ranges
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
Define sort and filter range
Automatic detection of the sort and filter range
Sort
Single-level sorting
Sort by value
Sort by cell fill color
Sort by font color
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 date
Filter by numeric values
Reset all filters
Copy and paste filtered data
Refresh the filter
Finishing work with sorting and filtering range
Data validation
Add data validation
Edit data validation
Delete data validation
Actions with cells containing data validation
Enter a date
Enter a value in a cell with a drop-down list
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
Custom dictionary
Grammar check
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
Recalculation of formulas
Select formula recalculation mode
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 Function pane
Autosum
Function wizard
View and edit formulas
View the structure of formulas
Replace a formula with its result
Copy and insert formulas
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
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
Copy, cut or insert a chart
Change chart type
Resize a chart
Change data in chart
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 line
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
Delete shape outline
Line style
Select a line color
Select the thickness and line type
Apply the style of the previous line
Reset 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
Font formatting
Font сolor
Choose a color from the color sets provided
Specify the color code manually
Copy the color with an eyedropper
Highlight color
Alignment
Rotate text
Wrap text
Character spacing
Cell fill color
Choose a color from the color sets provided
Specify the color code manually
Copy the color with an eyedropper
Remove the fill color
Cell borders
Choose a color from the color sets provided
Specify the color code manually
Copy the color with an eyedropper
Apply the last selected border style
Delete borders
Conditional formatting
Create a formatting rule
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
Paste data and transpose
Clipboard history
Paste data
Clear the clipboard history
Automation tools
Macros
Create a macro
Find a macro
Run a macro
Edit a macro
Debug a macro
Delete a macro
View VBA macro code
Document protection
Protect content from changes
Protect a sheet
Protect the document structure
Unprotect a sheet
Unprotect sheet structure
Additional information
Key terms
List of functions
SUBTOTAL function
Keyboard shortcuts
Supported file formats
List of supported currencies
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
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
