MyOffice Help Center

Products and documentation
Applications
Q&A

Purchase

How can we help you?

Home
Applications
How to use MyOffice Spreadsheet
Desktop version
Pivot tables
Customize the pivot table parameters

Customize the pivot table parameters

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

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
Specifics of work in the collaborative edit mode

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

Cloud actions

Log in
Server connection indicator and server certificate
Create a file or folder
Open a file
Save the file to the cloud
Create a local copy
Upload a file
Download a file or folder
Delete a file
Restore a file or folder
Shared access to files

Share a file
Change sharing settings
Revoke access to files

Revoke own access
Log out

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

Extensions

Install an extension
Run an extension
Automatic disabling of extensions
Enable or disable the extension
Update the extension version
Remove an extension

Document protection

Protect document with a password

Set a password
Change a password
Remove password
Open a document with a password

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

Product: MyOffice Professional, MyOffice Education

Application: Spreadsheet Desktop version

To configure the pivot table parameters, use the Options tab in the Pivot table settings pane.

Was this helpful?

Yes

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

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

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

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

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

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

Previous
Define the structure of the pivot table

Next
Manage external sources

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

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

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

Still have questions?

support@service.myoffice.ru

8 (800) 222-1-888

Ask a question

Solutions
About
Support
For partners

More
Info
Miscellaneous
Contacts

All products

Digital data processing and safety policy Condition of use Site map