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
Desktop version
How to use MyOffice Spreadsheet
Desktop version
127
Desktop version
127
Desktop version macOS
124
Web version
94
Home Edition
109
Home Edition macOS
108
About
Key terms
Interface overview
Screen elements
Toolbar
Quick actions box
Demonstrate new features
Keyboard shortcuts
Language
Files
New file
Save as template
New from template
Open a file
Recent files
Open with
Save a file
Send a file
Import a file
Export to
Print document without entering the application
Preview and print
Close a file
Cells, columns, and rows
Expand the workspace
Select cell ranges
Resize cells
Merge or split 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
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
Data
Enter data
Sort and filter
Number formats
Check data
Remove duplicates
Links
Notes
Special characters
Current date or time
Check spelling
Find and replace
Delete data
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
Pivot tables
Create a pivot table
Customize a pivot table
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
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
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
Automation tools
Macros
Extensions
Edit content
Undo and redo
Clipboard
Appendices
Appendix A. List of functions
Appendix B. List of supported currencies
Document protection
Protect document with a password
Protect content from changes
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