How to use MyOffice Spreadsheet

• About

Interface overview

• Screen elements
• Toolbar
• Quick actions box

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