Jadwal Help
Sheets
34 articles
Get started
- Get started with JadwalJadwal is your Woosool spreadsheet: enter data, calculate with formulas, analyse and chart it, together.
- Create a spreadsheet or start from a templateStart a blank spreadsheet or use a ready-made template such as a budget or invoice.
- Import and download spreadsheetsOpen .xlsx, CSV and TSV files in Jadwal and download your work as .xlsx, CSV, PDF or text.
- How saving worksJadwal saves automatically, keeps changes while you're offline and retries when saving fails.
- Jadwal keyboard shortcutsThe keyboard shortcuts for editing, formatting and moving around a spreadsheet.
Enter data and format cells
- Enter and edit dataType numbers, text, dates and percentages, edit cells and add line breaks.
- Format numbers, dates and currenciesShow numbers as currency, percentages, dates, times or with a fixed number of decimals.
- Format cells, borders and alignmentChange fonts, colours, borders, alignment and text wrapping, and merge cells.
- Manage rows, columns and sheetsInsert, delete, hide and resize rows and columns, and add, rename or hide sheets.
- Fill cells and series automaticallyDrag the fill handle to copy values or continue series such as dates, numbers and weekdays.
- Freeze rows and columnsKeep headers visible while you scroll, and split the window into panes.
Formulas and functions
Organise and analyse data
- Sort and filter dataSort rows by one or more columns and show only the rows you need.
- Use tablesTurn a range into a table with a style, filters, banded rows and a totals row.
- Highlight cells with conditional formattingColour cells automatically by their value, with colour scales, data bars or your own formula.
- Add drop-down lists and validation rulesLimit what people can enter in cells, with drop-down lists, checkboxes and rules.
- Summarise data with a pivot tableGroup and total large lists by any column with a pivot table.
- Get data from files, the web and KhaznaImport and clean data from CSV, JSON, XML, web pages, other workbooks and Khazna folders.
- Goal Seek, Solver and forecastsFind the input that gives a result, optimise a model, or forecast a trend.
Charts and pictures
Share and collaborate
- Share a spreadsheet and edit togetherInvite people to view, comment or edit, share a link, and work on the same sheet at once.
- Add comments and notesDiscuss a cell with comments, or attach a note to it.
- Protect sheets and rangesStop people from changing a sheet or some cells, even if they can edit the spreadsheet.
- See and restore earlier versionsGo back to an earlier version of a spreadsheet, or see what changed recently.