Grafos

Grid — Spreadsheets

The Grafos spreadsheet. It opens and saves .xlsx in the ECMA-376 format and recalculates on your machine, without internet.

Edit cells

Type in the cell and press Enter. F2 edits the cell; Esc cancels. Fill down or right and go straight to a cell or range.

Where:F2 / Enter / Esc · Ctrl+D and Ctrl+R · F5 (Go To)

Step by step

  1. Click the cell and type the value or the formula.
  2. Press Enter to confirm and move down.
  3. To fill, select the cell with the value and the ones below it and press Ctrl+D.
  4. To go far, press F5, type the reference (e.g. B200) and click Go To.

Tips

  • The status bar shows the sum, average, count, minimum and maximum of the selection; right-click it to choose what appears.
Grid with a household budget: formula bar, grid, sheet tabs and status bar.

Copy and paste

Paste without formatting pastes only the values. Paste special chooses between values, formulas and formats, transposes and does arithmetic with what is already in the cells.

Where:Edit › Paste without formatting · Ctrl+Shift+V · Edit › Paste special… · Ctrl+Alt+V

Step by step

  1. Copy the cells.
  2. Select the destination and click Edit › Paste special….
  3. Choose Values, Formulas or Formats; check Transpose to turn rows into columns.
  4. Under Operation, choose add, subtract, multiply or divide, if needed, and confirm.

Rows, columns and sheets

Insert and delete rows and columns, change height and width, hide and unhide. Add, rename, color, hide and move sheets.

Where:Insert › Insert rows above · Insert › Insert columns left · Right-click the cell or the header · Right-click the sheet tab · Ctrl+Space and Shift+Space

Step by step

  1. Click the cell where the new row should go.
  2. Click Insert › Insert rows above.
  3. For a sheet, right-click its tab and choose rename, the color, hide or move.
  4. The button next to the sheet tabs creates a new sheet.

Tips

  • Ctrl+PageDown and Ctrl+PageUp go to the next and the previous sheet.

What it does not do

  • You cannot delete or hide the only sheet.
  • A sheet that is still loading stays read-only until it finishes.

Formulas and functions

The formula bar suggests functions and shows the syntax. Function names work in English, and the Portuguese names work too. Auto sum, absolute references with F4 and named ranges.

Where:Formula bar · Insert › Auto sum · Alt+= · Insert › Named range…

Step by step

  1. Click the cell and type = and the start of the function name.
  2. Choose the function in the list and fill in the arguments.
  3. While pointing at a cell, press F4 to cycle between A1, $A$1, A$1 and $A1.
  4. To name a range, click Insert › Named range… and fill in the name and the range in the Name Manager.

Tips

  • The #NAME?, #REF!, #DIV/0! and #VALUE! errors come with an explanation when you hover over them.

What it does not do

  • If the file uses a function Grid does not calculate yet, it keeps the stored value and warns you; if a cell it depends on changes, the out-of-date badge appears.

Number format

Currency, accounting, percentage, thousands separator, date, decimal places and custom formats.

Where:Format › Number · Format › Number › More number formats… · Toolbar › Currency / %

Step by step

  1. Select the cells.
  2. Click Format › Number and choose the format.
  3. For more options, click More number formats…, choose the category and adjust decimal places, symbol and negatives.
  4. Under Custom, type the format code and check the preview.

Tips

  • Percentage stores the fraction: 0.5 shows as 50%.

What it does not do

  • The format rounds only what is shown; the status bar warns when the sum of what is shown differs from the total.
Format Cells dialog with the number tab open.

Cell appearance and styles

Font, text color, fill, borders and alignment. Merge cells, wrap text and copy formatting with the painter. Ready-made cell styles or your own.

Where:Format › Text · Format › Merge cells · Format › Merge and center · Format › Wrap text · Format › Format painter · Format › Cell styles…

Step by step

  1. Select the cells.
  2. Use Format › Text for bold, text color and fill color.
  3. To apply a style, click Format › Cell styles… and choose one (Good, Bad, Neutral, Heading 1, Total, Currency…).
  4. To create your own, format a cell, type the new style name and click Create from selection.

What it does not do

  • You cannot sort a range that has merged cells.

Conditional formatting

Highlight cells by rule: values, duplicates, data bars, color scales and icon sets.

Where:Format › Conditional formatting…

Step by step

  1. Select the range.
  2. Click Format › Conditional formatting….
  3. On the New Rule tab, choose the rule type, the condition, the value and the colors.
  4. Click Create rule.
  5. To change or delete, use the Manage Rules tab.

What it does not do

  • A formula rule on a very large range is ignored, with a warning, so as not to slow the sheet down.
Conditional Formatting dialog over the budget sheet.

Sort

Sort by one or more columns, in ascending or descending order.

Where:Data › Sort and filter › Sort…

Step by step

  1. Click a cell in the data.
  2. Click Data › Sort and filter › Sort….
  3. Check My data has headers, choose the column and the order.
  4. Click Add level for a second criterion and confirm.
Sort dialog with two sort levels.

Filters

Filter by column, by condition (greater than, contains, between dates, top 10…), by color or with an advanced criteria filter.

Where:Data › Sort and filter › Create filter · Data › Sort and filter › Filter by condition… · Data › Sort and filter › Filter by color · Data › Sort and filter › Advanced filter… · Data › Sort and filter › Clear filters · Alt+↓

Step by step

  1. Click a cell in the data and click Data › Sort and filter › Create filter: the header gets the funnel.
  2. Click the funnel (or press Alt+↓ on the header) and check the values that should show.
  3. For a rule, click Filter by condition… and choose, for example, "Greater than…" or "Contains…"; Custom filter… lets you combine two conditions.
  4. To remove all filters, click Clear filters.

Tips

  • In Advanced filter…, conditions on the same row apply together; on different rows, one is enough. Choose Filter the list in place or Copy to another location.

What it does not do

  • The advanced filter works with the list and the criteria on the same sheet.
Custom filter dialog for column C, with two conditions (greater than and less than) combined with And.

Slicers and timeline

Buttons to filter a column with one click, and a timeline to filter dates by year, quarter or month.

Where:Data › Sort and filter › Slicer… · Data › Sort and filter › Timeline…

Step by step

  1. Click a cell in the column you want to filter.
  2. Click Slicer… (or Timeline…, for a date column).
  3. Click the buttons or the periods to filter; Clear undoes it.

What it does not do

  • The column is the one of the active cell: there is no dialog to choose another.

Data tools

Data validation, column type, remove duplicates, text to columns, flash fill, consolidate and subtotals.

Where:Data › Data tools

Step by step

  1. To validate, select the cells and click Data › Data tools › Data validation….
  2. Choose what to allow (whole number, list, date…), the source and the error alert.
  3. To split "First Last" into two columns, use Text to columns… and choose the delimiter.
  4. For flash fill, type one or two examples in the next column and press Ctrl+E.

Tips

  • Column type… locks the column to a type (Text, Number, Date, Yes/No…) and refuses a value of another type as you type.

What it does not do

  • The validation drop-down arrow is not drawn yet: type the value (Alt+↓ opens the list).
Data menu open in Grid, with Sort and filter, Data tools, Table and CSV.

Tables

Turn a range into a styled table, rename it and add a totals row. Formulas can refer to the table by name, as in Sales[Total].

Where:Data › Table › Format as table… · Data › Table › Rename table… · Data › Table › Insert totals row

Step by step

  1. Select the range and click Data › Table › Format as table….
  2. Check the range, choose the style and check My table has headers.
  3. To change the name, click a cell in the table and use Rename table…: the formulas that refer to it follow.

What it does not do

  • A table cannot overlap another.
  • There are three table styles.

Pivot tables and pivot charts

Summarize a large table: group and total without formulas, edit the fields later and create a chart linked to the pivot.

Where:Insert › Pivot table… · Data › PivotTable fields · Data › Refresh pivot table · Insert › PivotChart

Step by step

  1. Select the data and click Insert › Pivot table….
  2. Check the source range and the destination cell.
  3. Drag the fields to Filters, Columns, Rows and Values and choose the calculation (Sum, Count, Average, Max or Min).
  4. Later, click a cell in the pivot and use Data › PivotTable fields to change fields and layout.
  5. With the cell inside the pivot, click Insert › PivotChart.

Tips

  • Changed the source data? Use Data › Refresh pivot table.

What it does not do

  • A pivot with a calculated field, an OLAP source or a source outside this workbook, or layout options Grid does not reproduce, opens read-only.
Pivot table dialog with the sheet fields.

Charts and sparklines

Create charts from the selection and edit data, axes, legend, labels and series. Sparklines fit inside a cell.

Where:Insert › Chart… · Insert › Sparkline…

Step by step

  1. Select the data.
  2. Click Insert › Chart…, choose the type and, if you want, a title.
  3. Confirm: the chart goes over the sheet.
  4. Double-click the chart to edit data, axes, legend, data labels and series.
  5. For a sparkline, click Insert › Sparkline… and choose the type, the data and the destination cell.

What it does not do

  • Changing the type of a chart that came from the file rebuilds the chart and loses the original formatting.
  • In the newer types (histogram, box, funnel, Pareto, treemap, sunburst, map) only the title can be edited, and they do not come out in the PDF.
Insert chart dialog with the choice of chart type.

Images, shapes and text boxes

Place images, shapes and text boxes over the sheet.

Where:Insert › Image… · Insert › Shape · Insert › Text box

Step by step

  1. Click Insert › Image… and choose the file.
  2. Drag to move and pull the edges to resize.
  3. Double-click a shape to type inside it.

What it does not do

  • PNG, JPEG or GIF images up to 10 MB.
  • EMF/WMF drawings and freeform shapes in the file are kept, but not shown.

What-if analysis

Goal seek finds the input value for a result. Solver optimizes with constraints. Scenarios compare sets of values. A data table shows the result for several input values.

Where:Tools › Goal seek… · Tools › Solver… · Tools › Scenario manager… · Data › What-if analysis › Data table…

Step by step

  1. Click Tools › Goal seek….
  2. Fill in Set cell (the formula), To value (the result you want) and By changing cell (the input).
  3. Click Calculate.
  4. In Solver…, choose the objective cell, the goal (maximum, minimum or a value), use Add cell and Add constraint, and click Solve.

Formula auditing

See where a cell’s value comes from and where it goes, with arrows, and evaluate a formula step by step.

Where:Tools › Formula auditing › Trace precedents · Tools › Formula auditing › Trace dependents · Tools › Formula auditing › Remove arrows · Tools › Formula auditing › Evaluate formula…

Step by step

  1. Click the cell with the formula.
  2. Click Tools › Formula auditing › Trace precedents: the arrows show the cells it uses.
  3. To see a calculation in parts, click Evaluate formula… and click Evaluate at each step.
  4. Click Remove arrows to clear.

Tips

  • A reference to another sheet shows as an icon: click it to see it and go there.

What it does not do

  • Arrows do not lead to another workbook.
  • Volatile functions (NOW, RAND) may give a different value when evaluated.
Sheet with trace precedents arrows linking the cells a formula uses.

Calculation

Grid recalculates on its own. In heavy sheets, switch to manual calculation and calculate when you want.

Where:Tools › Calculation › Calculate now · F9 · Tools › Calculation › Calculate sheet · Shift+F9 · Tools › Calculation › Manual calculation · Tools › Calculation options…

Step by step

  1. Click Tools › Calculation › Manual calculation.
  2. Edit freely.
  3. Press F9 to calculate everything, or Shift+F9 for only the sheet on screen.

Tips

  • In Calculation options…, Enable iterative calculation resolves intentional circular references.

SQL query over sheets

Write SQL over the workbook’s sheets: each sheet is a table and each column can be named by its letter or its header. The result goes to a new sheet or to a cell.

Where:Data › SQL query… · Ctrl+Shift+Q · Data › Refresh queries · Data › Query an external file…

Step by step

  1. Click Data › SQL query….
  2. Write the query, for example SELECT A, SUM(C) AS total FROM Sheet1 GROUP BY A.
  3. Click Run and check the preview.
  4. Choose New sheet or Starting at cell and click Insert result.
  5. When the data changes, click Data › Refresh queries.

Tips

  • A sheet with a space in its name goes in square brackets: FROM [Sales 2026].
  • The formula =SQLQUERY("SELECT …") spills the result straight into the grid.
  • Query an external file… adds a CSV, TSV, JSON, Parquet or SQLite database to the query without opening it in the grid.

What it does not do

  • Read-only: INSERT, UPDATE, DELETE and the like are refused.
  • Reads up to 2,000,000 rows per query.
  • Opening the file never runs the query by itself.
SQL query panel with a GROUP BY query, the result preview and the Insert result button.

Databases

Open a SQLite database as a spreadsheet (each table becomes a sheet) and save only what changed. Read tables from PostgreSQL, MySQL/MariaDB and SQL Server.

Where:File › Open · Data › Import › Database… · Data › Group by…

Step by step

  1. For SQLite, open the .sqlite, .sqlite3 or .db file from File › Open, edit and save with Ctrl+S.
  2. For a server, click Data › Import › Database… and choose the database.
  3. Fill in server, port, database, user and password; check Remember the password in the system vault if you want.
  4. Choose a table or write a query and click Read.

Tips

  • Group by… summarizes a large table (count, sum, average…) in a new sheet; View as SQL shows the equivalent query.

What it does not do

  • PostgreSQL, MySQL and SQL Server servers are read-only and only read when you click.
  • In SQLite, views and tables without a primary key open read-only, and Grid does not change the database structure.

Import CSV, JSON and Parquet

Bring in data from text and columnar files. A CSV with more rows than the grid opens as a preview you query with SQL.

Where:Data › Import › Import CSV… · Data › Import › Import JSON… · Data › Import › Import Parquet… · Data › Export as CSV… · Data › Export as TSV…

Step by step

  1. Click Data › Import › Import CSV….
  2. Choose the file, the delimiter, the encoding and the decimal separator.
  3. Check First line is header, check the preview and click Apply.

What it does not do

  • A CSV above 1,048,576 rows opens in a read-only Preview sheet, which does not go into the .xlsx.
  • The JSON must be a list of objects or JSON Lines.

JavaScript and Python scripts

Run a script over the selection or the whole sheet and put the result in the spreadsheet.

Where:Data › Script…

Step by step

  1. Select the data (the first row is the header) and click Data › Script….
  2. Choose the language: JavaScript or Python.
  3. Write the code; use print(…) for the console and output(x) for the result.
  4. Click Run and then Insert result.

Tips

  • The first time in Python, click Download Python: it is a one-time download, verified by signature.

What it does not do

  • The script cannot reach files, other sheets or the internet, and does not change the spreadsheet: it only returns data.
  • Python needs internet on first use; pandas and numpy are not included yet.
Script dialog with JavaScript code, the console and the result ready to insert.

Protect

Protect the sheet against editing and the workbook against creating, deleting or renaming sheets.

Where:Tools › Protect sheet… · Tools › Protect workbook…

Step by step

  1. Click Tools › Protect sheet….
  2. Type a password, if you want, and click Protect.

Tips

  • Only cells marked as Locked (in the cell format) are protected.

View

Freeze rows and columns, split the window, show or hide gridlines and see where page breaks fall.

Where:View › Freeze panes · View › Split · View › Gridlines · View › Page break preview

Print, page breaks and PDF

Adjust the scaling, the print area, the rows that repeat, the header and the footer. Add manual breaks and export PDF.

Where:Format › Page setup… · Format › Page breaks · File › Print… · File › Export › PDF…

Step by step

  1. Click Format › Page setup….
  2. On the Page tab, choose the scaling (percentage or fit to pages) and the Rows to repeat at top.
  3. On the Header/Footer tab, write the texts and insert page, date or file name.
  4. To force a break, click the cell and Format › Page breaks › Insert page break.
  5. Click File › Print….

What it does not do

  • A sheet that has not finished loading is not printed.

Large files

The visible sheet loads first and the rest in the background. The grid appears before the whole workbook finishes.

Where:Settings › Editor (Progressive spreadsheet opening)

AI in Grid (plugin)

With the AI plugin installed and set up, Grid creates a formula from what you describe, explains the formula in the cell and writes an SQL query over the sheets, using your own account with the AI provider.

Where:Plugins menu · Alt+Q and type AI

Step by step

  1. Click the cell where you want the formula (or the cell whose formula you want to understand).
  2. Choose AI: Create formula…, AI: Explain this formula or AI: Create SQL query… from the Plugins menu (or from Alt+Q).
  3. Check the preview for the exact text that will leave your computer and click Send, or Do not send to cancel.
  4. The answer arrives as a suggestion: nothing changes until you click Insert or Replace; Discard closes it without changing anything.

Tips

  • A single Ctrl+Z undoes what the AI inserted.
  • How to install and set up the plugin: Suite features page, AI with your own account section.

What it does not do

  • Do not send sends nothing.
  • Without the plugin, no AI command appears.

Grid shortcuts

Keys What it does
F2 Edit active cell
Enter Confirm edit / move down
Esc Cancel cell edit
Ctrl+D Fill down
Ctrl+R Fill right
F5 Go to cell/range
F9 Calculate now
Shift+F9 Calculate sheet
Alt+= Auto sum
F4 Toggle absolute reference ($)
Ctrl+Space Select whole column
Shift+Space Select whole row
Alt+↓ Open the cell list or the filter menu
Ctrl+PageDown Next sheet
Ctrl+PageUp Previous sheet
Ctrl+Shift+V Paste values only
Ctrl+Alt+V Paste special…
Ctrl+Shift+Q SQL query…
Ctrl+N New document
Ctrl+O Open file
Ctrl+S Save
Ctrl+Shift+S Save as… (also F12)
Ctrl+P Print
Ctrl+Shift+E Export PDF
Ctrl+Z Undo
Ctrl+Y Redo (also F4 and Ctrl+Shift+Z)
Ctrl+A Select all
Ctrl+F Find
Ctrl+H Find and replace
Alt+Q Command bar
Ctrl+Shift+P Command bar already in commands mode (>)
Ctrl+Shift+N New window
Ctrl+, Settings
F1 Help
Ctrl+/ All shortcuts
Esc Close dialog / cancel