TOP

File operations

Editing Files

In version 4.0.0, the layout of the editing screen has been changed, and the file data format has also been updated.

Basics

  1. Edit or delete cells
  2. Add rows and columns
  3. Change row height and column width
  4. Undo and redo
  5. Export files (CSV / PDF / Image)

Useful Features

  1. Merge and unmerge cells in a selected range
  2. Copy a selected range and paste it elsewhere
  3. Apply formatting to an entire range at once
  4. Clear the contents of a selected range all at once
  5. Move rows and columns
  6. Insert rows and columns at a specified position from the row/column menu
  7. Freeze rows and columns to keep headers visible
  8. Turn row numbers and column labels on or off
  9. Adjust grid color and grid line thickness
  10. Set default row height and column width

Details

  1. Basic formula rules
  2. List of supported functions
  3. How to use cell references and range references
  4. Tap cells to insert references while editing a formula
  5. Automatic adjustment of references when copying formulas (relative references)
  6. Causes of error messages and how to fix them (circular references, division by zero, invalid references)
  7. Output specifications (differences between CSV / PDF / Image / XLSX)
  8. XLSX export limitations
  9. Differences between the Free version and the PRO version
  10. Notes on working with large sheets
  11. Data compatibility and save format
  12. Troubleshooting

Settings

Please note that the layout of the buttons may have changed due to the version upgrade.