Use Spreadsheets in the mobile app
Create, import and edit a spreadsheet in the mobile app, and find sheets, filter views, collaborators and export in its menu.
The mobile app lists the spreadsheets in Personal or the selected team, and those shared with you.
- New makes a blank spreadsheet and opens it.
- Import makes one from a CSV or TSV file.
- Swipe a row to move a spreadsheet to Trash.
The grid
A spreadsheet opens on its grid, which scrolls over the whole sheet. Formulas are calculated on the phone, with the same results as on the website. Frozen rows and columns stay in place, and the sheet's tabs are under the grid; + Sheet adds one.
- Tap a cell to select it, and tap it again to type in it. The bar above the grid shows what the cell holds; Enter saves it and moves down. While you type a formula, the bar offers the functions that match and shows the argument you are on.
- Drag the round handle at the corner of the selection to select more cells. Tap a column letter or a row number to select the column or row, and tap another to select several.
- The cell name at the left of the bar opens Go to: type a cell such as
B120, a range such asA1:D20, a column such asCor rows such as5:9. - Hold a cell, or use Edit, to cut, copy, paste, clear, fill down or right, and insert or delete rows and columns.
- Format sets bold, italic, underline, wrapping, alignment, the number format and the text and fill colours of the selection.
- Rows and columns inserts and deletes rows and columns, sets column widths, freezes rows and columns, and merges cells.
- Data sorts the selection, turns the sheet's filter on or off, and adds or removes data validation and conditional formatting rules.
Undo and saving
Undo and Redo are the first tools under the grid. Everything saves as you go. If the spreadsheet changed somewhere else since you opened it, the app stops saving and offers Load the latest version, rather than overwriting the newer version.
The menu
The menu has Rename…, Find and replace, Manage sheets, Filter Views (your own filters, shown in the grid), Collaborators, Export CSV, Share spreadsheet link, Move to another team and Move to Trash. The app shows tables, groups, charts, named ranges and named functions and calculates with them. They are made on the website.
If a spreadsheet does not open or save in the app, Contactar con soporte.
Preguntar al soporte de Magpie
Envía al equipo de Magpie una pregunta sobre cualquier cosa que este artículo no responda.