How to use MyOffice Spreadsheet

• About

Interface overview

• Screen elements
• User profile
• Keyboard shortcuts
• Key terms

Files

• New file
• Upload and open
• Open a file
• Save a file
• Save as template
• New from template
• Create a new version
• Create a copy
• View a file
• Print a file
• Mark a file
• Recent files
• Rename a file
• Download a file
• Send via email
• Share a file
• Request access
• Share a link
• Close a file
• Collaboration

Cells, columns, and rows

• Expand the workspace
• Cell ranges
• Named range
• Merge or split cells
• Reference cells and cell ranges
• Сolumns and rows
• Sort and filter

Sheets

• Insert a sheet
• Rename a sheet
• Hide or unhide sheets
• Hide or display zero values
• Duplicate a sheet
• Change sheets order
• Zoom a sheet
• Delete a sheet

Data

• Enter data
• Number formats
• Validate the data
• Links
• Link to a location in file
• Notes
• Insert current date or time
• Spellchecker
• Find and replace
• Delete duplicates

Formulas and functions

• Formulas and functions basics
• Automatic calculation
• Enter functions
• Copy and insert formulas
• Order of operations in a formula

Calculation operators

• Arithmetic operators
• Comparison operators
• Text concatenation operator 
• Reference operators

Charts

• Chart
• Create a chart
• Chart settings
• Copy, cut or insert a chart
• Change chart type
• Resize a chart
• Change data in chart
• Change chart data source
• Move a chart
• Delete a chart

Images

• Image
• Insert an image
• Resize an image
• Move an image
• Delete an image

Shapes

• Features and limitations
• Insert and delete a shape
• Add content
• Resize and move a shape
• Edit a shape

Pivot tables

• Create a pivot table
• Pivot table settings pane
• Pivot table structure
• Configure the pivot table settings
• Refresh a pivot table
• Filter pivot table data
• Delete a pivot table

Format

• Font
• Font size
• Font formatting
• Font color
• Highlight color
• Alignment
• Rotate text
• Wrap text
• Character spacing
• Cell background color
• Cell borders
• Copy and apply formatting
• Macros

Data protection

• Work with protected tables

Appendices

• Appendix A. List of supported currencies
• Appendix B. List of functions