Part 3 of 7 · XLS editing
XLS — spreadsheets
The XLS page edits workbooks with the spreadsheet ribbon, a formula bar and the sheet tabs at the bottom of the grid.
Editing
Click a cell to edit in place, use the formula bar for longer entries, and switch sheets with the tabs under the grid. Formulas recalculate as you type. The ribbon covers number formats, styles, tables, charts and conditional formatting.
What each button does
| Button | Behavior |
|---|---|
| Open | Choose a workbook. The current one is replaced without a save prompt. |
| Save | Writes to the same file in its existing format. A workbook that has never been saved goes to Save As automatically. |
| Save As… | Saves a copy as .xlsx in the location you choose. |
| Export PDF | Exports the workbook exactly as it is on screen, formulas already evaluated. Unsaved edits are included. |
| Help | Opens this guide. |
Exporting PDF clones the workbook. The copy is evaluated and paginated independently, so exporting never disturbs the workbook you are editing, and open sheets keep their state.
Opening CSV and TSV files
Delimited text files open as ordinary sheets. When you save, they are written back in their own format rather than being quietly converted to a real workbook — use Save As… when you want a proper .xlsx.