MyOffice Help Center
Products and documentation
Applications
Q&A
Ru
En
Fr
Purchase
How can we help you?
Home
Applications
How to use MyOffice Table
Desktop version macOS
General information
General information
Files
New file
Save as template
New from template
Open a file
Convert a file
Recent files
Preview and print
Save a file
Autorecovery of documents
Close a file
Sheets
Insert a sheet
Rename a sheet
Hide or unhide sheets
Duplicate a sheet
Change sheets order
Zoom a sheet
Hide or display zero values
Delete a sheet
Cells, columns, and rows
Expand the workspace
Select cell ranges
Resize cells
Merge or unmerge cells
Insert columns or rows
Select colums or rows
Hide or unhide a column or row
Resize a column or row
Freeze columns, rows, or area
Group columns or rows
Delete columns or rows
Data
Enter data
Sort and filter
Data validation
Remove duplicates
Links
Notes
Special characters
Current date or time
Check spelling
Find and replace
Delete data
Number formats
Identify cell format
Open number format settings window
General
Number
Currency
Accounting
Date, Time, and Date and Time
Percentage
Fraction
Scientific
Text
Formulas and functions
Formulas and functions basics
Order of operations in a formula
Reference cells and cell ranges
Recalculation of formulas
Automatic calculation
Enter functions
Replace a formula with its result
Copy and insert formulas
Names in formulas and functions
Reference to data in another document
Structured references
Calculation operators
Arithmetic operators
Comparison operators
Text concatenation operator
Reference operators
Tables
Create a table
Open the table settings pane
Table customization
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
Open the pivot table settings pane
Customize a pivot table
Customize the pivot table parameters
Collapse or expand the elements of pivot table
View cell details
Refresh a pivot table
Delete a pivot table
Charts
Create a chart
Chart settings
Move a chart
Copy, cut or insert a chart
Change chart type
Resize a chart
Change data in chart
Change chart data source
Delete a chart
Images
Insert an image
Resize an image
Move an image
Save an image
Delete an image
Shapes
Insert a shape
Fill a shape
Outline
Line style
Resize a shape
Fit shape size to text
Change line length and angle
Select arrow type
Move a shape
Delete a shape
Format
Font
Font size
Font formatting
Font сolor
Highlight color
Alignment
Rotate text
Wrap text
Character spacing
Cell background color
Cell borders
Copy and apply formatting
Edit content
Undo and redo
Clipboard
Cloud actions
Log in
Open a file
Create a local copy
Create a file or folder
Upload a file
Download a file or folder
Delete a file
Restore a file or folder
Shared access to files
Collaboration
Revoke own access
Log out
Automation tools
Macros
Extensions
Document protection
Protect document with a password
Protect content from changes
Appendices
Appendix A. List of functions
Appendix B. List of supported currencies
General information
Files
New file
Save as template
New from template
Open a file
Convert a file
Recent files
Preview and print
Save a file
Autorecovery of documents
Close a file
Sheets
Insert a sheet
Rename a sheet
Hide or unhide sheets
Duplicate a sheet
Change sheets order
Zoom a sheet
Hide or display zero values
Delete a sheet
Cells, columns, and rows
Expand the workspace
Select cell ranges
Resize cells
Merge or unmerge cells
Insert columns or rows
Select colums or rows
Hide or unhide a column or row
Resize a column or row
Freeze columns, rows, or area
Group columns or rows
Delete columns or rows
Data
Enter data
Sort and filter
Data validation
Remove duplicates
Links
Notes
Special characters
Current date or time
Check spelling
Find and replace
Delete data
Number formats
Identify cell format
Open number format settings window
General
Number
Currency
Accounting
Date, Time, and Date and Time
Percentage
Fraction
Scientific
Text
Formulas and functions
Formulas and functions basics
Order of operations in a formula
Reference cells and cell ranges
Recalculation of formulas
Automatic calculation
Enter functions
Replace a formula with its result
Copy and insert formulas
Names in formulas and functions
Reference to data in another document
Structured references
Calculation operators
Arithmetic operators
Comparison operators
Text concatenation operator
Reference operators
Tables
Create a table
Open the table settings pane
Table customization
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
Open the pivot table settings pane
Customize a pivot table
Customize the pivot table parameters
Collapse or expand the elements of pivot table
View cell details
Refresh a pivot table
Delete a pivot table
Charts
Create a chart
Chart settings
Move a chart
Copy, cut or insert a chart
Change chart type
Resize a chart
Change data in chart
Change chart data source
Delete a chart
Images
Insert an image
Resize an image
Move an image
Save an image
Delete an image
Shapes
Insert a shape
Fill a shape
Outline
Line style
Resize a shape
Fit shape size to text
Change line length and angle
Select arrow type
Move a shape
Delete a shape
Format
Font
Font size
Font formatting
Font сolor
Highlight color
Alignment
Rotate text
Wrap text
Character spacing
Cell background color
Cell borders
Copy and apply formatting
Edit content
Undo and redo
Clipboard
Cloud actions
Log in
Open a file
Create a local copy
Create a file or folder
Upload a file
Download a file or folder
Delete a file
Restore a file or folder
Shared access to files
Collaboration
Revoke own access
Log out
Automation tools
Macros
Extensions
Document protection
Protect document with a password
Protect content from changes
Appendices
Appendix A. List of functions
Appendix B. List of supported currencies
Application:
Spreadsheet Desktop version macOS
Share:
Was this helpful?
Yes
No
Благодарим вас за обратную связь! Вы помогаете нам стать лучше.
Уточните, почему вам понравился материал:
Уточните, почему вам не понравился материал:
Найден ответ на мой вопрос
Инструкции помогли
Другая причина
Недостаточно информации в материале
Заголовок материала не соответствует содержанию
Текст сложен для понимания
Недостаточно фото-, видеоинструкций
Инструкции не помогли
Другая причина
Не более 250 символов
Пропустить
Отправить
Next
Files
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
